Managing query versions - 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 .

Managing query versions

Every time you save a SQL query, the query editor v2 saves it as a new version. You can browse earlier query versions, save a copy of a query, or restore a query.

To manage query versions

  1. Choose Queries from the navigation pane.

  2. Open the context (right-click) menu for the query that you want to work with.

  3. Choose Version history to open a list of versions of the query.

  4. On the Version history page, you can do the following:

    • Revert to selected – Revert to the selected version and continue your work with this version.

    • Save selected as – Create a new query in the editor.