Posted On: Jan 18, 2022

Amazon DynamoDB supports PartiQL - a SQL-compatible query language that lets you query, insert, update, and delete table data in DynamoDB. Now DynamoDB PartiQL APIs support ReturnConsumedCapacity, an optional parameter that returns the total read and write capacity consumed, along with statistics for the table and any indexes involved in an operation, to help you optimize your queries and throughput costs.

PartiQL support with DynamoDB makes it easier to interact with DynamoDB by providing developers the option to use a familiar structured query language to perform read and write operations on DynamoDB table data. With PartiQL, DynamoDB continues to provide consistent, single-digit millisecond latency at scale. The new ReturnConsumedCapacity parameter is supported in all three PartiQL APIs - ExecuteStatement, BatchExecuteStatement, and ExecuteTransaction. For more information about using ReturnConsumedCapacity, see ExecuteStatement API reference. To learn more about PartiQL with DynamoDB, see PartiQL – A SQL-Compatible Query Language for Amazon DynamoDB.