When you connect DynamoDB to Internal, we'll generate the following automatically:
First, you'll need to configure AWS to work with Internal. Then, enter the following information to connect your database to Internal:
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.