home User Guide Getting Started Help Center Documentation Community Training Certification
Looker keyboard_arrow_down
language keyboard_arrow_down
Looker documentation will be moving to cloud.google.com in mid-2022!
All the information you rely on will be migrated and all docs.looker.com URLs will be redirected to the appropriate page.
Google Cloud SQL

Users and security

Create a database user that can connect Cloud SQL to Looker. In the following commands, change some_password_here to a unique, secure password, and grant SELECT privileges to the database you want Looker to query:

CREATE USER looker; SET PASSWORD FOR looker = PASSWORD ('some_password_here'); GRANT SELECT ON database_name.* TO looker;

Connecting the database

In the Admin section of Looker, select Connections, and then select New Connection.

Fill out the connection details (see the Connecting Looker to your database documentation page for more information):

PDT support

Google Cloud SQL does not support CREATE TABLE AS SELECT statements, so you must use the create_process LookML parameter to define PDTs.

Feature support

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

In Looker 22.8, Google Cloud SQL supports the following Looker features:

Next steps

After you have created your database connection, set authentication options.