PartiQL - a SQL-compatible query language for Amazon DynamoDB - Amazon DynamoDB

PartiQL - a SQL-compatible query language for Amazon DynamoDB

Amazon DynamoDB supports PartiQL, a SQL-compatible query language, to select, insert, update, and delete data in Amazon DynamoDB. Using PartiQL, you can easily interact with DynamoDB tables and run ad hoc queries using the AWS Management Console, NoSQL Workbench, AWS Command Line Interface, and DynamoDB APIs for PartiQL.

PartiQL operations provide the same availability, latency, and performance as the other DynamoDB data plane operations.

The following sections describe the DynamoDB implementation of PartiQL.

What is PartiQL?

PartiQL provides SQL-compatible query access across multiple data stores containing structured data, semistructured data, and nested data. It is widely used within Amazon and is now available as part of many AWS services, including DynamoDB.

For the PartiQL specification and a tutorial on the core query language, see the PartiQL documentation.

Note
  • Amazon DynamoDB supports a subset of the PartiQL query language.

  • Amazon DynamoDB does not support the Amazon ion data format or Amazon Ion literals.

PartiQL in Amazon DynamoDB

To run PartiQL queries in DynamoDB, you can use:

  • The DynamoDB console

  • The NoSQL Workbench

  • The AWS Command Line Interface (AWS CLI)

  • The DynamoDB APIs

For information about using these methods to access DynamoDB, see Accessing DynamoDB.