Add to calendar Webinar

From SQL scripts to a production data platform on AWS

In this session, we’ll explore how modern data orchestration solves the challenges created by scattered scripts and growing collections of cron jobs, and why Apache Airflow has become the industry standard for building scalable data workflows.

Share

Agenda

  1. Why data orchestration matters
  2. Introduction to Apache Airflow
  3. Running Airflow on AWS with MWAA
  4. Connecting Airflow and dbt with Cosmos
  5. Real-world architecture: from demo to enterprise

Key topics

  • what data orchestration is and why scattered scripts and cron jobs stop working past a certain scale;
  • how Apache Airflow became the industry standard for orchestration, and what makes it a different category of tool than simple schedulers;
  • how Amazon MWAA removes the operational burden of running Airflow yourself, so teams can focus on pipelines instead of infrastructure;
  • how dbt and Cosmos turn raw SQL transformations into a fully-orchestrated, dependency-aware pipeline with no boilerplate code;
  • how the same architecture scales from a small demo to a production data platform - and why this stack pays off long-term for hiring and warehouse flexibility.

Speaker

Kamil Bartosik

Kamil Bartosik

Cloud Data Engineer

Recognized as an AWS Community Builder. He focuses on building scalable, cloud-native solutions and enjoys working with both the infrastructure and data sides of projects. With experience in both cloud engineering and software development, he often contributes to architecture design and helps clients apply best practices.

Amazon MWAA

Amazon MWAA

Amazon Managed Workflows for Apache Airflow

Apache Airflow is the industry standard for orchestrating data pipelines — and Amazon MWAA lets you run it fully managed on AWS, without the operational overhead of provisioning, scaling, or patching the infrastructure yourself.

For production-grade data platforms, MWAA gives your team a reliable, scalable foundation to focus on pipelines instead of infrastructure.

Data engineering services

AWS is trusted by…