# Advanced dbt Lecture Day 2

> Advanced pipelines in dbt are crucial for optimizing data workflows in production environments. This lesson covers techniques for running dbt with Airflow, including the use of selection methods to manage model execution frequency and the implementation of write-audit-publish patterns to ensure dat…

- Web page: https://www.dataexpert.io/lesson/advanced-dbt-lecture-day-2-april2025
- Program: [Analytics Engineering Boot Camp starting April 14th, 2025](https://www.dataexpert.io/program/analytics-engineering-boot-camp-april-2025-5702)
- Access: Requires enrollment in Analytics Engineering Boot Camp starting April 14th, 2025
- Length: 58 min video
- Skills: Data Modeling, ETL/ELT, Airflow, dbt
- Academy: DataExpert.io Academy

## About this lesson

Advanced pipelines in dbt are crucial for optimizing data workflows in production environments. This lesson covers techniques for running dbt with Airflow, including the use of selection methods to manage model execution frequency and the implementation of write-audit-publish patterns to ensure data quality. Participants will learn how to improve efficiency and reliability in their dbt projects, making it beneficial for data engineers and analysts looking to enhance their data transformation processes.

## Navigation

- Previous lesson: [Advanced dbt Lab Day 1](https://www.dataexpert.io/lesson/advanced-dbt-lab-day-1-april2025.md)
- Next lesson: [Advanced dbt Lab Day 2](https://www.dataexpert.io/lesson/advanced-dbt-lab-day-2-april2025.md)