Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Konektor Cloud Spanner memungkinkan Anda mengakses data dari Google Cloud Spanner dalam Looker Studio. Cloud Spanner adalah layanan database untuk perusahaan, yang didistribusikan secara global, dan sangat konsisten serta dibuat khusus bagi cloud untuk menggabungkan manfaat struktur database relasional dengan skala horizontal non-relasional.
Di halaman beranda Looker Studio, di kiri atas, klik Buat, lalu pilih Sumber Data.
Pilih konektor Cloud Spanner.
Jika diminta, izinkan Looker Studio untuk mengakses data Anda.
Di sebelah kiri, siapkan koneksi ke database Anda. Anda harus memberikan:
ID Project
ID Instance (lihat bagian Catatan untuk mengetahui cara menampilkan daftar konfigurasi instance Anda).
ID Database
Di kolom teks, masukkan kueri SQL Anda.
Di kanan atas, klik HUBUNGKAN.
Sementara itu, halaman daftar kolom sumber data akan muncul. Klik BUAT LAPORAN untuk mulai memvisualisasikan data Anda.
Catatan
Membuat daftar konfigurasi instance
Alat command line Cloud SDK memungkinkan Anda berinteraksi dengan Cloud Spanner. Misalnya, perintah berikut mencantumkan konfigurasi instance regional dan multi-region yang tersedia untuk project Anda:
gcloud spanner instance-configs list
Konfigurasi regional mendistribusikan data dalam satu region, sementara konfigurasi multi-region mendistribusikan data secara geografis di beberapa region. Pelajari Instance lebih lanjut.
Jenis data
Looker Studio memetakan jenis data bawaan database Anda ke kumpulan jenis data yang terpadu. Jika Looker Studio menemukan kolom dalam tabel Anda atau kueri dari jenis yang tidak didukung, kolom tersebut tidak akan dibuat menjadi kolom.
Batas konektor Spanner
Ukuran respons dari Spanner dibatasi hingga 10 MB. Lihat artikel Batas Spanner untuk batas lainnya.
Header kolom (nama kolom) hanya boleh menggunakan karakter ASCII. Karakter non-ASCII tidak didukung.
[[["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-04 UTC."],[],[],null,["# Connect to Google Cloud Spanner\n\nThe Cloud Spanner connector lets you access data from Google Cloud Spanner within Looker Studio. Cloud Spanner is an enterprise-grade, globally-distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale.\n\nCloud Spanner is a paid service. [Learn more about pricing](https://cloud.google.com/spanner/pricing).\n\nHow to connect to Google Cloud Spanner\n--------------------------------------\n\nA Looker Studio data source can connect to Cloud Spanner databases using [Google Standard SQL query syntax](/spanner/docs/query-syntax).\n\n### To connect\n\n1. [Sign in to Looker Studio.](https://lookerstudio.google.com)\n2. On the Looker Studio home page, in the top left, click **Create** , and then select **Data Source**.\n3. Select the **Cloud Spanner** connector.\n4. If asked, authorize Looker Studio to access your data.\n5. On the left, set up the connection to your database. You'll need to provide:\n 1. Project ID\n 2. Instance ID (see the *Notes* section to find out how to list your instance configurations).\n 3. Database ID\n6. In the text field, enter your SQL query.\n7. In the upper right, click **CONNECT**.\n\nIn a moment, the data source fields list page appears. Click **CREATE REPORT** to start visualizing your data.\n\nNotes\n-----\n\n### List instance configurations\n\nThe [Cloud SDK](https://cloud.google.com/sdk) command-line tool lets you interact with Cloud Spanner. For example, the following command lists the regional and multi-region instance configurations that are available for your project: \n\n\n gcloud spanner instance-configs list\n\nRegional configurations distribute data in a single region, while multi-region configurations distribute data geographically across multiple regions. Learn more about [Instances](/spanner/docs/instances).\n\n### Data types\n\nLooker Studio maps your database's built-in data types to a unified set of [data types](/looker/docs/studio/data-types). If Looker Studio encounters a column in your table or query of an unsupported type, it won't create a field for that column.\n\nLimits of the Spanner connector\n-------------------------------\n\n- The response size from Spanner is limited to 10 MB. See the [Spanner Limits article](https://cloud.google.com/spanner/quotas) for other limits.\n- Column headers (field names) must use ASCII characters only. Non-ASCII characters aren't supported.\n\nTroubleshooting\n---------------\n\nSee the [Looker Studio troubleshooting guide](/looker/docs/studio/troubleshooting-guide) for a list of common error messages and steps to resolve them.\n\nRelated resources\n-----------------\n\n- [Create a data source](/looker/docs/studio/add-data-to-a-report)\n- [Google Cloud Platform overview](https://cloud.google.com/docs/overview/)"]]
Buat, lalu pilih Sumber Data.