All of my raw sources are located in external schemas that I fetch into Redshift. Redshift schema called information_schema does not store metadata on those sources. My dbt macros that get use of table metadata (like get_relations_by_pattern) trying to read from information_schema but finding nothing in there so my models are not being built properly. How do you handle this? I will be grateful for any advice.
@plotnikov.sseu I’m not 100% sure if this will solve your problem, but have you looked at the external tables package?
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Create schema with empty tables and redshift spectrum | 0 | 1814 | April 10, 2023 | |
| Is it possible to import a redshift table structure into a source definition (schema.yml) | 5 | 1195 | July 3, 2023 | |
| Redshift error: External tables are not supported in views | 0 | 538 | December 10, 2024 | |
| How to extract table comments in the db and populate schema description with it? | 2 | 1397 | February 8, 2024 | |
| Using data from another model or from data in S3 | 1 | 1070 | September 14, 2023 |