Monday: dbtvault (open source tool) – Hands On

dbtvault – generate a Data Vault with this open-source tool

Neil Strange, and Business Thinking are bringing their tooling for a hands-on session at this years’ WWDVC 2020.  Come check out their open-source tooling and find out what it can do for you.

Recommended Data Vault Skills:
Beginner, Intermediate, Advanced

Recommended Tool Skills:
Beginner Tool Skills, Intermediate Tool Skills, Advanced Tool Skills


Are you interested in learning about Data Vault but need to work on a shoestring?

Would you like to introduce Data Vault to your organisation, but need to show something physical to explain what the Data Vault method can do and why it should be adopted?

Do you need a prototyping tool that is free, easy to install and use – removing many of the barriers to getting started that can slow you down in today’s organisations?

Hands-on is the best way to learn and code generation is the way to go. But you are faced with a dilemma: build your own code generator, or trial a tool, perhaps when you are least well equipped to assess one tool against another. Well now there is a third option: dbtvault is an open-source code generator. It runs over Python and generates Snowflake SQL from metadata for Data Vault projects.

With dbtvault, you can start experimenting and prototyping Data Vault solutions with minimal effort. During the session you will get the opportunity to rapidly build a Data Vault data platform from scratch using nothing but metadata.

The session is designed for anyone interested in Data Vault ETL generation. dbtvault is used by Data Engineers, Data Ops specialists and BI Analysts to build a Data Vault without needing to write SQL to stage data or load the more common Data Vault table types.


  • Introduction
  • Environments and set-up
  • Background to dbt and dbtvault
  • A primer in dbt
  • What dbtvault does and does not do
  • Business scenario
  • Step-by-step data warehouse build using dbtvault
  • What we have learnt and the future of dbtvault


This will be a hands-on opportunity to learn about dbtvault by building a Data Vault data platform in an example business context.

Just bring your WIFI enabled laptop with web browser and a preferred editor (text or IDE).

Create Snowflake account, trial or otherwise. Sign up for a free 30-day trial
Downloaded and install dbt version 0.15.x

Location: Pinnacle Room Date: May 24, 2021 Time: 4:00 pm - 6:00 pm Alex Higgs