Accessing external schemas in Redshift

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.

1 Like

@plotnikov.sseu Iā€™m not 100% sure if this will solve your problem, but have you looked at the external tables package?