이 페이지에서는 저장된 쿼리를 만들고 관리하는 방법을 설명합니다. Cloud SQL Studio에서 SQL 스크립트를 작성할 때 이러한 SQL 스크립트를 저장하고 관리할 수 있습니다. 자세한 내용은 저장된 쿼리 개요를 참고하세요.
저장된 쿼리 기능은 Google Cloud 콘솔에서만 사용할 수 있습니다.
필요한 역할
저장된 쿼리를 사용하는 데 필요한 권한을 얻으려면 관리자에게 프로젝트에 대한 다음 Identity and Access Management (IAM) 역할을 부여해 달라고 요청하세요.
저장된 쿼리를 보려면 Cloud SQL Studio 사용자(roles/cloudsql.studiouser)가 필요합니다.
저장된 쿼리 페이지에 대한 액세스를 포함하여 프로젝트에서 저장된 쿼리를 생성, 수정, 확인, 삭제하려면 Cloud SQL 관리자 (roles/cloudsql.admin) 또는 Studio 쿼리 사용자 (roles/databasesconsole.studioQueryUser)가 필요합니다.
저장된 쿼리 페이지에 대한 액세스를 포함하여 프로젝트의 모든 저장된 쿼리를 관리하려면 Studio 쿼리 관리자 (roles/databasesconsole.studioQueryAdmin)가 필요합니다.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-09-04(UTC)"],[],[],null,["# Create and manage saved queries\n\n\u003cbr /\u003e\n\nMySQL \\| [PostgreSQL](/sql/docs/postgres/create-manage-saved-queries \"View this page for the PostgreSQL database engine\") \\| [SQL Server](/sql/docs/sqlserver/create-manage-saved-queries \"View this page for the SQL Server database engine\")\n\n\u003cbr /\u003e\n\n|\n| **Preview**\n|\n|\n| This feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n\nThis page describes how to create and manage saved queries. When you write\nSQL scripts in Cloud SQL Studio,\nyou can save and manage those SQL scripts. For more information, see [Saved queries overview](/sql/docs/mysql/saved-queries)\n.\n\nThe saved queries capability is available only in the Google Cloud console.\n\nRequired roles\n--------------\n\nTo get the permissions that you need to use saved queries, ask your\nadministrator to grant you the following Identity and Access Management (IAM) roles on\nthe project:\n\n- To view saved queries: Cloud SQL Studio User (`roles/cloudsql.studiouser`)\n- To create, edit, view, and delete saved queries in a project, including access to the **Saved queries** page: Cloud SQL Admin (`roles/cloudsql.admin`) or [Studio Query User](/iam/docs/roles-permissions/databasesconsole) (`roles/databasesconsole.studioQueryUser`)\n- To manage all saved queries in a project, including access to the **Saved queries** page: [Studio Query Admin](/iam/docs/roles-permissions/databasesconsole) (`roles/databasesconsole.studioQueryAdmin`)\n\nFor more information about granting roles, see [Manage access to projects, folders, and organizations](/iam/docs/granting-changing-revoking-access).\n\nThese predefined roles contain the permissions required to use saved\nqueries. To learn more about required permissions, see [Required permissions](#required-permissions).\n\n### Required permissions\n\nTo create, view, modify, and delete saved queries, you need the following IAM\npermissions at the project level:\n\n| **Note:** Having access to saved queries doesn't automatically mean that you have permissions to run the query.\n\nYou can also get these permissions using [custom roles](/iam/docs/creating-custom-roles)\nor other [predefined roles](/iam/docs/roles-overview#predefined).\n\nThe [Studio Query User](/iam/docs/roles-permissions/databasesconsole)\n(`roles/databasesconsole.studioQueryUser`)\nrole provides create, view, and write saved queries access. This role meets\nthe needs of most users.\n\nGrant the [Studio Query Admin](/iam/docs/roles-permissions/databasesconsole)\n(`roles/databasesconsole.studioQueryAdmin`)\nrole only to administrators. For more information about\nCloud SQL for MySQL IAM, see [Roles and permissions](/sql/docs/mysql/roles-and-permissions)\n.\n\nCreate a saved query\n--------------------\n\nTo create a saved query, follow these steps:\n\n1. In the Google Cloud console, go to the **Cloud SQL Instances** page.\n\n [Go to Cloud SQL Instances](https://console.cloud.google.com/sql)\n2. Select the instance in which you want to create a saved query.\n3. In the navigation menu, click **Cloud SQL Studio**.\n4. On the **Cloud SQL Studio** page, click add **New tab** or use the empty editor tab.\n5. In the query editor, enter a SQL query.\n6. Click **Save**.\n7. In the **Save query** dialog, enter a name for the saved query.\n8. Click **Save**.\n\nOpen and run a saved query\n--------------------------\n\nTo open a saved query as a new query, follow these steps:\n\n1. In the **Explorer** pane on the **Cloud SQL Studio** page, navigate to the **Queries** section.\n2. Click a saved query to open it in a new editor tab. Optionally, you can click more_vert **View actions** next to a saved query. Then, click **Open query** to open it in a new editor tab.\n3. Click **Run**.\n\nUpdate a saved query\n--------------------\n\nTo update an existing saved query, follow these steps:\n\n1. In the **Explorer** pane on the **Cloud SQL Studio** page, navigate to the **Queries** section.\n2. Click a saved query to open it in a new editor tab. Optionally, you can click more_vert **View actions** next to a saved query. Then, click **Open query** to open it in a new editor tab.\n3. Modify the query.\n4. To save the modified query, click **Save**.\n\nView and manage a list of all saved queries\n-------------------------------------------\n\nTo view a list of all saved queries in your project, follow these steps:\n\n1. In the Google Cloud console, go to the **Cloud SQL Instances** page.\n\n [Go to Cloud SQL Instances](https://console.cloud.google.com/sql)\n2. Select any instance. Because a saved query is a child of a project, as long as you have the required role, you can view all saved queries in the project from any instance or database.\n3. In the navigation menu, click **Cloud SQL Studio** and [authenticate](/sql/docs/mysql/manage-data-using-studio#authentication).\n\n\u003c!-- --\u003e\n\n3. Select any database.\n4. In the **Explorer** pane on the **Cloud SQL Studio** page, navigate to the **Queries** section.\n5. Click more_vert **View actions** next to a saved query. Then, click **Manage queries** .\n\n The **Saved queries** page opens. This page lists all the saved\n queries in this project, including saved queries for other\n Google Cloud products.\n\nYou can search, filter, view, and delete queries on the **Saved queries**\npage. You can't edit an existing query on the **Saved queries** page.\n\nDelete a saved query\n--------------------\n\nYou can delete a saved query from the **Cloud SQL Studio**\npage or on the **Saved queries** page in the Google Cloud console.\n\n1. In the Explorer pane on the **Cloud SQL Studio** page, navigate to the Queries section.\n2. Click more_vert **View actions** next to the saved query that you want to delete. Then click **Delete query** to delete the saved query.\n3. In the **Delete query** dialog, click **Delete**.\n\nYou can also delete a saved query on the **Saved queries** page. To delete a saved query on\nthe **Saved queries** page, follow these steps:\n\n1. Navigate to the [**Saved queries**](#view-and-manage) page.\n2. Click more_vert **View actions** next to the saved query that you want to delete.\n3. Click **Delete query** to delete the saved query.\n4. In the **Delete query** dialog, click **Delete**.\n\nWhat's next\n-----------\n\n- Learn about [saved queries](/sql/docs/mysql/saved-queries)."]]
