search

dbt-labs / dbt-external-tables

dbt macros to stage external sources
https://hub.getdbt.com/dbt-labs/dbt_external_tables/latest/
Apache License 2.0
299 stars 120 forks source link

[feat] Support to create the external schema for redshift platform #232

Closed Eyescreaman closed 7 months ago

Eyescreaman commented 1 year ago

Describe the feature

On the redshift platofrm , user need to create external schema first and then create external table.

dbt-external-tables already has the ability to creating external table but no exteranl schema. This sometimes will break the attention to data transform task.

Currently the sources.yml already has [schema] field , so if it could add the new fields such as iam role and external db name , then dbt-external-tables lib may have the creating external schema ability ?

Describe alternatives you've considered

User should use another redshift client tool or the fake model which just only be used to create external schema by pre-hook config.

Additional context

Snowflak and BigQuery seems to have the external schema ability. It there any consideration to the redshift ?

Who will this benefit?

Developer could do the all things by dbt-external-tables. They don't need to use the other tool to create external schema and then use dbt to create external table.

github-actions[bot] commented 7 months ago

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[bot] commented 7 months ago

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.