ScalefreeCOM
- 6 skills
- 0 followers
- 8 hours ago last updated
- ▌ Auditing Skills · scalefreecomUse when checking this repository's skills for security or quality issues before sharing them, or remediating findings across skills.
- ▌ Using Datavault4dbt · scalefreecom bundleBuilds 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.
- ▌ Configuring Datavault4dbt · scalefreecom bundleInstalls 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.).
- ▌ Troubleshooting Datavault4dbt · scalefreecomDiagnoses 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.
- ▌ Testing A Datavault4dbt Project · scalefreecomAdds 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.
- ▌ Rehashing Datavault4dbt Entities · scalefreecomRecalculates 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.