# Accessing external schemas in Redshift

**URL:** <https://discourse.getdbt.com/t/accessing-external-schemas-in-redshift/4795>\
**Category:** Help\
**Tags:** external-tables, redshift\
**Created:** [August 22, 2022, 7:55am UTC](https://discourse.getdbt.com/t/accessing-external-schemas-in-redshift/4795 "2022-08-22T07:55:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![plotnikov.sseu](https://avatars.discourse-cdn.com/v4/letter/p/ccd318/32.png) [@plotnikov.sseu](https://discourse.getdbt.com/u/plotnikov.sseu)\
**Post date:** [August 22, 2022, 7:55am UTC](https://discourse.getdbt.com/t/accessing-external-schemas-in-redshift/4795/1 "2022-08-22T07:55:55Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![joellabes](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/joellabes/32/3980_2.png) [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Post date:** [September 23, 2022, 3:55am UTC](https://discourse.getdbt.com/t/accessing-external-schemas-in-redshift/4795/2 "2022-09-23T03:55:38Z")

</div>

@plotnikov.sseu I’m not 100% sure if this will solve your problem, but have you looked at the [external tables package](https://hub.getdbt.com/dbt-labs/dbt_external_tables/latest/)?