Amazon DynamoDB

Connect TableR to Amazon DynamoDB with AWS access credentials and a region, run PartiQL statements, verify the connection, and troubleshoot — via the dynamodb-driver plugin.

DynamoDB is reached through its JSON API (ExecuteStatement / PartiQL) — the connection is provided by the dynamodb-driver plugin (install it from the plugins page). Provide a region or a custom endpoint, plus an AWS access key pair.

Overview

TableR calls the DynamoDB ExecuteStatement API over HTTPS and queries tables with PartiQL — one statement per request. The host field accepts either an AWS region name (the regional endpoint is derived) or a full endpoint URL for DynamoDB Local or compatible services.

PartiQL — queries run through the ExecuteStatement API; SELECT is supported.
SigV4 auth — the username field takes your AWS access key ID; the password field the secret access key.
Plugin-gated — the DynamoDB card appears once the dynamodb-driver plugin is installed.
Custom endpoints — point the host at DynamoDB Local or another compatible endpoint by URL.

Before you start

The dynamodb-driver plugin installed (Plugins → Amazon DynamoDB → Install).
An AWS access key ID and secret access key with DynamoDB read permission.
The AWS region your tables live in (or a full endpoint URL for local testing).

Connection fields

These fields match TableR's DynamoDB connection form. The secret access key is stored in the operating system keyring, never in plain configuration files.

Field	Required	Default	Notes
Host	Yes	—	An AWS region (e.g. us-east-1) or a full endpoint URL (e.g. http://localhost:8000).
Region	No	—	Optional; derived from the host when it is an AWS region or an AWS endpoint URL.
Username	Yes	—	Your AWS access key ID (used for SigV4 signing).
Password	Yes	—	Your AWS secret access key; stored in the OS keyring.

Connect with the form

1
Install the DynamoDB plugin
Open Plugins, find Amazon DynamoDB, and install the dynamodb-driver plugin.
2
Choose DynamoDB
Open the launcher and pick the Amazon DynamoDB card.
3
Enter region or endpoint
Type an AWS region like us-east-1, or a full endpoint URL for DynamoDB Local.
4
Add AWS credentials
Username = access key ID, Password = secret access key; the secret is saved to the keyring.
5
Save and connect
Save the profile so it reappears in the launcher, then connect.

Verify the connection

Once connected, open a query tab and run PartiQL against a table:

SELECT * FROM your_table LIMIT 10;

If rows return, the credentials, region, and endpoint are all correct.

Troubleshooting

Symptom	Likely cause	Fix
DynamoDB card missing	The dynamodb-driver plugin is not installed.	Open Plugins and install the Amazon DynamoDB driver, then retry.
DynamoDB requires the AWS access key id in the username field	The username field is empty.	Enter your AWS access key ID in the username field.
Signature mismatch / UnrecognizedClientException	Wrong secret access key or key pair.	Re-check the access key ID and secret; update the saved password in the keyring.
Could not resolve endpoint	Invalid region or endpoint URL.	Use a valid AWS region name, or a full http(s) endpoint URL including the host.
ResourceNotFoundException	The queried table does not exist in this region.	Confirm the table name and that the region matches your tables.

Next steps

SQL workspace

Write and run queries, manage tabs, and read results.

Exploring data

Browse schemas, tables, and columns, and search across databases.

All engines

Back to the connections overview and the full engine list.

Was this page helpful?

Edit this page on GitHub

Overview

PartiQL — queries run through the ExecuteStatement API; SELECT is supported.

SigV4 auth — the username field takes your AWS access key ID; the password field the secret access key.

Plugin-gated — the DynamoDB card appears once the dynamodb-driver plugin is installed.

Custom endpoints — point the host at DynamoDB Local or another compatible endpoint by URL.

Connection fields

These fields match TableR's DynamoDB connection form. The secret access key is stored in the operating system keyring, never in plain configuration files.

Field	Required	Default	Notes
Host	Yes	—	An AWS region (e.g. us-east-1) or a full endpoint URL (e.g. http://localhost:8000).
Region	No	—	Optional; derived from the host when it is an AWS region or an AWS endpoint URL.
Username	Yes	—	Your AWS access key ID (used for SigV4 signing).
Password	Yes	—	Your AWS secret access key; stored in the OS keyring.

Connect with the form

Install the DynamoDB plugin

Open Plugins, find Amazon DynamoDB, and install the dynamodb-driver plugin.

Choose DynamoDB

Open the launcher and pick the Amazon DynamoDB card.

Enter region or endpoint

Type an AWS region like us-east-1, or a full endpoint URL for DynamoDB Local.

Add AWS credentials

Username = access key ID, Password = secret access key; the secret is saved to the keyring.

Save and connect

Save the profile so it reappears in the launcher, then connect.

Troubleshooting

Symptom	Likely cause	Fix
DynamoDB card missing	The dynamodb-driver plugin is not installed.	Open Plugins and install the Amazon DynamoDB driver, then retry.
DynamoDB requires the AWS access key id in the username field	The username field is empty.	Enter your AWS access key ID in the username field.
Signature mismatch / UnrecognizedClientException	Wrong secret access key or key pair.	Re-check the access key ID and secret; update the saved password in the keyring.
Could not resolve endpoint	Invalid region or endpoint URL.	Use a valid AWS region name, or a full http(s) endpoint URL including the host.
ResourceNotFoundException	The queried table does not exist in this region.	Confirm the table name and that the region matches your tables.