Google Cloud SQL

Source and destination

📘
Whitelist IPs
If your database network-access policy requires whitelisting our IPs first, you can find them here: https://docs.polytomic.com/docs/whitelist-ips.

Polytomic connects to Google Cloud SQL databases using a Google Cloud service account key. Both database engines are supported:

Both connection types use the same service account key. Create it once using the steps below, then follow the guide for your engine to add the connection.

Create a service account key

Go to https://console.cloud.google.com/apis/credentials/serviceaccountkey to create a new service account.
Select the Cloud SQL Client role:

Create and save a JSON service account key file.

You'll upload this key file when you add your connection in Polytomic.

Authenticate with IAM

If you'd like to authenticate using IAM rather than a password, add an IAM principal to your database (see https://cloud.google.com/sql/docs/postgres/authentication) and incorporate that in your JSON service account key file. When you authenticate with IAM, you can leave the connection's Password field empty.

Find your connection name

Each connection asks for a Cloud SQL connection name in the form project:region:instance. You'll find this value on your instance's Overview page in the Cloud SQL console, listed as Connection name.

Updated 18 days ago