Import

Move data in without a script.

Bulk import from CSV, TSV, and JSON, a DynamoDB JSON file, or a DynamoDB export in S3, through one wizard: Data Source, Mapping, Validate, Settings, Import. Every error is listed before anything writes, and the run reports what it wrote.

Download Free

Highlights

01Three sources

File or editor takes JSON, CSV, or TSV by drop, browse, or paste, with a Format button that tidies what you pasted. DynamoDB JSON file takes an array, JSON Lines, or export lines, gzipped or not. S3 export opens a DynamoDB export straight from its bucket.

02Five named steps

Data Source, Mapping, Validate, Settings, Import, on a rail across the top. A finished step turns into a button that takes you back to it. An S3 export adds a Destination step after Data Source.

03Validate before commit

Every failing cell takes a red border, and the errors panel lists each one by row, field, and message. Next stays inert, with the reason beside it, until they are resolved.

04Overwrite or merge

Overwrite replaces any item with the same key. Merge combines attributes and asks which side wins in a conflict. Concurrency and Batch Size are yours to set, and a summary chip names the items, fields, and target table before you start.

05Into a new table

Choose Create a new table for an S3 export, and DynamoDB ImportTable builds the table and reads the export itself. The key and the global secondary indexes can be copied from the table the export came from.

06A run you can stop

Written, Errors, and Remaining tiles update as batches land. Stop import halts the queue and keeps the counts. Any batch DynamoDB rejects is listed by item count, first and last key, and message. An S3 export or a DynamoDB JSON file keeps running in Transfers if you close the dialog.

Everything inside

Data SourceFile or editor is a drop zone beside an editor seeded with a template for the selected format. Dropping a file sets the format from its extension and formats the contents. S3 export takes an s3:// location and shows the export's items, data files, and format, and which destinations can take it.
MappingIncoming, Type, Destination, Ignore. Two badges track fields mapped and required fields mapped over a completion bar, and the Data preview shows sample values for the selected row. From an S3 export or a DynamoDB JSON file, every attribute keeps its own name unless you rename it.
ValidateMap and list values render as a one-line JSON summary, missing values as null or empty, and a column with errors is marked in its header.
SettingsConflict Resolution and Merge Strategy on the left, Concurrency and Batch Size on the right, with a hint on what higher values cost in write capacity.
ImportProgress over a bar, Stop import, and an Errors table with one row per rejected batch: Batch, Items, Keys, Message, and Error code. Copy errors carries the full set.
Locked while runningAn import from a file or the editor cannot be dismissed mid-run. After a stop, Back returns to Settings so the run can be adjusted and started again. Files come in through the OS file picker, not a web-style upload box.

Goes well with

From file to table in minutes.

Download Free