Module 1: Introduction to DBT and Data Transformation
What is DBT (Data Build Tool)?
The Role of DBT in Modern Data Stacks
Overview of Snowflake as a Cloud Data Warehouse
Installing DBT and Setting Up the Environment
Module 2: Getting Started with Snowflake and DBT
Setting Up a Snowflake Database and Schema
DBT Project Structure and Key Components
Configuration Files (profiles.yml and dbt_project.yml)
Module 3: Writing DBT Models
Types of DBT Models (staging, intermediate, and marts)
Writing and Materializing Models (View, Table, Incremental)
Understanding SELECT Statements in DBT Models
Module 4: Jinja and Macros in DBT
Introduction to Jinja Templating in DBT
Using Macros for Reusable Code
Creating and Invoking Custom Macros
Module 5: DBT Testing and Data Quality
Importance of Data Testing in DBT
Types of Tests: Schema, Data, and Custom Tests
Writing and Running Tests (unique, not_null, accepted_values)
Module 6: DBT Documentation and Best Practices
Documenting Models and Creating docs
Generating and Viewing Documentation with dbt docs serve
DBT Best Practices: Modularity, Readability, and Maintainability
Module 7: Advanced DBT Features
Using Hooks and Operations in DBT
Snapshots for Tracking Historical Data
Configuring Incremental Models for Performance
Module 8: Version Control with Git
Integrating DBT Projects with Git
Git Workflow: Branching, Committing, and Merging
Collaboration in DBT Projects
Module 9: CI/CD with DBT and Snowflake
Setting Up CI/CD Pipelines Using GitHub Actions or GitLab CI
Automating Model Runs and Tests in CI/CD
Deploying Models Across Development, Staging, and Production Environments
Module 10: Snowflake Fundamentals
Snowflake Introduction
Data Loading and Transformation
Data Querying and Analysis
Data Integration and Management
Snowflake Best Practices
Hands-on Exercises