Google Cloud SQL

Polytomic can connect to Google Cloud SQL databases using a service account key:

1. Go to https://console.cloud.google.com/apis/credentials/serviceaccountkey to create a new service account.

2. Select the Cloud SQL Client role:

3. Create and save a JSON service account key file.

4. In Polytomic, go to Connections → Add Connection → Google Cloud SQL.

5. Enter your credentials.

6. Upload your JSON key file from step 3 in Polytomic's 'Service Account Key' field.

7. 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.