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:
Connect the Database
In the Admin section of Looker, navigate to the Connections page and click New Connection. Looker displays this page:
Fill in the following fields:
- Dialect: Select Google Cloud SQL.
- Host: The database hostname used to connect to the Google Cloud SQL database (set it to “localhost” if you are using an SSH tunnel).
- Port: The port used to connect to the Google Cloud SQL database.
- Database: The name of the Google Cloud SQL database instance.
- Username: The username of the account Looker will use to log into Google Cloud SQL.
- Password: The password of the account Looker will use to log into Google Cloud SQL.
- SSL: SSL connections to Google Cloud SQL are not supported; leave this box unchecked.
Google Cloud SQL does not support
CREATE TABLE AS SELECT statements, so you must use the
create_process LookML parameter to define PDTs.
Looker’s ability to provide some features depends on whether the database dialect can support them.
In the current Looker release, Google Cloud SQL supports the following Looker features:
Once you are finished creating your database connection, you can proceed to setting authentication options.