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.
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
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.
|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.|