Amazon DynamoDB Connection Help

RazorSQL provides a custom Amazon DynamoDB driver that can communicate with a DynamoDB database via Amazon Web Services (AWS). For information on the SQL support provided by RazorSQL for DynamoDB, click the link below.

DynamoDB SQL Syntax Support

Connecting to DynamoDB with the RazorSQL DynamoDB Driver

To connect to DynamoDB using the RazorSQL DynamoDB driver, open the Connections -> Add Connection Profile menu option and select DynamoDB (Amazon) as the database type. Click continue and select RazorSQL DynamoDB Driver as the connection type.

Next, enter a connection profile name. This will be the name used to identify the connection for connecting again in the future.

Next, enter the Amazon AWS security credentials. These include the AWS Access Key and the AWS Secret Key. These credentials are provided to you when signing up for Amazon Web Servies. You can look up your AWS security credentials by logging in to your AWS account and selecting the Security Credentials section.

Next, enter the AWS server to use. The default server is dynamodb.us-east-1.amazonaws.com. Other options can be found by clicking on the "AWS Server" link on the add connection profile screen.

Next, select whether to encrypt the data passing to and from the DynamoDB web service. To encrypt data, select TRUE in the "Secure" field.

Next, enter the max results per query value. This number specifies the maximum number of rows RazorSQL will retrieve from DynamoDB for a given query.