Specifying filters and fields in the DynamoDB datastore optimizes data retrieval, improves query performance, and enhances application responsiveness by narrowing down search results and selecting specific attributes.

To set up queries on an AWS DynamoDB datastore to use during attribute lookup:

  1. In the Configure Data Source Filters window, specify a filter or search query for your data source.

    For information about each field, see the following table.

    Field Description

    Index Name

    The name of the DynamoDB index to perform the query on. Leave this field blank to query the base table.

    Key Condition Expression

    The key condition expression to use for the DynamoDB query. For more information, see Key condition expressions for query in the AWS DynamoDB documentation.

    Filter Expression

    Optional filter expression to define for the DynamoDB query. For more information, see Filter expressions for query in the AWS DynamoDB documentation.

    Expression Attribute Values

    The expression attribute values that map to the reference in the key condition expression and the filter expression. You can use references to attributes in the context of the transaction. For more information, see Expression attribute values in the AWS DynamoDB documentation.

    Expression Attribute Names

    Optionally define the expression attribute names to reference in the key condition expression and the filter expression. For more information, see Expression attribute names in the AWS DynamoDB documentation.
    Note:

    Values with a NULL data type evaluate to a Boolean true result.

  2. Click Test Attribute Lookup to test your query configuration.
    • If you have correctly configured the query, <Local Attribute Names> and <Test Result Values> are returned.
    • If there is an error in the query, an error message is returned.