DE Zoomcamp 4.2.3 - Local Setup (Alternative B) скачать в хорошем качестве

DE Zoomcamp 4.2.3 - Local Setup (Alternative B)

In this tutorial, you'll learn how to set up a complete local development environment for Module 4 of the Data Engineering Zoomcamp using DuckDB and dbt Core. By the end of this video, you'll have a fully functional local analytics engineering workflow without needing any cloud services or paid accounts. 🔗 Course materials: https://github.com/DataTalksClub/data... 💬 Join the community: https://datatalks.club/slack What You'll Learn: Installing DuckDB and dbt Core with the DuckDB adapter Initializing a dbt project and understanding its structure Configuring profiles.yaml for optimal performance with large datasets Creating a local data lake and ingesting NYC taxi data into DuckDB Setting up Git ignore best practices to avoid committing data Installing and configuring the Power User for dbt VS Code extension Timestamps: 0:00 - Introduction and local setup overview 0:54 - Installing DuckDB 2:08 - Installing dbt Core with DuckDB adapter 3:15 - Initializing your dbt project structure 4:55 - Understanding and configuring profiles.yaml 7:16 - Running the data ingestion script 8:12 - Understanding the ingestion process and Git ignore setup 10:56 - Verifying data in DuckDB 13:06 - Running dbt debug to verify setup 13:42 - Installing Power User for dbt extension 15:11 - Wrap-up and next steps