home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
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 21.6, Google Cloud SQL supports the following Looker features:

Next steps

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

Top