Query and edit DynamoDB items
Connect to DynamoDB or DynamoDB Local and select a table. In the visual builder, fill in key conditions and attribute filters. To write a statement you can save, edit, and run again, open the PartiQL editor.
Query with the visual builder
- Choose the target table or index in the editor.
- Enter a partition key value for a keyed query. If the selected table or index has a sort key, add a sort-key condition to narrow the results.
- Add extra attribute filters if needed, then run the query. With no partition key value, the builder warns that it will scan. For large tables, start with a key condition when you have one.
- Use the controls in the result panel to page through the response. DynamoDB applies attribute filters after reading items, so later pages may still have matches even if the current page has only a few.
Run a PartiQL statement
Open the PartiQL editor. Replace Orders, customerId, and example-customer with your own table, partition key, and key value.
SELECT * FROM "Orders" WHERE "customerId" = 'example-customer';Choose a template from Sample Queries or write a statement yourself. Run the current statement with the play control or ⌘ + Enter on macOS and Ctrl + Enter on Windows and Linux. Use Query History to find earlier PartiQL statements and visual queries.
Create or edit an item
Use Create Item to add the required primary key values and choose DynamoDB types for other attributes. For an existing row, select Edit Item and change its non-key attributes. The editor has structured inputs for maps, lists, and sets, and accepts Base64 for binary attributes. The create form reports when the primary key already exists.
For indexes, TTL, streams, continuous backups, and capacity metrics, see DynamoDB table management. For file operations, see Import & Export.
