Users and Security

First, create a database user that you will use to 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'd like Looker to be able to query:

Feature Support

Looker’s ability to provide some features depends on the database dialect’s ability to support that functionality. In the current Looker release, Google Cloud SQL supports the following Looker features:

Since Google Cloud SQL now only supports GTID replication, Looker no longer supports PDTs on this dialect. You can still create non-persistent derived tables. I have updated the article and the screenshot to show this.

Yes, the comment above is still true for Google Cloud SQL. Looker does not support PDTs.

To elaborate a little more as to why we don't support PDTs here it is because "CREATE table AS SELECT" is not supported by Google Cloud SQL, when/if this feature becomes available from Google Cloud SQL we would be able to offer support for PDTs.