With the data of the fictitious company Willibald and its 13 challenges, a DWH is created with the open source software dbt. An ideal opportunity to see and evaluate the tool in realistic use. The data of the company Willibald will be explained by DDVUG in a previous lecture.

Prerequisites: Basic Data Warehouse Knowledge
Level: Basic

Extended Abstract:
For the fictitious company Willibald, a complete data model with data is available that was created by DDVUG and provided with 13 typical challenges. In this presentation, a possible solution using dbt, datavault4dbt and our own extensions will be shown and combined into a complete data warehouse. This will give you an overall impression and the possibility to get your own comprehensive impression of the tool. 
 Dbt (data build tool) is a development framework that enables teams to build, test and deploy analytics solutions faster. It can be used to create a unified development environment for all data engineering and data analyst teams. Scalefree's open-source Datavault4dbt package extends dbt with dbt macros to build a Data Vault 2.0 compliant data warehouse.  
In some places, we have supplemented this setup with self-developed macros. We have chosen Snowflake as the target platform, but other databases would also be possible for this setup, in part with a certain amount of adaptation. 
In our view, the use of a data governance tool is highly recommended for the development of a data warehouse that can be maintained in the long term.  
For this reason, we have extended our approach with an adapter to a graphical data governance tool to enable an almost completely automatic construction of the raw vault based on the centrally maintained metadata.