data-mie / dbt-profiler

Macros for generating dbt model data profiles
Apache License 2.0
81 stars 33 forks source link

Redshift compatibility #29

Closed stumelius closed 3 years ago

stumelius commented 3 years ago

Redshift information schema cannot be joined with user defined tables due to information schema being accessible only from the Redshift leader node and not from compute nodes. This PR implements a workaround for Redshift that utilizes catalogue tables pg_attribute, pg_type, pg_class and pg_namespace.

Additional info: