First, you'll need to configure AWS to work with Internal. Then, enter the following information to connect your database to Internal:
When you connect DynamoDB to Internal, we'll generate the following automatically:
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 on specific columns, you can create a Global Secondary Index with a constant partition key and the field you want to filter on as the sort key. This groups all records into one partition on the index, allowing the sort key to be used for filtering purposes. There are no size restrictions on Partition keys for Global Secondary Indexes.
All operators are supported for the partition key. Only the "=" operator is supported for sort keys.