Google Cloud SQL
Source and destination
Polytomic can connect to Google Cloud SQL databases using 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.
-
In Polytomic, go to Connections → Add Connection → Google Cloud SQL.
-
Enter your credentials.
-
Upload your JSON key file from step 3 in Polytomic's 'Service Account Key' field.

- Click Save.
If you'd like to authenticate using IAM rather than a password, you can 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.
CDC replication from Google Cloud SQL (PostgreSQL)
If you'd like to stream changes from your PostgreSQL Cloud SQL instances into a data warehouse, see the CDC replication section in our PostgreSQL documentation.
Updated 10 months ago