
Learn to run workflows with Airflow v2, set up with Docker containers, and master operators, hooks, connections, and tags to build practical workflows.
Follow the os-specific cheat sheet to install prerequisites, including docker engine and docker compose on Linux, and Mac/Windows desktop versions, with optional Atem editor and terminal.
Set up your Airflow v2 environment by creating a project folder, unzipping resources, and fixing permissions on macOS or Linux; then run docker compose up to launch Postgres and Airflow.
Interact with the PostgreSQL and Airflow containers from the provided interface or by entering the containers with docker exec, inspect the DAG folder, and run database commands from within.
Explore fundamental Airflow v2 concepts, including DAGs and tasks, execution date and backfill, operators, XCom, hooks, sensors, branching, and templating to design scalable workflows.
Explore creating and executing a DAG in Airflow v2 by setting default_args and start date, defining schedule intervals, and wiring BashOperator tasks with dependencies, backfills, and graph views.
Learn how to run backfills with Airflow v2, specify start dates, review logs, and override schedule intervals using presets to run, none, or external triggers.
Learn to build an Airflow v2 workflow using the Python operator to process stock financial data, format results, and write to a text file for database ingestion.
Learn to use the branch python operator in Airflow v2 to route tasks by file content. Branch to process data or print no data, as shown in the DAG.
Learn how the Postgres operator in Airflow runs SQL via a hook using a connection, and how to create a PostgreSQL connection with host, schema, and privileges.
Learn to configure a Postgres operator in Airflow v2 to create a financials table and insert data using a connection, with fields ticker, record date, time frame, metric, and value.
Complete the Airflow v2 workflow by writing XCom-pushed values into a PostgreSQL server, using final operators and on conflict handling to allow repeated runs.
Review the critical concepts page and inspect the Airflow code in the GitHub repository to understand DAGs, operators, hooks, and connections, including backing up files to S3.
Airflow is an Apache project, used to programmatically author, schedule and monitor workflows. It was originally developed by Airbnb and then later open-sourced. Today, many technology companies use Airflow to orchestrate their workflows.
This course is designed to get you up and running with Airflow v2 in an hour. The specific focus of the course is on teaching you the fundamentals of using Airflow rather than setting up a production environment. We will set up a sandbox environment with Airflow and PostgreSQL Servers running for you to code along and practice what you have learned. The skills you learn in this course will be transferable to your work, where a production environment is already available and maintained. Alternatively, if you are interested in using Airflow for hobby projects, the sandbox environment that you set up on your machine will likely be sufficient.
When you are taking this course, you will:
Learn the core Airflow concepts
Write an end to end workflow that takes data, cleans it up and writes into a database
Learn a number of different operators and get the hand of using operators so that you can easily incorporate new ones into your workflow
Understand how you can unblock yourself if you run into issues running your code