danishi / dynamodb-csv

A utility that allows CSV import / export to DynamoDB on the command line
https://danishi.github.io/dynamodb-csv/
MIT License
19 stars 4 forks source link

Match Dynamo types to CSV_SPEC types #214

Open daveharig opened 2 weeks ago

daveharig commented 2 weeks ago

The CSV_SPEC is confusing because the type names don't line up with Dynamo types.

Dynamo types are: String (S) Number (N) Binary (B) Boolean (BOOL) Null (NULL) Map (M) List (L) String Set (SS) Number Set (NS) Binary Set (BS)

CSV_SPEC types are currently: String : S Integer : I Decimal : D Boolean : B (blank false) Json : J StringList : SL StringSet : SS DecimalList : DL DecimalSet : DS

danishi commented 2 weeks ago

@daveharig Thank you for your feedback!

I remember that the CSV files can only handle text data, so we had to map the data types to DynamoDB types within the program, which made it a bit confusing. While it's best to standardize the data types, I'll start by updating the documentation to make things clearer!

danishi commented 2 weeks ago

https://github.com/danishi/dynamodb-csv/commit/b2ff88758c8869b817cdc585e519183b99ec8088