search

Datavault-UK / automate-dv

A free to use dbt package for creating and loading Data Vault 2.0 compliant Data Warehouses (powered by dbt, an open source data engineering tool, registered trademark of dbt Labs)
https://www.automate-dv.com
Apache License 2.0
511 stars 131 forks source link

'dbtvault' undefined error #102

Closed konkodi210 closed 2 years ago

konkodi210 commented 2 years ago

Describe the bug We are using DBT vault with Big query adapter. When we execute hub mapping as shown below, system gives error saying "dbtvault" undifined. This was working correctly in dbt 0.21.0 but when I upgraded to dbt 1.0.0, it stopped working

{{ dbtvault.hub(var_yaml.src_pk, var_yaml.src_nk, var_yaml.src_ldts, var_yaml.src_source, var_yaml.source_model )}}

Versions

dbt: 1.0.1 dbt-bigquery: 1.0.1

Log files Compilation Error in model HUB_STUDY (models\load\hubs\HUB_STUDY.sql)
'dbtvault' is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with "dbt deps".

DVAlexHiggs commented 2 years ago

dbtvault does not currently support BigQuery, only Snowflake. This is why you are receiving this error.

We are releasing Hub, Link and Satellite support for BigQuery next week, however.

konkodi210 commented 2 years ago

That is good news. I will wait for newer release.

One observation, it was working in dbt 0.21.0

DVAlexHiggs commented 2 years ago

That is good news. I will wait for newer release.

One observation, it was working in dbt 0.21.0

I think it may be due to how dbt handles multi dispatch now, compared to 0.21.0.

We've never had an implementation for BigQuery in dbtvault until this next release, so it may not have given you an error but it wouldn't have worked correctly unless you implemented BigQuery yourself.