Handle external tables in get_tables_by_pattern_sql (#351)

upjohnc · clrcrl · commit 69329573eb8b · 2021-05-18T16:28:55.000-04:00
diff --git a/CHANGELOG.md b/CHANGELOG.md
@@ -9,8 +9,10 @@
 
 ## Fixes
 * Handle booleans gracefully in the unpivot macro ([#305](https://github.com/fishtown-analytics/dbt-utils/pull/305) [@avishalom](https://github.com/avishalom))
+* Fix a bug in `get_relation_by_prefix` that happens with Snowflake external tables. Now the macro will retrieve tables that match the prefix which are external tables ([#350](https://github.com/fishtown-analytics/dbt-utils/issues/350))
 ## Under the hood
 
+
 # dbt-utils v0.6.4
 
 ### Fixes
diff --git a/macros/sql/get_tables_by_pattern_sql.sql b/macros/sql/get_tables_by_pattern_sql.sql
@@ -10,6 +10,8 @@
             table_name as "table_name",
             case table_type
                 when 'BASE TABLE' then 'table'
+                when 'EXTERNAL TABLE' then 'external'
+                when 'MATERIALIZED VIEW' then 'materializedview'
                 else lower(table_type)
             end as "table_type"
         from {{ database }}.information_schema.tables
