Connect To GCP Databases Using the Cloud SQL Auth Proxy

Configure your Database

Using the Cloud SQL Auth Proxy, you can grant Etleap access to your Postgres and MySQL GCP instances.

For Postgres GCP Instances: Follow the Google Cloud Postgres Instance instructions when configuring the source for logical replication.

For MySQL GCP Instances: Follow the Google Cloud MySQL Databases instructions when configuring the binglog.

Setup Cloud SQL Auth Proxy

Complete the following to connect via the Cloud SQL Auth Proxy:

• Enable the sqladmin API (prod) API
• Create a service account with either the Cloud SQL - Client role attached, or the cloudsql.instances.connect and cloudsql.instances.get permissions attached

Once you have created the service account, share the following with Etleap:

• Securely share the service account key in JSON format
• Share the database “connection name”

Follow the steps to create a connection in Etleap:

• Click the Connections tab at the top of the Etleap home page
• Click the blue + New Connection button at the top right
• Select the New Connection’s icon (e.g., Postgres)
• Enter the desired name for the connection
• Follow the prompts on the screen to authorize Etleap with access
• Click Create Connection