View a markdown version of this page

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 use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

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.