Kickstart DBT for Snowflake in a Day
- Created By ebrahim khaja
- Posted on September 7th, 2023
- Overview
- Prerequisites
- Audience
- Audience
- Curriculum
Description:
In this one-day course, students will dive into core concepts of data build tool (DBT) and learn how to streamline data engineering pipelines for Snowflake. From understanding models and materialization to exploring source freshness and using advanced techniques like macros and hooks, students will gain a solid foundation of using data build tools (DBT) effectively. Students will get practical hands-on experience using the data build tool with Snowflake.
Duration: 1 Day
Course Code: BDT302
Learning Objectives:
After this course, you will be able to:
- Introduction Data Build Tool (DBT)
- Understanding DBT models
- Using DBT tests to ensure quality of DBT models
- Explore DBT materializations to optimize performance & scalability of DBT models
- Integrating seeds and sources in DBT project during data ingestion
- Dive into DBT Hooks to integrate external scripts and actions into your DBT workflows
- Basic understanding of Snowflake and SQL
- This course is designed for Analytics Engineers, Data Analysts, BI Professionals, Data Scientists, Data Engineers, DevOps Engineers, and Architects
- This course is designed for Analytics Engineers, Data Analysts, BI Professionals, Data Scientists, Data Engineers, DevOps Engineers, and Architects
1. Introduction to Data Build Tool (DBT)
- Introduction to Data Warehouse (Snowflake)
- ETL v/s ELT
- DBT introduction
- DBT installation
- DBT cloud introduction
- Lab: Getting started with DBT
2. Understanding DBT Models
- What are DBT models?
- Creating DBT table
- Using DBT schema
- DBT project organization
- Lab: Project organization
3. Using DBT Tests
- What is DBT schema?
- What is a DBT Macro?
- Understanding DBT test types
- Lab: Generic and Singular Tests
4. Exploring DBT Materialization
- What are materializations in DBT?
- Default materialization in DBT
- Using Config Block for materialization
- Lab: Setting materialization
5. Integrating DBT Seeds and Sources
- Seeds and Sources overview
- Adding sources in DBT
- What is source freshness?
- Labs: Adding source freshness check in DBT
6. DBT Hooks
- What are DBT Hooks?
- Understanding pre-hook, post-hook, on-run-start, on-run-end hooks
- Implementing DBT Hook
Training material provided: Yes (Digital format)
Hands-on Lab: Instructions will be provided to set up a free tier snowflake account. Also, students will be provided on how to install DBT tool on Windows/Mac
