dbtvault: Build a Data Vault 2.0 model using dbt and Snowflake
Venue Details
—————————-
Improving (formerly Object Partners) is located at 1515 Central Ave NE. If there is parking available in the front, feel free to use it. Otherwise, there is a lot behind the building. You can walk to the front from that lot or message Donald to let you in the back entrance (612.964.4104).
An online link will be provided for remote participants as well.
—————————-
Agenda
—————————-
6:15-7:00 Pizza and Networking
7:00 Kickoff and Announcements/Who’s Hiring/Who’s Looking
7:05 Build Data Vault 2.0 model with dbtvault
(Tom Schiro, Sr Consultant @ Improving MN)
8:00 Networking
—————————-
Presentation Overview
—————————-
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 teamTopics Included:
Overview of dbt (Data Build Tool)
Advantages
Basic functionality
Introduction to Data Vault 2.0
What is Data Vault 2.0
Hubs, Sats, Links & Other table types
Dbtvault
What is dbtvault
– Project structure
Stages, hubs, satellites, links
Yaml configuration files
Hashing
Demo – dbtvault in action
Best Practices & Lessons Learned
—————————-
Speaker Bio
—————————-
Tom Schiro, Sr Consultant for Improving, is a product-minded developer who enjoys building modern data pipelines that are scalable, repeatable, secure and adhere to data quality standards. His skills include data modeling, ETL/ELT development, and has a range of various coding skills. He is currently specializing in dbt (Data Build Tool), Snowflake, Data Vault 2.0 and building self-reliant and capable teams.