Search
Clear search
Close search
Google apps
Main menu
true

Google Cloud SQL connector

Connect Data Studio to Google Cloud SQL databases.

Google Cloud SQL is a fully-managed database service that makes it easy to set-up, maintain, manage and administer your relational MySQL databases on Google Cloud Platform. The Google Cloud SQL connector allows you to access data from Google Cloud SQL databases within Data Studio.

How to connect to Google Cloud SQL

You must have at least cloudsql.client permission in the Cloud SQL project to create the connection. If you don't have this access, you can use the MySQL connector instead.

A Data Studio data source can connect to a single Google Cloud SQL database table. First, select the Google Cloud SQL connector. Next, configure access to your database, using one of these options:

BASIC

To connect using an Instance Connection Name:

  1. Provide the following connection information:
    1. Instance Connection Name
    2. Database
    3. Username
    4. Password
  2. Click AUTHENTICATE
    1. You will see a list of tables in that database
  3. Select a table
  4. Click CONNECT.

Data Studio will then create a data source using all of the columns in the table as fields.

JDBC URL

To connect using a JDBC URL:

  1. Provide the following connection information:
    1. JDBC URL.
      1. Example: jdbc:google:mysql://<Instance>/<Database>
    2. Username
    3. Password
  2. Click AUTHENTICATE
    1. You will see a list of tables in that database
  3. Select a table
  4. Click CONNECT.

Data Studio will then create a data source using all of the columns in the table as fields.

Custom Query

Select the CUSTOM QUERY option to provide a SQL query instead of connecting to a single table. Data Studio uses this custom SQL as an inner select statement for each generated query to the database.

Special data types

Data Studio will map your table’s column data types to a unified set of Data Studio types. Some database types are currently not supported in Data Studio. When Data Studio encounters a column of a non-supported type, it will not create a field for that column.

Unsupported database types

Data Studio does not support MySQL's Spatial Data Extensions

Older version migrated to MySQL connector

August 2017: Data sources created using the previous version of the connector have been migrated to the MySQL connector.

The older version of the Cloud SQL connector required you to whitelist a number of IP addresses, and did not provide encrypted connections. The current version of the connector no longer requires whitelisting, and it provides encryption; however, to use these features, you must create a new data source using the Google Cloud SQL connector.

Was this article helpful?
How can we improve it?
false
What's new in Data Studio

Learn about new features and recent changes.