Amazon DynamoDB bulk import and export capabilities provide a simple and efficient way to move data between Amazon S3 and DynamoDB tables without writing any code.
DynamoDB import and export features help you easily move, transform, and copy DynamoDB table data between applications, accounts, or AWS regions with a few clicks in the AWS Management console or API calls. For example, you can export your DynamoDB table data to Amazon S3 and use AWS services such as Amazon Athena, Amazon SageMaker, and AWS Lake Formation to analyze your data to extract actionable insights. You can also import data directly into new DynamoDB tables to help you migrate data from other systems, import test data to help you build new applications, facilitate data sharing between tables and accounts, and simplify your disaster recovery and business continuity plans.
How it works
The DynamoDB import and export features do not consume any read or write capacity, and do not require you to develop custom solutions or manage additional infrastructure to perform imports and exports. The process is fully managed by DynamoDB and you can check the status of imports and exports via the AWS console or API calls.
DynamoDB import creates a new DynamoDB table from the data in the source Amazon S3 bucket. You can import data at scale, from a few megabytes to terabytes, using any of the supported formats (CSV, DynamoDB JSON and Amazon Ion).
You can export data from tables with point-in-time recovery (PITR) enabled for any point-in-time in the last 35 days, at a per-second granularity, and the export does not affect the read capacity or the availability of your table. You can export data to S3 in either DynamoDB JSON or Amazon Ion format.
Move data more easily
You can import and export large amounts of data between DynamoDB and Amazon S3 with a few simple clicks in the AWS console or by making an API call.
Simple, pay per GB cost
Importing and exporting data does not consume additional read or write capacity for your DynamoDB tables. Pricing is based on the size of the source file imported into new tables or the size of your DynamoDB table that is exported.
Cross-account and cross-region data sharing
You can import and export data across AWS regions and AWS accounts, which simplifies moving data across applications, facilitates data sharing and collaboration between teams, and helps simplify your disaster recovery and business continuity plan.
Export Amazon DynamoDB table data to your data lake in Amazon S3, no code writing required
by Alex Casalboni
November 9, 2020
Export and analyze Amazon DynamoDB data in an Amazon S3 data lake in Apache Parquet format
by Mazen Ali and Shiladitya Mandal
March 17 2021
Get started by XXXXXXXX