Airflow is on the Cloud | ELT Pipeline Orchestration With Airflow & AWS

Author(s): Kaan Boke Ph.D.

Originally published on Towards AI.

Photo by James Wheeler: https://www.pexels.com/photo/symmetrical-photography-of-clouds-covered-blue-sky-1486974/

You will see the ELT pipeline with Airflow orchestration.

You will learn to load data to the PostgreSQL database directly from AWS S3. You’ll do everything with the Docker containers.

You will learn how to communicate between the different tasks with Airflow XCom.

You will download files from AWS S3.

You will upload files to AWS S3.

You’ll use Bash Operator, Python Operator, Task Decorator, and other Airflow functions.

You’ll get the data, load it to PostgreSQL Database and see it with pgAdmin in minutes.

Let’s start.

Introduction

Upload files to S3

Download files from S3

Communicate between the different tasks with Airflow XCOM

Connect PostgreSQL to AWS… Read the full blog for free on Medium.

Join thousands of data leaders on the AI newsletter. Join over 80,000 subscribers and keep up to date with the latest developments in AI. From research to projects and ideas. If you are building an AI startup, an AI-related product, or a service, we invite you to consider becoming a sponsor.

Published via Towards AI