DynamoDB

When you connect DynamoDB to Internal, we'll generate the following automatically:

1. A resource for each table and index within the database.
2. An insert, update, and delete function for each table and index within the database (if the connecting user account has these privileges).

‍

How to connect‍

First, you'll need to configure AWS to work with Internal. Then, enter the following information to connect your database to Internal:

• ‍Name: Give your data source a name for use within Internal. ‍
• Access Key ID: Enter this in for the IAM user you created for Internal. ‍
• Secret Access Key: Enter this in for the IAM user you created for Internal. ‍
• Region: Your AWS region code - see here.

‍

Enabling Filtering

Internal uses the Dynamo Query operation to perform filtering.  This allows filtering on Sort Keys only, for both tables and indexes. We do not use the Dynamo Scan operation for use in filtering as each query would require an entire table scan in order to provide accurate results.
‍

To enable filtering, you can create a Global Secondary Index with a constant partition key and the field you're wanting to filter on as the sort key.  This would group all records into one partition on the index and we'd be able to use the sort key for filtering.  There are no size restrictions on Partition keys for Global Secondary Indexes.