Amazon QLDB PartiQL reference
Amazon QLDB supports a subset of the PartiQL
QLDB does not support all PartiQL operations.
This reference provides basic syntax and usage examples of PartiQL statements that you manually run on the QLDB console or the QLDB shell. For code examples that show how to programmatically run similar statements using the QLDB driver, see the tutorials in Getting started with the driver.
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 AWS services, including QLDB.
For the PartiQL specification and a tutorial on the core query language, see the
PartiQL documentation
PartiQL extends SQL-92
PartiQL in Amazon QLDB
To run PartiQL queries in QLDB, you can do one of the following:
-
Use the Query editor on the AWS Management Console for QLDB.
-
Use the command line QLDB shell.
-
Run them programmatically using a provided QLDB driver.
For information about using these methods to access QLDB, see Accessing Amazon QLDB.