elementary-data / elementary

The dbt-native data observability solution for data & analytics engineers. Monitor your data pipelines in minutes. Available as self-hosted or cloud service with premium features.
https://www.elementary-data.com/
Apache License 2.0
1.89k stars 159 forks source link

error "Pass a string for project" or "Column created_at is not present in table my_project.dbt_elementary.data_monitoring_metrics" if upgrade dbt package version from 0.7.3 to 0.14.0 #1424

Closed gfh62001 closed 6 months ago

gfh62001 commented 6 months ago

Describe the bug Currently I upgrade dbt elementary package version from 0.7.3 to 0.14.0 I got an error when run dbt test for elementary anomalies test: ''' dbt test '''

''' 08:19:43 Unhandled error while executing Pass a string for project 08:19:43 4 of 26 ERROR elementary_source_table_anomalies_ileyshop_digdag_lobby_src_transaction_master_row_count [ERROR in 0.41s] '''

If my command ''' dbt test --target prod ''' the error will disappear and error will become ''' 08:41:26 on-run-end failed, error: Column created_at is not present in table my_project.dbt_elementary.data_monitoring_metrics at [18:9]'''

my dbt_project.yml setting for elementary: ''' models: elementary: +database: my_project +schema: dbt_elementary +enabled: "{{ (target.name == 'prod') | as_bool }}" '''

To Reproduce Steps to reproduce the behavior:

1.upgrade dbt package from 0.7.3 to 0.14.0

  1. run elementary anomalies dbt test or dbt test --target prod

Expected behavior All tests pass and got No error

Screenshots If applicable, add screenshots to help explain your problem.

Environment (please complete the following information):

Additional context There are 2 infos: 1.If I downgrade to v0.13.1, it will not happen. 2.I don't change any config in dbt_project.yml.

Should I do any thing for upgrading to v0.14.0?

gfh62001 commented 6 months ago

move issue to dbt-data-reliability