Google Cloud Spanner

Stay organized with collections Save and categorize content based on your preferences.

Getting the connection credentials

  1. Log in to the Google Cloud console.

  2. Select the appropriate project.

  3. From the menu, select IAM & Admin and then Service accounts.

  4. Select Create service account and fill in the dialog box as follows:

    • Service account name: Enter looker-spanner-service or something similar.
    • Role: Select Cloud Spanner and then Cloud Spanner Database Reader.
    • Furnish a new private key: Select the Furnish a new private key checkbox, and select JSON under Key type.

  5. Click Create and keep track of the following:

    • The email address associated with the service account
    • The name and location of the JSON credential file that was downloaded

Creating the Looker connection

  1. In the Admin section of Looker, select Connections, and then click Add Connection.
  2. Fill out the connection details (see the Connecting Looker to your database documentation page for more information):

    • Dialect: Google Cloud Spanner.
    • Name: The name of the connection.
    • Project Name: The project ID for the Google project that contains the Spanner database.
    • Instance Name: The name of the instance that contains the Spanner database.
    • Database: The name of the Spanner database.
    • Schema: Leave this blank.
    • Max Connections: The maximum number of total connections to the Spanner database across all users. The default is 30.
    • Connection Pool Timeout: The number of seconds a query will wait before timing out because of a full connection pool.
    • Additional Params: Any additional JDBC driver parameters.
  3. Click Test These Settings to verify a connection.

  4. Click Add Connection.

Feature support

For Looker to support some features, your database dialect must also support them.

In the latest release of Looker, Google Cloud Spanner supports the following Looker features:

References

Next steps

After you have connected your database to Looker, configure sign-in options for your users.