Summary
Keywords
Full Transcript
All my FREE resources: https://www.skool.com/moderndata/about Consulting Services: https://go.kahandatasolutions.com ----- dbt provides a mechanism, variables, to provide data to models for compilation. This is functions in a similar fashion as other common programming languages and tools that offer the ability to store data in a variable form. In this video I will walk through the two ways that dbt allows you to define variables - In the dbt_project.yml file and on the command line. What is dbt? dbt (data build tool) enables analytics engineers to transform data in their warehouses by simply writing select statements. dbt handles turning these select statements into tables and views. dbt does the T in ELT (Extract, Load, Transform) processes – it doesn’t extract or load data, but it’s extremely good at transforming data that’s already loaded into your warehouse. Timestamps: 0:00 - Intro 0:29 - Ways to Use Variables in dbt 1:04 - Set Vars in Project 3:50 - Set Vars on Command Line Title & Tags: How to Use Variables In Your DBT Project | Data Build Tool (dbt) Tutorial #databuildtool #dataengineering #kahandatasolutions
