PartiQL - a SQL-compatible query language for Amazon DynamoDB
Amazon DynamoDB supports 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.
Topics
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
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 Amazon Command Line Interface (Amazon CLI)
-
The DynamoDB APIs
For information about using these methods to access DynamoDB, see Accessing DynamoDB.