Chat now with support
Chat with Support

Toad Data Point 5.0 - User Guide

About DynamoDB Data Sources

Amazon DynamoDB is one of the NoSQL data source connections supported by Toad. You can use the connection to view and query tables in a DynamoDB database service.

To learn how to create a connection to Amazon DynamoDB, see Create Amazon DynamoDB Connections.

Toad Automatically Maps Tables

When you create a new DynamoDB connection, Toad automatically maps the data source objects. Toad gathers metadata which is cached (in a hidden table) and retained between sessions for one week. After one week, all objects are automatically refreshed. You can manually refresh the objects at any time.

To refresh DynamoDB tables

  • In the Object Explorer, select a table and then select View | Refresh All.

During the initial connection process, Toad maps only metadata. The actual data in each column is mapped as needed, such as when you execute a query.

Considerations and Limitations

Consideration / Limitation Description
Objects in Object Explorer The Object Explorer displays the DynamoDB tables that were mapped by Toad, either when the connection was initially created or when the objects were refreshed.
Max character limit Toad maps up to 255 characters per VARCHAR data field.
Delay when executing query DynamoDB columns and data are mapped as needed. Because of this, you may experience a delay when attempting to view columns and data or when executing a query.
Read-only DynamoDB connections are read-only. You cannot create tables using Toad. You cannot import data into a DynamoDB data source from Toad.

 

  

Related Topics

Related Documents