Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Halaman ini menjelaskan dan menerangkan cara kerja kueri tersimpan di Spanner.
Anda dapat menggunakan Spanner Studio untuk membuat, menyimpan, dan mengelola skrip SQL sebagai kueri tersimpan. Kemampuan kueri tersimpan hanya tersedia di
konsolGoogle Cloud .
Kueri tersimpan memiliki karakteristik berikut:
Semua kueri dienkripsi.
Kueri tersimpan adalah turunan dari project.
Kueri tersimpan akan dihapus saat project dihapus. Jika Anda menghapus instance atau database, kueri tersimpan di project masih dapat diakses menggunakan
halaman Kueri tersimpan
di konsol Google Cloud .
Anda harus memiliki peran atau izin IAM yang benar untuk melihat dan mengelola kueri tersimpan.
Anda hanya dapat mengakses kueri tersimpan menggunakan Spanner Studio atau dengan
membuka halaman Kueri tersimpan di konsol Google Cloud . Tidak ada
API untuk mengakses kueri tersimpan.
Lokasi penyimpanan
Spanner menyimpan semua kueri tersimpan di region us-central1.
Batasan
Kueri tersimpan memiliki batasan berikut:
Anda tidak dapat membuat lebih dari 10.000 kueri tersimpan dalam satu project (termasuk kueri tersimpan untuk produk Google Cloud lain). Untuk mengetahui informasi selengkapnya, lihat Kuota dan batas.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-08-17 UTC."],[],[],null,["# Saved queries overview\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 saved queries work in Spanner.\n\nYou can use Spanner Studio\nto create, save, and manage SQL scripts as saved queries. The saved queries capability is\navailable only in the Google Cloud console.\n\nSaved queries have the following characteristics:\n\n- All queries are encrypted.\n- A saved query is a child of a project.\n- Saved queries are deleted when the project is deleted. If you delete the instance or database, you can still access saved queries in the project using the [**Saved queries** page](/spanner/docs/create-manage-saved-queries) in the Google Cloud console.\n- You must have the correct [Identity and Access Management (IAM) role or permissions](/spanner/docs/create-manage-saved-queries#required-roles) to view and manage saved queries.\n- You can only access saved queries using the Spanner Studio or by navigating to the **Saved queries** page in the Google Cloud console. Saved queries aren't accessible through the API.\n\nStorage location\n----------------\n\nSpanner stores all saved\nqueries in the `us-central1` region.\n\nLimitations\n-----------\n\nSaved queries has the following limitations:\n\n- You can't create more than 10,000 saved queries in a project---including saved queries for other Google Cloud products. For more information, see [Quotas and limits](/spanner/quotas).\n- You can't use [customer-managed encryption keys](/spanner/docs/cmek) for instances with saved queries.\n\nPricing\n-------\n\nThere is no additional charge for using or storing saved queries.\n\nWhat's next\n-----------\n\n- Learn how to [create and manage saved queries](/spanner/docs/create-manage-saved-queries).\n- Learn how to [manage data using the Google Cloud console](/spanner/docs/manage-data-using-console)."]]
