DBT (Data Build Tool) - What is DBT Model | First DBT Project | Data Build Tool Tutorial
4.0(4)
29 learners
What you'll learn
Set up and configure DBT Cloud to connect to Snowflake and execute your first project
Create and manage DBT models, seeds, materialized views, and macros for data transformation
Troubleshoot and execute DBT models using advanced commands like retry, tags, and dependency management
Prepare for DBT interviews by mastering key concepts such as permanent tables, secure views, and use of codegen packages
This course includes
61.5 hours of video
Certificate of completion
Access on mobile and TV
Summary
Full Transcript
DBT Model:
SQL files that contains Transformation Logic
Data Build Tool
Used for Data Transformation
Not a ETL Tool
ELT = T
Raw Data = DBT =Transformed Data
Advantages of DBT:
Easy Testing
Reusable Code (Macros & JINJA )
CI CD Integration
Data Lineage
Documentation
Prerequisites:
Snowflake Account
DBT cloud Account
Snowflake Database
Snowflake Schema
#dbtcloud#databuildtool
#dbtwithsnowflake#snowflakeanddbt
#snowflakewithdbt#snowflakedbtcloud
#setupsnowflakewithdbt
#dbtmodels#dbtseeds
#dbtmacros#dbtanalysis
#dbtincrementals #dbtscds#dbtmaterilizations
#dbtcloud #dbtcore
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.