Google Cloud SQL

📘

Whitelist IPs

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

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.

Database permissions

See the following sections for database permissions to set for Polytomic operations, depending on your Google Cloud SQL database type (MySQL vs PostgreSQL):

• MySQL permissions
• PostgreSQL permissions

Incremental replication from Google Cloud SQL

If you would like fast incremental syncing from your Google Cloud SQL database to data warehouses and other storage systems, see Incremental syncing from databases.