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)
👍 Officially tested on dbt 1.7.x
vault_insert_by_x
materialisations provided by AutomateDV to behave inconsistently - both materialisations have been temporarily disabled in SQLServer only and will raise an error, and output an error message when used on SQLServer only.@ZacharyMcGuire - Contributing fixes for SQLServer casing issues
apply_source_filter
Reference Tables (ref_table macro)
Satellite loading limitations resolved :tada::tada::tada:
(for standard sat()
macro)
Databricks and Postgres are now fully supported in v0.9.7!
We have added support for:
vault_insert_by_x
materialisations on SQLServer now raise an error.vault_insert_by_x
exceeds 100,000 (#175)dbt docs generate
or dbt docs serve
vault_insert_by_period
materialisation affecting executions with 'hour' as the period (#178)eff_sat
macro (#182)packages.yml
for compatibility with dbt-utils 1.0.0Thank you to all those who were being patient for this release. The delay was due to us wanting to release this with a few other bug fixes and new features. This additional content is being released at a later date so that we could get this dbt-utils fix out to our community sooner.
:star2: Ghost Records -> Docs :star2: Hashing Casing config (#123) -> Docs
👍 dbt support updated to 1.3.x 👍 dbt-utils support updated to 0.9.x (1.0.x will be officially supported shortly)
We have made significant changes to how escaping now works as per #168. We believe this will fix the bugs collected in this master issue.
Whilst we have tested this extensively, we cannot yet be 100% this has fixed every edge case. Please bear with us as we collect community feedback. We welcome your feedback on this!
Related issues:
In addition to the above, we have also done an overhaul of casing in our templates. Users should now not experience any unwanted casing changes. As above, please provide feedback if any issues are found!
Related issues: