In the following video demonstration, we will learn how to programmatically load data into and upload data from Amazon Redshift using Amazon Managed Workflows for Apache Airflow (Amazon MWAA). Using Airflow, we will COPY raw data into staging tables and then merge that staging data into a series of tables. We will then load incremental data into Redshift on a regular schedule. Next, we will aggregate data from several tables and UNLOAD that data to an Amazon S3-based data lake. Lastly, we will catalog the data in S3 using AWS Glue and query with Amazon Athena.
All open-source files on GitHub: github.com/garystafford/ticki....
This video represents my own viewpoints and not of my employer, Amazon Web Services (AWS). All product names, logos, and brands are the property of their respective owners.
📣 Please subscribe to my RU-vid channel for future videos.
30 ноя 2021