elementary
elementary copied to clipboard
Elementary model information_schema_columns fails with error: Unity Catalog is not enabled
Describe the bug
When I run dbt run -s elementary
, it fails for the model information_schema_columns
with the exception [UC_NOT_ENABLED]
. My databricks cluster doesn't have unity catalog, neither am I specifying the catalog option in the profiles.yaml
file.
I tried:
- Switching databricks access mode to
No Isolation shared
but it still failed. - Passing the field
catalog: null
in theprofiles.yaml
file but it still fails.
When I print the value of the target.catalog
variable in the elementary/macros/edr/metadata_collection/get_columns_from_information_schema.sql
macro, it shows hive_metastore
, even though I am not setting the catalog anywhere in my project.
To Reproduce Steps to reproduce the behavior:
- Setup a DBT project with databricks adapter that doesn't have unity catalog.
- Add elementary as a package and install it with
dbt deps
. - Run
dbt run -s elementary
and see the error.
Expected behavior Elementary should detect that I am not using unity catalog, and skip this model.
Screenshots If applicable, add screenshots to help explain your problem.
Environment (please complete the following information):
- edr Version: 0.15.0
- dbt package Version: 1.7.8
- dbt-databricks: 1.7.13