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
492 stars 121 forks source link

Solution for #121 #136

Closed DVTimWilson closed 2 years ago

DVTimWilson commented 2 years ago

Refactor the get_period_boundaries() macro to reference the target table relation rather than just a schema and table name. This will ensure that it will work for tables in any specified database and schema.

Highlighted by issue #121

DVTimWilson commented 2 years ago

Hub tests HUB-PM-05 and HUB-PM-06 on BigQuery failing on new custom database feature, database DBTVAULT_TEST not found: Database Error 2022-07-14T14:06:12.8129956Z Invalid project ID 'DBTVAULT_TEST'. Project IDs must contain 6-63 lowercase letters, digits, or dashes. Some project IDs also include domain name separated by a colon. IDs must start with a letter and may not end with a dash.

Satellite test SAT-PM-D-01 on BigQuery failed with a timeout error.

DVAlexHiggs commented 2 years ago

Hub tests HUB-PM-05 and HUB-PM-06 on BigQuery failing on new custom database feature, database DBTVAULT_TEST not found: Database Error 2022-07-14T14:06:12.8129956Z Invalid project ID 'DBTVAULT_TEST'. Project IDs must contain 6-63 lowercase letters, digits, or dashes. Some project IDs also include domain name separated by a colon. IDs must start with a letter and may not end with a dash.

Satellite test SAT-PM-D-01 on BigQuery failed with a timeout error.

Will take a look at this when I can. Thanks