State of Open Con 2025

Over the past eight years, dbt-core has transformed SQL Analysts' workflows, enabling systematic development, modularization, reuse, testing, documentation, and version control.

Simultaneously, Apache Airflow emerged as the leading open-source orchestration tool. It allows data engineers to author, schedule, and monitor workflows using Python, scaling dynamic job scheduling and workflow-as-code.

By November 2024, both tools surpassed 50 million PyPI downloads.

This presentation demonstrates an end-to-end example of developing SQL transformations and productionizing them with these powerful open-source tools.