Interactive Schema

Explore the full Data Vault 2.0 architecture. Click any table to see its dbt model. Click any relationship line to see the join SQL.

Querying a Data Vault is simpler than you think

Every join follows the same pattern: hash key to hash key. A hub holds business keys. A satellite holds descriptive attributes and joins to its hub on the hash key. A link connects two or more hubs using their hash keys. Click any line above to see the actual SQL.

No matter how many tables in the schema, there are only 3 join patterns across the entire model. Once you know them, you can query any Data Vault — even one you've never seen before.

Need a Data Vault for your business?

I design, build, and maintain production Data Vault pipelines on dbt + Airflow.

Get in touch Connect on LinkedIn

Join

model_name

dbt Model

Columns

Connections

Select a table...