Document and NoSQL
DynamoDB
DynamoDB exposes typed endpoint and credential flows, table/key/index metadata, read-only PartiQL, capacity signals, and guarded conditional item operations.
Prerequisites
- Install the current DataPad++ desktop pre-release on Windows, macOS, or Linux.
- Have the endpoint, database file, or cloud account details for a DynamoDB datastore you are authorized to use. Start with least-privileged, read-only access.
- Keep an independent backup before enabling edits, administration, restore, or transfer execution.
Connect and run a safe query
- 1
Create the connection
Open Library, choose Create connection, and select DynamoDB and a supported Connection method tab.
- 2
Test and save
Complete the applicable fields and enable Read-only connection. Test connection when available; new local files and pending secondary credential changes must be saved first. Review runtime limitations and warnings.

DynamoDB connection setup. The DynamoDB connection dialog with supported method tabs and illustrative, non-secret settings. Expand optional sections and review runtime limitations before saving. Open full size - 3
Open the native explorer
Use Save Connection, or Create Database and Save Connection for a new local file, then open the DynamoDB Explorer where supported.
- 4
Select a scope
Select the database / container scope that should be attached to the new tab.
- 5
Run a bounded read
Open a query tab, paste the bounded read-only sample below, and choose Run or press Ctrl/Cmd+Enter.

DynamoDB native workflow. A representative DynamoDB explorer and bounded read-only workflow. Replace the example objects with names from your datastore. Open full size - 6
Inspect the result
Inspect Results, Messages, History, and Details; dock the panel on the bottom or right as needed.
- 7
Export when needed
Export only the required rows after reviewing format, destination, and redaction options.
- 8
Open diagnostics or transfers
Open Diagnostics or Transfers from the drawer/status bar and treat disabled reasons as capability boundaries, not transient errors.
Connection fields
| Field | Required | Purpose | Safe example |
|---|---|---|---|
| Name | Yes | A clear profile name, without credentials. | DynamoDB development |
| Connection method | Yes | Choose a supported tab. The fields below apply only to the selected method and deployment. | Cloud / endpoint settings |
| Environment | No | Attach the intended variable and safety context. | Local development |
| Read-only connection | No | Enable for initial exploration. This does not make pre-release software safe for production workloads. | Enabled |
| Host / Port | No | Endpoint for a fields-based connection. Follow the selected deployment and runtime limitations; MongoDB SRV does not use an explicit port. | localhost / engine default |
| Database / default scope | No | Initial scope for browsing, where supported. | catalog |
| Local endpoint | No | General. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
| Region | No | General. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
| Scan page size | No | Advanced. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
| Request timeout (ms) | No | Advanced. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
Run the sample query
SELECT productId, productName, category
FROM "Products"
WHERE category = 'active'Explore and inspect
- Browse tables, partition and sort keys, GSIs, LSIs, TTL, streams, backups, capacity, alarms, hot partitions, index coverage, access metadata, and item edit targets.
- Inspect item tables, raw attribute JSON, capacity and pagination signals, key metadata, and before/after GetItem evidence for conditional item edits.
Diagnose, administer, and transfer
- Review consumed capacity, pagination, table metadata, hot partition posture, TTL/stream state, backup posture, alarms, CloudWatch/IAM optional checks, and access previews.
- Preview throughput changes, GSI changes, TTL and stream changes, access checks, backup/restore, export/import, delete table, and cloud metadata operations.
- Import — Live. DynamoDB Local and endpoint-override connections stream exact typed AttributeValue objects through paged Scan and conditional PutItem. Managed S3/Ion jobs remain cloud-gated. Formats: DynamoDB JSON Lines (native). Destinations: local file.
- Export — Live. DynamoDB Local and endpoint-override connections stream exact typed AttributeValue objects through paged Scan and conditional PutItem. Managed S3/Ion jobs remain cloud-gated. Formats: DynamoDB JSON Lines (native). Destinations: local file.
- Backup — Plan only. DynamoDB uses managed backup and restore APIs. Formats: Native managed backup (native). Destinations: managed restore, cloud uri. DynamoDB managed backup and restore require cloud credentials, an isolated target table, and opt-in validation against a real AWS account.
- Restore — Plan only. DynamoDB uses managed backup and restore APIs. Formats: Native managed backup (native). Destinations: managed restore, cloud uri. DynamoDB managed backup and restore require cloud credentials, an isolated target table, and opt-in validation against a real AWS account.

Capabilities and availability
| Capability | Status | Notes |
|---|---|---|
| Native explorer | Available | Browse tables, partition and sort keys, GSIs, LSIs, TTL, streams, backups, capacity, alarms, hot partitions, index coverage, access metadata, and item edit targets. |
| Read queries | Available | Use Query, GetItem, Scan, DescribeTable, raw JSON requests, expression helpers, key-condition builders, projection/filter helpers, and guarded read-only PartiQL ExecuteStatement. |
| Inline editing | Guarded | Requires key evidence, a writable profile, and environment confirmation. |
| Diagnostics / administration | Guarded | Preview throughput changes, GSI changes, TTL and stream changes, access checks, backup/restore, export/import, delete table, and cloud metadata operations. |
| Import / export / transfer | Guarded | Availability follows the authoritative runtime transfer manifest and shows a disabled reason when execution is not implemented. |
Safety and limitations
Troubleshooting
| Symptom | Resolution |
|---|---|
| Test connection fails or times out | Verify endpoint, port, TLS mode, proxy settings, service health, firewall rules, and network access. Keep the profile unsaved until the test explains the failure. |
| Explorer branches are empty or disabled | Confirm the selected database / container, refresh the branch, and grant the minimum metadata permissions described in the connection warning. |
| Run, edit, admin, or transfer is disabled | Read the visible disabled reason. Select a compatible target, turn off read-only only when authorized, or use the documented preview/export fallback. |
| The sample query fails or returns different columns | Replace the example names with objects from your DynamoDB datastore, confirm the selected database / container, and keep the query bounded while you validate the result. |