Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
PartiQL – an SQL-compatible query language for Amazon Redshift
Amazon Redshift supports PartiQL, an SQL-compatible query language, to select, insert, update, and delete data in Amazon Redshift. Using PartiQL, you can easily interact with Amazon Redshift tables and run ad hoc queries using the Amazon Web Services Management Console, SQL Workbench/J, the Amazon Command Line Interface, and Amazon Redshift Data APIs for PartiQL.
PartiQL operations provide the same availability, latency, and performance as the other Redshift data plane operations.
The following sections describe the Amazon Redshift implementation of PartiQL.
What is PartiQL?
PartiQL provides SQL-compatible query access across multiple data stores containing structured, semi-structured, and nested data. It is widely used within Amazon and is now available as part of many Amazon services, including Amazon Redshift.
For the PartiQL specification and a tutorial on the core query language, see the
PartiQL overview
For examples of using PartiQL queries in Amazon Redshift with semi-structured data, see Examples of using semi-structured data in Amazon Redshift.
Note
-
Amazon Redshift supports a subset of the PartiQL query language.
-
Amazon Redshift doesn't support the Amazon Ion
data format or Amazon Ion literals.
PartiQL in Amazon Redshift
To run PartiQL queries in Amazon Redshift, you can use the following methods:
The Amazon Web Services Management Console
SQL Workbench/J
The Amazon CLI
Amazon Redshift Data APIs for PartiQL