PingFederate enables you to specify a filter or search query for your Amazon Web Services (AWS) DynamoDB datasource, then configure fields for your use case.
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:
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.
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.
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
NULLdata type evaluate to a Boolean
Click Test Attribute Lookup to test your query
- 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.