# TA Office Hour 4

> Office hours provide an interactive space for students to discuss their weekly assignment focused on building a data pipeline using Airflow. Participants will learn to create a daily partitioning table, load data from the Polygon API into a staging table, and perform data quality checks before tran…

- Web page: https://www.dataexpert.io/lesson/ta-office-hour-4-jan2025
- Program: [2025 New Year  Data Engineering Boot Camp starting January 6th](https://www.dataexpert.io/program/2025-new-year-data-engineering-boot-camp-starting-january-6th)
- Access: Requires enrollment in 2025 New Year  Data Engineering Boot Camp starting January 6th
- Length: 53 min video
- Skills: Data Modeling, ETL/ELT, Airflow, Apache Iceberg, Trino
- Academy: DataExpert.io Academy

## About this lesson

Office hours provide an interactive space for students to discuss their weekly assignment focused on building a data pipeline using Airflow. Participants will learn to create a daily partitioning table, load data from the Polygon API into a staging table, and perform data quality checks before transitioning to production. This session also covers various approaches using tools like Trino and PyIceberg, ensuring students can adapt their solutions based on their preferences and requirements.

## Navigation

- Previous lesson: [TA Office Hour 3](https://www.dataexpert.io/lesson/ta-office-hour-3-jan2025.md)
- Next lesson: [TA Office Hour 5](https://www.dataexpert.io/lesson/ta-office-hour-5-jan2025.md)
