elementary
elementary copied to clipboard
Getting Error in elementary models installation in dbt-spark
Describe the bug I am getting error in model dbt_metrics while running command dbt --cache-selected-only run --select elementary
Runtime Error in model dbt_metrics (models/edr/dbt_artifacts/dbt_metrics.sql)
Database Error
org.apache.hive.service.cli.HiveSQLException: Error running query: [INTERNAL_ERROR] org.apache.spark.SparkException: [INTERNAL_ERROR] Unexpected table relation: HiveTableRelation [`spark_catalog`.`elementary`.`dbt_metrics`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [unique_id#1017783, name#1017784, label#1017785, model#1017786, type#1017787, sql#1017788, timest..., Partition Cols: []]
similar error in models -
- dbt_columns.sql
- dbt_tests.sql
- dbt_sources.sql
- dbt_snapshots.sql
- dbt_exposures.sql
- dbt_seeds.sql
- dbt_models.sql
To Reproduce
Steps to reproduce the behavior:
dbt --cache-selected-only run --select elementary
Screenshots If applicable, add screenshots to help explain your problem.
Environment (please complete the following information):
- edr Version: [0.14.1]
- dbt-spark [1.7.0]
- dbt-core [1.7.0]
- elementary-data==0.14.1
- elementary-data[athena]==0.14.1
Additional context dbt_project.yml
models:
## see docs: https://docs.elementary-data.com/
elementary:
## elementary models will be created in the schema '<your_schema>_elementary'
+schema: "elementary"
vars:
elementary_full_refresh: false