Amazon QLDB PartiQL reference - Amazon Quantum Ledger Database (Amazon QLDB)

Amazon QLDB PartiQL reference

Amazon QLDB supports a subset of the PartiQL query language. The following topics describe the QLDB implementation of PartiQL.

  • QLDB does not support all PartiQL operations.

  • All PartiQL statements in QLDB are subject to transaction limits, as defined in Quotas and limits in Amazon QLDB.

  • 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.

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 to support documents in the Amazon Ion data format. For information about Amazon Ion, see the Amazon Ion data format reference.

PartiQL in Amazon QLDB

To run PartiQL queries in QLDB, you can use one of the following:

  • The Query editor on the AWS Management Console for QLDB

  • The command line QLDB shell

  • An AWS-provided QLDB driver to run queries programmatically

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

To learn how to control access to run each PartiQL command on specific tables, see Getting started with the standard permissions mode in Amazon QLDB.