Mengelola data Anda menggunakan konsol Google Cloud
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Halaman ini menjelaskan cara menjelajahi dan mengelola data Spanner menggunakan Spanner Studio di konsol Google Cloud .
Spanner Studio menyertakan panel Explorer yang
terintegrasi dengan editor kueri dan tabel hasil kueri SQL. Anda dapat menjalankan pernyataan DDL, DML, dan SQL dari satu antarmuka ini. Misalnya, daripada mengonfigurasi alat kueri database pihak ketiga, Anda dapat membuat tabel dan langsung membuat kueri data menggunakan editor kueri.
Anda dapat menggunakan Explorer untuk melihat, menelusuri, dan berinteraksi dengan objek database. Anda dapat membuat, mengubah, dan menghapus objek database
berikut:
Anda dapat menggunakan kolom penelusuran di panel Penjelajah untuk menelusuri objek database berdasarkan nama dalam project Anda. Penelusuran akan menemukan resource yang
langsung cocok, atau berisi kecocokan, dengan kueri penelusuran Anda. Jika istilah penelusuran Anda cocok dengan terlalu banyak resource di tingkat objek database, hasilnya mungkin tidak menampilkan semua kecocokan. Persempit istilah penelusuran Anda, lalu telusuri lagi.
Untuk mengakses Penjelajah, ikuti langkah-langkah berikut:
Di menu navigasi, klik Spanner Studio. Panel
Explorer menampilkan daftar objek dalam database Anda.
Membuat, mengubah, dan membuat kueri data
Dengan editor kueri, Anda dapat menjalankan kombinasi pernyataan DDL, DML, dan SQL
apa pun. Pernyataan harus dipisahkan dengan titik koma. Anda dapat menulis kueri sendiri, atau mengisi editor kueri dengan template.
Pernyataan dijalankan berdasarkan urutan Anda memasukkannya di editor kueri. Pernyataan DDL berturut-turut dikelompokkan dan dikirim untuk dijalankan sekaligus. Untuk mengetahui informasi selengkapnya, lihat
Urutan eksekusi pernyataan dalam batch.
Untuk menyusun, memodifikasi, atau membuat kueri data, ikuti langkah-langkah berikut:
[[["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-09-05 UTC."],[],[],null,["# Manage your data using the Google Cloud console\n\nThis page explains how to explore and manage your Spanner data\nusing Spanner Studio in the Google Cloud console.\n\nSpanner Studio includes an **Explorer** pane that\nintegrates with a query editor and a SQL query results table. You can run DDL,\nDML, and SQL statements from this one interface. For example, instead of\nconfiguring a third-party database query tool, you can create a table and\nimmediately query your data using the query editor.\n\nIf you're new to Spanner, learn how to\n[create and query a database by using the Google Cloud console](/spanner/docs/create-query-database-console).\n\nExplore your data\n-----------------\n\nYou can use the **Explorer** to view, search, and interact with your\ndatabase objects. You can create, alter, and delete the following database\nobjects:\n\n- Tables\n- Columns\n- [Indexes and keys](/spanner/docs/secondary-indexes)\n- [Change streams](/spanner/docs/change-streams)\n- ML models hosted on [Vertex AI](/spanner/docs/ml)\n- [Roles](/spanner/docs/fgac-about)\n- [Views](/spanner/docs/views)\n- [Placements (in preview)](/spanner/docs/geo-partitioning)\n- [Graphs](/spanner/docs/graph/overview)\n - [Nodes](/spanner/docs/graph/schema-overview#property-graph-data-model)\n - [Edges](/spanner/docs/graph/schema-overview#property-graph-data-model)\n- [Saved queries (in preview)](/spanner/docs/saved-queries)\n\n| **Note:** System-level views in the `INFORMATION_SCHEMA` and `SPANNER_SYS` schemas are read-only.\n\nYou can use the search field in the **Explorer** pane to search for database\nobjects by name in your projects. The search finds resources that\ndirectly match, or contain matches, to your search query. If your search term\nmatches too many resources in a database object level, the result might not show\nall matches. Narrow your search term, and search again.\n\nTo access the **Explorer**, follow these steps:\n\n1. In the Google Cloud console, open the **Spanner** page.\n\n [Go to Spanner](https://console.cloud.google.com/spanner)\n2. Select an instance from the list.\n\n3. Select a database.\n\n4. In the navigation menu, click **Spanner Studio** . The\n **Explorer** pane displays a list of the objects in your database.\n\nCreate, modify, and query your data\n-----------------------------------\n\nUsing the query editor, you can run any combination of DDL, DML, and SQL\nstatements. Statements must be separated by a semicolon. You can compose\na query yourself, or you can populate the query editor with a template.\n\nStatements are executed based on the order in which you enter them in the\nquery editor. Consecutive DDL statements are batched and sent for execution all\nat once. For more information, see\n[Order of execution of statements in batches](/spanner/docs/schema-updates#order_of_execution_of_statements_in_batches).\n\nTo structure, modify, or query your data, follow these steps:\n\n1. In the Google Cloud console, open the **Spanner** page.\n\n [Go to Spanner](https://console.cloud.google.com/spanner)\n2. Select an instance from the list.\n\n3. Select a database.\n\n4. In the navigation menu, click **Spanner Studio**.\n\n5. Compose a query using one of the following methods:\n\n - To compose your own query, follow these steps:\n\n 1. Open a new tab by clicking add **New SQL editor tab** or add **New tab**.\n 2. When the query editor appears, write your query.\n - To compose a query starting with a template, follow these steps:\n\n 1. In the **Explorer** pane, next to a database object, click more_vert **View actions**. One or more available actions appear.\n 2. Click an action. The query editor populates with a template.\n 3. Replace any placeholders in the template.\n6. Click **Run** . The results of your query appear in the **Results** table."]]
