This course is designed for Analytics Engineers, Data Analysts, BI Professionals, Data Scientists, Data Engineers, DevOps Engineers, and Architects

Basic understanding of Snowflake and SQL

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 Custom Macros

• Implementing Table, View and Ephemeral Model
• Create custom macro
• Understanding DBT package
• Labs: Building incremental load

7. Working with DBT Snapshots

• Snapshots overview
• Creating a snapshot
• Labs: create snapshot

8. DBT Hooks

• What are DBT Hooks?
• Understanding pre-hook, post-hook, on-run-start, on-run-end hooks
• Implementing DBT Hook
• Labs: 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