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.

See the Connecting Looker (Google Cloud core) to your database documentation page for instructions on creating a database connection to an instance configured for private connections. See the BigQuery default connection for Looker (Google Cloud core) quickstart to use the BigQuery Quickstart Connection to create a default BigQuery connection that can use Application Default Credentials .

Before you begin

To follow along with this quickstart, you'll need the following:

  1. On the Looker (Google Cloud core) homepage, click the Createbutton in the main navigation menu to open the drop-down menu.
  2. From the drop-down menu, select Connectionto open the Connect your database to Lookerpage.

Create your database connection

On the Connect your database to Lookerpage, complete the following steps:

  1. In the Namesection, enter a name for your connection. This name will appear in the Connectionfield of the Create a Modelpage, as well as the Connectionspage.

  2. In the Connection Scopesection, select All Projectsto create a connection that will be used for all LookML projects in your Looker (Google Cloud core) instance, or select Selected Projectto create a connection that will be used only for the LookML project that you specify.

  3. If you chose Selected Projectin the Connection Scopesection, select the project that you want to use this connection for.

  4. In the Dialectsection, 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.

  5. 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:

  6. In the Optional Settingssection, expand or collapse the sections to see and configure the available options for your database connection. You can also click Expand allto expand all the sections.

  7. To test your connection configuration settings, click Test. If your connection is configured correctly, you'll see a green check mark.

  8. To create your connection, click Create.

You can view and manage the connection on the Connectionsadmin page .

What's next

Create a Mobile Website
View Site in Mobile | Classic
Share by: