[Bug] <dbt run --empty is not working with nested columns spectrum>

[gekas93]

Is this a new bug in dbt-redshift?

• I believe this is a new bug in dbt-redshift
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

Running dbt run --empty , we get a spectrum nested query error.

Database Error in model base_***** (models/base/*****/base_*****.sql)
  Spectrum nested query error

The compiled code is the following:

  create  table
    "DATABASE"."SCHEMA"."base_*****__dbt_tmp"
  as (
    select *
from
    (select * from "DATABASE"."SCHEMA"."TABLE" where false limit 0)
  );

If we remove the limit 0 or we remove the subquery having something like this:

  create  table
    "DATABASE"."SCHEMA"."base_*****__dbt_tmp"
  as (
    select * from "DATABASE"."SCHEMA"."TABLE" where false limit 0
  );

The query works on redshift.

Expected Behavior

dbt run --empty works on redshift spectrum.

Steps To Reproduce

1. To have some spectrum source with array column.
2. Create some model with select * to that source.
3. Run dbt run --empty

Relevant log output

No response

Environment

- OS: Mac
- Python:3.9.18
- dbt-core:1.8.1
- dbt-redshift:1.8.1

Additional Context

No response