dv-pit-bridge
CommunityPITs & Bridges for fast Data Vault queries
AuthorPatrickCuba
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill provides authoritative guidance on designing and implementing PIT and Bridge tables in a Data Vault environment (DVOS). It clarifies when to use legacy PIT vs SNOPIT, how to declare and materialize PITs and Bridges in manifests, and how to apply naming rules and guards to maintain correct historical data queries.
Core Features & Use Cases
- PIT types and decision guidance: legacy PIT vs SNOPIT, including dv_sid enable_dv_sid requirement.
- Bridge types: relationship, current_relationship, and fact bridges, with example manifest declarations and patterns.
- Materialisation options and governance: dynamic_table vs ctas, ghost records, as_of calendar, multi-table inserts, and safety rules around clustering and dv_sid usage.
Quick Start
Define your PITs and Bridges in a DVOS manifest using pits and bridges blocks, then deploy with your chosen materialisation settings.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: dv-pit-bridge Download link: https://github.com/PatrickCuba/the_data_must_flow/archive/main.zip#dv-pit-bridge Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 510,000+ vetted skills library on demand.