Use saved queries - Amazon Athena
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).

Use saved queries

You can use the Athena console to save, edit, run, rename, and delete the queries that you create in the query editor.

Considerations and limitations

  • You can update the name, description, and query text of saved queries.

  • You can only update the queries in your own account.

  • You cannot change the workgroup or database to which the query belongs.

  • Athena does not keep a history of query modifications. If you want to keep a particular version of a query, save it with a different name.

Note

Amazon Athena resources can now be accessed within Amazon SageMaker Unified Studio (Preview), which helps you access your organization's data and act on it with the best tools. You can migrate saved queries from an Athena workgroup to a SageMaker Unified Studio project, configure projects with existing Athena workgroups, and maintain necessary permissions through IAM role updates. For more information, see Migrating Amazon Athena resources to Amazon SageMaker Unified Studio (Preview).