Depending on what is your goal, I would look into 3 options:
- If you want to just dump, a quick script in language you prefer would do the job
- If you want to dump periodically, I would suggest to make Lambda out of it - here is a result of quick googling with working example: https://medium.com/@jrodl3r/exporting-dynamodb-data-to-excel-using-lambda-with-s3-on-aws-e6f873681c77
- If you need to work dynamically with the given data, let`s say to slice & dice, filter, etc analyse it by users - consider using AWS Quicksight with DynamoDB as data source.
DynamoDB does not provide the ability to export the entire table to CSV, only a small sub-set.
The best way I have found is using Athena's capability to export to CSV, this is done using the
The next suggestion approach is to come up with your own logic/script to export the table to CSV using Lambda and Event Bridge to periodically kick off the job. There are many tools available to assist you with converting JSON to CSV and even tools to do the entire process for you such as:
And finally, if your table is really large you can use AWS Glue to run a periodic ETL job which will read from DynamoDB and export to CSV in an S3 Bucket:
Overall it depends on your specific use-case needs on which option to use.
I think the second option is the one we go with. Just dumping periodically. But this is more for sending it through email? is their a way to store it in ... a bucket?
I was planning to create a lambda with an Event bridge. And storing the file on aws S3. Should that be the best way? So we can download Excel files from the bucket or can we acces Excel in aws it self?
QuickSight Analysis Export to Excel Limitasked 9 months ago
Is it possible to connect MS Excel to Aurora?asked 3 years ago
Data sources, integrations and exportingasked 5 months ago
In need of exporting dynamodb table into csvasked 13 days ago
I don't get an option to export data to excelasked 3 months ago
Should I Use Angolia or OpenSearch instead of DynamoDB? If so in what case.asked 7 months ago
What is the best way to import data to an existing DynamoDB table?Accepted Answerasked 3 months ago
Export dynamodb data as Excel filesasked 20 days ago
Can we export the mongodb using the data pipeline?asked 7 years ago
How to upload large Excel file into Quicksight?Accepted AnswerMODERATORasked 2 years ago