In this section, we will cover in detail each of the steps below:
- Create an Amazon S3 bucket to ingest data
- Create an AWS Glue Catalog Database for storing metadata
- Store Teradata credentials in AWS Secrets Manager
- Create an AWS Glue Service Role to assign to ETL jobs
- Create a connection to a Teradata Instance in AWS Glue
- Create an AWS Glue Job
- Draft a script for automated ingestion and cataloging of Teradata data into Amazon S3