DynamoDB Query Params Flashcards
What Are the DB Query Params
TableName
KeyConditionExpression
ExpressionAttributeValues
ProjectionExpression
FilterExpression
Limit
ExclusiveStartKey
ConsistentRead
TableName
Name of table
KeyConditionExpression
specify the partition key and sort key (together make the composite primary key)
Example: Partition Key: author_id
Sort Key: post_date
ExpressionAttributeValues
like values array in sql queries (for injection attacks)
ProjectionExpression
Specify which columns you want
FilterExpression
condition for filtering
Limit
limit number of items evaluated
ExclusiveStartKey
Used for pagination. It’s the last key in a previously received response, allowing you to retrieve the next set of results from where the last query left off.
ConsistentRead
Query uses “eventually consistent” reads. Setting this to true, all responses are up to date.