PartiQL - a SQL-compatible query language for Amazon DynamoDB - Amazon DynamoDB
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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 Amazon Web Services Management Console, NoSQL Workbench, Amazon 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 Amazon services, including DynamoDB.

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

  • 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 Amazon Command Line Interface (Amazon CLI)

  • The DynamoDB APIs

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