Building data pipelines with dbt Core and Snowflake

Presentation: Building Data Pipelines with dbt Core and Snowflake

Workshop description

This hands-on workshop will introduce you to the fundamentals of dbt Core for building data pipelines. You will learn how to load data, create data models, add data quality tests and documentation using dbt Core and Snowflake. By the end of this workshop, you'll understand how to transform raw data into analytics-ready models using industry best practices.

Workshop Structure

The workshop will cover:

• Introduction to dbt Core and its architecture
• Setting up a dbt project with Snowflake
• Creating data models using SQL
• Implementing testing and documentation
• Best practices for data pipeline development

Data Sources

The data sources for this workshop are stored in the workshop/datasources folder. During setup, you'll load these files into your Snowflake instance following the instructions in the workshop setup guide.

Requirements

• A Snowflake trial account
• Python 3.7 or higher
• Basic knowledge of SQL

Usage

Run the following code to clone the workshop repo:

git clone https://github.com/pyladiesams/data-pipelines-with-dbtcore-snowflake-sep2025
cd data-pipelines-with-dbtcore-snowflake-sep2025

Pre-workshop Setup

Before attending the workshop, please follow the setup instructions in the workshop_setup.md file, including:

1. Creating a Snowflake trial account
2. Setting up a database and loading sample data
3. Installing dbt Core locally
4. Configuring your dbt environment

Video record

Re-watch this YouTube stream

Credits

This workshop was set up by @pyladiesams and @anyalitica

Happy Coding :)