- 최신
- 최다 투표
- 가장 많은 댓글
Hi, @mgvarley.
Unfortunately, when importing CSV, all attributes other than attributes that can be specified as options such as keys and indexes are imported as DynamoDB strings.
This is the current specification.
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/S3DataImport.Format.html
So you need to convert the CSV to DynamoDB Json or Amazon Ion before doing the ingestion.
Thanks for the answer @iwasa this is a shame as it is much faster for us to generate a CSV from a Postgres table (30m rows) than stream out DynamoDB JSON. It would seem logical for this functionality to treat numbers as numbers. Are there any plans on the roadmap to improve this or can we put in a feature request? I suspect there are many users for whom lack of number support would prevent them from using this great new functionality.
Do you have a tool to convert CSV to Dynamo DB JSON?
관련 콘텐츠
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 10달 전
- AWS 공식업데이트됨 10달 전
How are you generating the data you are using for the import? It uses a DDB json format which has the types used in each field, looks like the data is being specified as a string and hence the items are created with the attributes being strings