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