[Feature] Add support for federated query external schemas about dbt-redshift

[dataders]

@ronco the creation of these objects is something that's already possible for other dbt adapters via dbt-external-tables. We're actively working to bring the notion of External Tables into dbt, could you be so kind to add a comment to dbt-labs/dbt-adapters#92 requesting that federated queries be supported?

however, it sounds as if the package supported their creation. there's another problem.

even if you create them outside of dbt, you cannot refer to them within dbt, because dbt cannot discover that they exist, right?

I believe the solution to that will be to address #776.

[dataders]

@ronco the creation of these objects is something that's already possible for other dbt adapters via dbt-external-tables. We're actively working to bring the notion of External Tables into dbt, could you be so kind to add a comment to dbt-labs/dbt-adapters#92 requesting that federated queries be supported?

however, it sounds as if the package supported their creation. there's another problem.

even if you create them outside of dbt, you cannot refer to them within dbt, because dbt cannot discover that they exist, right?

I believe the solution to that problem will be to address #776.

[ronco]

Hey @dataders , thanks for following up! I've left a comment on that discussion regarding federated-queries. I also agree #776 would likely address this. Since #776 already addresses the concern I'll go ahead and close this feature request.
Thanks!