Background Image
IMPROVING TALKS

dbtvault: Build a Data Vault 2.0 Model Using dbt and Snowflake

The Data Vault 2.0 method uses a small set of building blocks to model your data warehouse using defined table structures such as Hubs, Links and Satellites. This standard structure allows data to be loaded using templated SQL derived from dbt. dbtvault provides configuration files in yaml, as well as templates written in Jinja to load data into the data vault. This method of development leads to better quality code, fewer mistakes, and improves productivity of your team

Topics Included:

  • Overview of dbt (Data Build Tool) undefinedundefined

  • What is Data Vault 2.0 undefinedundefined

  • Combining dbt and Data Vault 2.0: dbtvault undefinedundefinedundefinedundefined

  • Demo - dbtvault in action

  • Best Practices & Lessons Learned

Tom Schiro headshot
Tom Schiro
Senior Consultant