In this dbt Crash Course, I will walk you through how to use dbt Core to run your data transformation workflow . This is going to be a crash course meant to be covering the basics for you to get started. For more advanced topics, I will be covering them in separate videos.
dbt stands for Data Build Tool, is an open-source data transformation and data warehousing tool created by dbt lab, designed to handle the complexity of modern data pipelines. It provides a framework for defining, testing, and deploying SQL transformations and helps automate the process of building, maintaining and updating a data warehouse. dbt enables data analysts, data engineers, and data scientists to build, version, and maintain a library of reusable data transformations.
📑 More on dbt (data build tool): www.getdbt.com/
📄 Profiles reference: docs.getdbt.com/reference/pro...
📑 Supported databases: docs.getdbt.com/docs/supporte...
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🛒 By shopping on Amazon → amzn.to/2JkGeMD
👩💻 Follow me on Linked: / jiejenn
🌳 Becoming a Patreon supporter: / jiejenn
✉️ Business Inquiring: KZitem@LearnDataAnalysis.org
00:00 - Intro
01:04 - Prerequisites
01:54 - Agenda
02:25 - Create dbt project Python virtual environment
03:44 - Install dbt Core CLI & database adapter
05:26 - Init dbt project
05:42 - Set up database connection (Google BigQuery)
11:08 - dbt dry run
14:13 - Push file to a GitHub repo
16:36 - Build dbt models
20:06 - Configure dbt model materialization
26:16 - Build dbt models on top of other models
30:43 - Testing
33:49 - Generate documentation
#dbt #databuildtool #dbtlab #dataengineering #dataanalytics
Негізгі бет dbt (data build tool) Crash Course For Beginners (dbt Core) | Full Tutorial
Пікірлер: 35