Managing query versions - Amazon Redshift

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.