ScalefreeCOM

configuring-datavault4dbt

Installs and configures the datavault4dbt package in a dbt project — packages.yml, copying the global vars into dbt_project.yml, hash and naming settings, and per-adapter setup. Use when setting up datavault4dbt, installing the package, changing hash/naming global variables, or adapting configuration for a specific warehouse (Snowflake, BigQuery, Redshift, etc.).

rehashing-datavault4dbt-entities

Recalculates hashkeys and hashdiffs across an existing raw vault with datavault4dbt's rehashing macros after a change to the hash algorithm, datatype, trimming, or case sensitivity — including the v1→v2.0.0 upgrade. Use when changing hash global variables, migrating hash logic, or upgrading datavault4dbt without dropping history.

Testing & QA Solid

testing-a-datavault4dbt-project

Adds Data Vault 2 technical tests to a datavault4dbt project — hashkey uniqueness and not-null, link-to-hub referential integrity, and satellite key+load-date uniqueness — as dbt soft-constraint tests in YAML. Use when adding or reviewing tests for hubs, links, or satellites, or validating raw vault integrity.

troubleshooting-datavault4dbt

Diagnoses common datavault4dbt failures — satellites capturing too many or too few rows, multi-source high-water-mark issues, ghost-record/datatype errors, and YAML-metadata compile errors. Use when a datavault4dbt model errors on compile or run, a satellite detects the wrong number of changes, or a hub/link/satellite loads nothing or duplicates.

using-datavault4dbt

Builds Data Vault 2 models in dbt with the datavault4dbt package — staging, hubs, links, satellites, and business-vault entities — using the YAML-metadata macro pattern with correct hashkeys, hashdiffs, naming, and materializations. Use when creating or editing datavault4dbt models, setting up a raw vault, choosing which Data Vault entity to use, or configuring the package's hashing and global variables.

AI & Automation Solid

auditing-skills

Use when checking this repository's skills for security or quality issues before sharing them, or remediating findings across skills.