Allowing ETL access to Google Cloud SQL for MySQL databases ETL can read data from your Google Cloud SQL for MySQL databases or write data to them. This article discusses providing ETL access on your Google Cloud SQL for MySQL database and then details creating the database connection in ETL.

You must provide ETL access to your Google Cloud SQL for MySQL database. If it is behind a firewall:

  • Create a user and grant it minimum permissions required for ETL to read or write data from the database.
  • Allow access from ETL's IP addresses to your database port (Refer to this article if you'd prefer to create an SSH tunnel or reverse SSH tunnel.)

To create a Google Cloud SQL for MySQL database connection in ETL:

  1. Click the Connections icon (lightning bolt) on the top left menu.
  2. To create a connection, click New connection. thumbnail image
  3. Choose Google Cloud SQL for MySQL and name the connection.
  4. Select your access type (direct connection if you've whitelisted ETL's IP addresses.)
  5. Enter your database host name.
  6. Enter the database name.
  7. Enter the user name
  8. Enter the user's password.
  9. Click Test Connection to make sure the connection details are correct.
  10. Click Create connection to create the connection.

thumbnail image

Note: If you'd like to keep an internet connection secure and safeguard any sensitive data that is being sent between Google Cloud and ETL, we recommend setting up a Reverse SSH Tunnel. Currently, ETL does not support connecting via SSL to Google Cloud SQL Databases.