1 個回答
- 最新
- 最多得票
- 最多評論
6
One such way to do it programmatically is doing a Scan operation and formatting the data to CSV:
aws dynamodb scan \
--table-name <table_name> \
--select ALL_ATTRIBUTES \
--page-size 500 \
--max-items 10000 \
--output json | jq -r '.Items' | jq -r '(.[0] | keys_unsorted) as $keys | $keys, map([.[ $keys[] ][]?])[] | @csv' > my-table-3.csv
Another way is using AWS Datapipeline to export the table to CSV and stores it directly on S3:
https://docs.aws.amazon.com/datapipeline/latest/DeveloperGuide/dp-template-exportddbtos3.html
And finally you can use AWS Glue to read the DynamoDB table and write to S3 in CSV format:
There is also third party options available, many of which you must pay for such as DynoBase:
相關內容
- 已提問 1 年前
AWS 官方已更新 9 個月前- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 1 年前
Pipelines are not available in my region ? is that a problem?
No, thats not a problem. You can point DP to any region you like.
Tried to set it up and ending up with these warns : WARNING: Error occurred while validating resourceRole 'DataPipelineDefaultRole'. Need iam:ListRolePolicies and iam:GetRolePolicy to validate. Error: User: arn:aws:sts::838788886576:assumed-role/DatapipelineroleTest/EDPSession is not authorized to perform: iam:ListRolePolicies on resource: role DataPipelineDefaultRole because no identity-based policy allows the iam:ListRolePolicies action (Service: AmazonIdentityManagement; Status Code: 403; Error Code: AccessDenied; Request ID: de5a8221-c306-49a8-918f-2939777f3e79; Proxy: null) , Not sure what it all means?
Read the info in these docs: https://docs.aws.amazon.com/datapipeline/latest/DeveloperGuide/dp-iam-roles.html
I've been trying with datapipeline but getting stuck at the IAM roles? Completed these doc:https://docs.aws.amazon.com/datapipeline/latest/DeveloperGuide/dp-iam-roles.html#dp-role-example-policy but not able to resolve my errors. Can someone help me out please ?