Best Data Build Tool Training - DBT Course in India
                     Step-by-Step Guide to
DBT
+91-7032290546
Introduction
• What is dbt and why it matters
• The role of dbt in modern data 
stacks
• Overview of dbt modeling 
workflow
+91-7032290546
Setting Up Your dbt Environment
• Install dbt (CLI or Cloud)
• Initialize a new dbt 
project
• Connect to your data 
warehouse
+91-7032290546
Understanding the dbt Project Structure
• Key folders: models, macros, tests
• Configuration file: dbt_project.yml
• Naming and organizing your 
models
+91-7032290546
Writing Your First dbt 
Model
• Create a sql file in the 
models/ folder
• Write a SELECT query as 
your model
• Run dbt run to build the 
model
+91-7032290546
Using Ref for Model Dependencies
• Use ref() to link between models
• Benefits: dependency tracking & DAG
• Avoid hardcoding table names
+91-7032290546
Testing Your Models
• Use dbt test to validate 
data quality
• Built-in tests: unique, 
not null, relationships
• Writing custom tests in 
YAML
+91-7032290546
Adding Documentation
• Add descriptions in schema.yml
• Use dbt docs generate and serve
• View model relationships and 
metadata
+91-7032290546
Contact
Data Build Tool Traning
Address:- Flat no: 205, 2nd Floor,
• Nilgiri Block, Aditya Enclave,
• Ameerpet, Hyderabad-1 
• Ph. No: +91-7032290546 
• Visit: www.visualpath.in 
• E-Mail: [email protected]
+91-7032290546
THANK YOU
Visit: www.visualpath.in
+91-7032290546