DynamoDB Query Params

Question 1

What Are the DB Query Params

Answer 1

TableName
KeyConditionExpression
ExpressionAttributeValues
ProjectionExpression
FilterExpression
Limit
ExclusiveStartKey
ConsistentRead

Question 2

TableName

Answer 2

Name of table

Question 3

KeyConditionExpression

Answer 3

specify the partition key and sort key (together make the composite primary key)
Example: Partition Key: author_id
Sort Key: post_date

Question 4

ExpressionAttributeValues

Answer 4

like values array in sql queries (for injection attacks)

Question 5

ProjectionExpression

Answer 5

Specify which columns you want

Question 6

FilterExpression

Answer 6

condition for filtering

Question 7

Limit

Answer 7

limit number of items evaluated

Question 8

ExclusiveStartKey

Answer 8

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.

Question 9

ConsistentRead

Answer 9

Query uses “eventually consistent” reads. Setting this to true, all responses are up to date.