# advanced dbt Day 2 Lab

> The advanced dbt Day 2 Lab focuses on implementing the right audit publish pattern in dbt, particularly for critical tables like fact orders. Participants will learn how to create an audit table for testing data integrity before publishing to production, utilizing dbt with Airflow for orchestration…

- Web page: https://www.dataexpert.io/lesson/advanceddbtday2lab-jan2026
- Program: [Winter 2026 Analytics Engineering Camp](https://www.dataexpert.io/program/winter-2026-snowflake-boot-camp)
- Access: Requires enrollment in Winter 2026 Analytics Engineering Camp
- Length: 1 h 2 min video
- Skills: Data Modeling, ETL/ELT, Airflow, dbt
- Academy: DataExpert.io Academy

## About this lesson

The advanced dbt Day 2 Lab focuses on implementing the right audit publish pattern in dbt, particularly for critical tables like fact orders. Participants will learn how to create an audit table for testing data integrity before publishing to production, utilizing dbt with Airflow for orchestration. The session covers essential techniques, including incremental models and environment variable management, ensuring that data quality is maintained throughout the ETL process.

## Navigation

- Previous lesson: [advanced dbt Day 2 Lecture](https://www.dataexpert.io/lesson/advanceddbtday2lecture-jan2026.md)
- Next lesson: [Master Advanced Snowflake Data Modeling with the VARIANT data type](https://www.dataexpert.io/lesson/masteradvancedsnowflakedatamodelingwiththevariantdatatype-jan2026.md)