Generate source does not work on External schema in Redshift

[tsrp25]

Describe the bug

Generate source macro does not work on External Schema tables in Redshift

Steps to reproduce

I am trying to use the Generate source macro on the tables in external schema in Redshift. It is not generating any output.

Expected results

Table metadata

Actual results

Only below is created where stage is an external schema in redshift

sources:

• name: stage
  description: ""
  tables:

Screenshots and log output

System information

The contents of your packages.yml file:

Which database are you using dbt with?

• postgres
• [X ] redshift
• bigquery
• snowflake
• other (specify: ____________)

The output of dbt --version:

DBT Cloud

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[github-actions]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.

[arindamsinhakeeper]

I am facing the same issue. codegen generate_source is not working on Redshift external schema

[mat-octave]

Me too. Using an external schema in Redshift. generate_source doesn't return any of the tables in the schema.

[arindamsinhakeeper]

Actually, I found out that it works for one table at a time, but not multiple tables.