SQL reference conventions - Amazon Redshift
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).

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 .

SQL reference conventions

This section explains the conventions that are used to write the syntax for the SQL expressions, commands, and functions described in the SQL reference section.

Character Description
CAPS Words in capital letters are key words.
[ ] Brackets denote optional arguments. Multiple arguments in brackets indicate that you can choose any number of the arguments. In addition, arguments in brackets on separate lines indicate that the Amazon Redshift parser expects the arguments to be in the order that they are listed in the syntax. For an example, see SELECT.
{ } Braces indicate that you are required to choose one of the arguments inside the braces.
| Pipes indicate that you can choose between the arguments.
italics Words in italics indicate placeholders. You must insert the appropriate value in place of the word in italics.
. . . An ellipsis indicates that you can repeat the preceding element.
' Words in single quotation marks indicate that you must type the quotes.