Closed jtcohen6 closed 3 years ago
Yes:
dbt_utils.get_relations_by_prefix
get_tables_by_prefix
dbt_utils.get_relations_by_pattern
get_tables_by_pattern
Both are effectively:
show table extended in {{ schema_pattern }} like '{{ table_pattern }}' / '{{ table_prefix }}*'
It needs to be extended in order to derive relation type (view or table).
extended
No:
dbt_utils.get_relations_by_prefix_sql
dbt_utils.get_relations_by_pattern_sql
This is enough to get us Spark/Databricks compatibility for the codegen package, which uses dbt_utils.get_relations_by_prefix here.
Yes:
dbt_utils.get_relations_by_prefix(no support for schema patterns), plusget_tables_by_prefixas alias/passthroughdbt_utils.get_relations_by_pattern(no support for schema patterns), plusget_tables_by_patternas alias/passthroughBoth are effectively:
It needs to be
extendedin order to derive relation type (view or table).No:
dbt_utils.get_relations_by_prefix_sqldbt_utils.get_relations_by_pattern_sqlThis is enough to get us Spark/Databricks compatibility for the codegen package, which uses
dbt_utils.get_relations_by_prefixhere.