Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Membuat koneksi database untuk instance IP publik
Looker (Google Cloud core) harus terhubung ke database agar pengguna dapat menjelajahi data dan membuat konten. Pelajari cara membuat koneksi database untuk instance IP publik Looker (inti Google Cloud) yang akan digunakan sebagai dasar untuk project LookML apa pun, atau untuk project LookML tertentu.
Di halaman beranda Looker (inti Google Cloud), klik tombol Create di menu navigasi utama untuk membuka menu drop-down.
Dari menu drop-down, pilih Connection untuk membuka halaman Connect your database to Looker.
Membuat koneksi database
Di halaman Hubungkan database Anda ke Looker, selesaikan langkah-langkah berikut:
Di bagian Nama, masukkan nama untuk koneksi Anda. Nama ini akan muncul di kolom Koneksi di halaman Buat Model, serta halaman Koneksi.
Di bagian Cakupan Koneksi, pilih Semua Project untuk membuat koneksi yang akan digunakan untuk semua project LookML di instance Looker (inti Google Cloud) Anda, atau pilih Project Terpilih untuk membuat koneksi yang hanya akan digunakan untuk project LookML yang Anda tentukan.
Jika Anda memilih Project Terpilih di bagian Cakupan Koneksi, pilih project yang ingin Anda gunakan untuk koneksi ini.
Di bagian Dialect, pilih dialek yang sesuai untuk database Anda. Anda juga dapat mulai mengetik nama dialek dan Looker akan menampilkan saran untuk nama dialek yang cocok dengan yang Anda ketik.
Setelah Anda memilih dialek untuk koneksi, Looker akan menampilkan kolom setelan koneksi yang berlaku untuk dialek database Anda. Isi setelan berikutnya yang ditampilkan Looker:
Sebagian besar setelan koneksi umum untuk sebagian besar dialek database. Untuk deskripsi setelan database umum, lihat halaman dokumentasi Menghubungkan Looker ke database.
Di bagian Setelan Opsional, luaskan atau ciutkan bagian untuk melihat dan mengonfigurasi opsi yang tersedia untuk koneksi database Anda. Anda juga dapat mengklik Luaskan semua untuk meluaskan semua bagian.
Untuk menguji setelan konfigurasi koneksi, klik Uji. Jika koneksi Anda dikonfigurasi dengan benar, Anda akan melihat tanda centang hijau.
[[["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-25 UTC."],[],[],null,["Create a database connection for a public secure connections instance Looker (Google Cloud core) must be connected to a database to let users explore data and create content. Learn how to create a database connection for a Looker (Google Cloud core) public secure connections instance to use as the basis for any LookML project, or for a specific LookML project.\n\nSee the [Connecting Looker (Google Cloud core) to your database](/looker/docs/looker-core-dialects) documentation page for instructions on creating a database connection for a private IP connection. See the [BigQuery default connection for Looker (Google Cloud core) quickstart](/looker/docs/looker-core-bigquery-default-connection) to use the BigQuery Quickstart Connection to create a default BigQuery connection that can use [Application Default Credentials](/docs/authentication/application-default-credentials).\n| **Note:** This quickstart is for creating a connection to a Looker (Google Cloud core) public secure connections instance using a database dialect that is [supported by Looker (Google Cloud core)](/looker/docs/looker-core-dialects#supported_dialects_for). You can also use this quickstart to create a database connection for a Looker (original) instance\n\nBefore you begin\n\nTo follow along with this quickstart, you'll need the following:\n\n- Access to a Looker (Google Cloud core) instance.\n- You must have the [**Looker Admin**](/looker/docs/admin-panel-users-roles#default_roles) role or have the [`manage_project_connections` Looker permission](/looker/docs/admin-panel-users-roles#manage_project_connections).\n- A database dialect that is compatible with Looker (Google Cloud core). For a list of compatible dialects, see [Supported dialects for Looker (Google Cloud core)](/looker/docs/looker-core-dialects#supported_dialects_for).\n\nNavigate to the Connect your database to Looker page\n\n1. On the Looker (Google Cloud core) homepage, click the **Create** button in the main navigation menu to open the drop-down menu.\n2. From the drop-down menu, select **Connection** to open the **Connect your database to Looker** page.\n\nCreate your database connection\n\nOn the **Connect your database to Looker** page, complete the following steps:\n\n1. In the **Name** section, enter a name for your connection. This name will appear in the **Connection** field of the **Create a Model** page, as well as the **Connections** page.\n\n | **Tip:** Don't use the name of any [folders](/looker/docs/organizing-spaces) for this setting. This value doesn't need to match anything in your database; `Name` is a label that identifies this connection within the Looker UI.\n2. In the **Connection Scope** section, select **All Projects** to create a connection that will be used for all LookML projects in your Looker (Google Cloud core) instance, or select **Selected Project** to create a connection that will be used only for the LookML project that you specify.\n\n3. If you chose **Selected Project** in the **Connection Scope** section, select the project that you want to use this connection for.\n\n4. In the **Dialect** section, choose the appropriate dialect for your database. You can also begin typing the dialect name and Looker will display suggestions for the dialect names that match what you've typed.\n\n5. Once you select a dialect for the connection, Looker displays the connection settings fields that apply to your database dialect. Fill in the subsequent settings that Looker displays:\n\n - The majority of the connection settings are common to most database dialects. For descriptions of common database settings, see the [Connecting Looker to your database](/looker/docs/connecting-to-your-db) documentation page.\n - For instructions for your specific dialect, see the [Connecting Looker (Google Cloud core) to your database](/looker/docs/looker-core-dialects#database_configuration_instructions) documentation page.\n6. In the **Optional Settings** section, expand or collapse the sections to see and configure the available options for your database connection. You can also click **Expand all** to expand all the sections.\n\n7. To test your connection configuration settings, click **Test**. If your\n connection is configured correctly, you'll see a green check mark.\n\n8. To create your connection, click **Create**.\n\nYou can view and manage the connection on the [**Connections** admin page](/looker/docs/admin-panel-database-connections).\n\nWhat's next\n\n- [Generate a model from sample data quickstart](/looker/docs/looker-core-qs-model-generation)\n- [Looker IDE overview](/looker/docs/looker-ide)\n- [Managing LookML files and folders](/looker/docs/creating-project-files)\n- [Common LookML patterns](/looker/docs/additional-lookml-basics)\n- [Using version control and deploying](/looker/docs/version-control-and-deploying-changes)"]]
