What is Data Build Tool (dbt)? | Create your first dbt project | Transform your data with SQL | P1
In this video we are going to cover a new tool called data build tool or dbt. This tool is dubbed as part of the modern data stack. dbt (data build tool) is an open-source python framework and CLI tool. It allows engineers to transform data in the database by simply writing SQL select statements. dbt turns these select statements into tables and views.
dbt does the “T” or the transform in the ETL or rather ELT (Extract Load Transform). It transforms the data we have loaded into our data warehouse. It doesn’t extract or load data. However, it is extremely good at transforming the data. We will use dbt in conjunction with Airbyte to Extract, Load and Transform our data.
Link to Airbyte Installation & Configuration: • How to build data pipelines with Airb...
Link to SQL Series: • What is Data Build Tool (dbt)? | Crea...
#dbt #moderndatastack #etl
💥Subscribe to our channel:
/ haqnawaz
📌 Links
-----------------------------------------
#️⃣ Follow me on social media! #️⃣
🔗 GitHub: https://github.com/hnawaz007
📸 Instagram: / bi_insights_inc
📝 LinkedIn: / haq-nawaz
🔗 / hnawaz100
-----------------------------------------
Topics covered in this video:
0:00 - Introduction DBT
1:41 - DBT Installation
2:43 - Create your first DBT Project
3:37 - Configure Database Connectivity
5:21- Database Overview
5:43 - Review Sample DBT Models
6:52 - Materialize DBT Models to Database
7:41 - DBT Project Structure Overview
10:42 - Coming Soon