You need to migrate a large dataset from an on-premises data warehouse to AWS Glue Data Catalog. The dataset contains millions of records and spans multiple tables. What is the most efficient way to transfer the dataset while maintaining its schema and relationships?

Simulated

Manually export the dataset from the on-premises data warehouse and import it into the AWS Glue Data Catalog.

0.0%

Use AWS Data Pipeline to orchestrate the data transfer and schema migration from the on-premises data warehouse to the AWS Glue Data Catalog.

7.1%

Leverage AWS Database Migration Service (DMS) to replicate the dataset and its schema to a target database in AWS, then use AWS Glue to catalog the data.

71.4%

Create an AWS Glue job that extracts the dataset from the on-premises data warehouse and writes it to the AWS Glue Data Catalog.

21.4%

AWS Certified Data Engineer - Associate

Get started today

Comments

You need to migrate a large dataset from an on-premises data warehouse to AWS Glue Data Catalog. The dataset contains millions of records and spans multiple tables. What is the most efficient way to transfer the dataset while maintaining its schema and relationships?