Posted On: Mar 19, 2023
Amazon Database Migration Service (Amazon DMS) has expanded support of Amazon Simple Storage Service (Amazon S3) as a target by adding the ability to create an Amazon Glue Data Catalog from the Amazon S3 data files generated by Amazon DMS. With this integration, you no longer need to run a crawler or additional ETL jobs to create the catalog, and the Amazon S3 data is ready to be queried through other Amazon Web Services services such as Amazon Athena. This feature is now available in Amazon Web Services China (Beijing) Region, operated by Sinnet and Amazon Web Services China (Ningxia) Region, operated by NWCD.
The Amazon Glue Data Catalog generated from the data that DMS migrates to Amazon S3 can be used for many reasons, from querying the data with Amazon Athena to using Amazon Glue Studio to perform data preparation and transformation for analysis. This integration reduces the manual effort required for accurate catalog generation.
To learn more, see Using Amazon S3 as a target for Amazon Database Migration Service.