
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.
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 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 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.
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.
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