Set up Google Cloud Platform Postgres as a source in Airbyte about write-for-the-community

[RoseateSpoonbill]

I ended up not being able to figure out how to do this locally.

⚠️ THIS DOES NOT WORK ⚠️

This was as far as I got but I couldn't figure out either the right host name or what I was doing wrong in the addition to docker-compose.yaml

1. In your airbyte repository, open your docker-compose.yaml file and add this at the bottom of the services top level section

     proxy:
       container_name: cloud-sql-proxy
       image: gcr.io/cloudsql-docker/gce-proxy:1.30.0
       volumes:
         - ..\{{FULL_PATH_TO_SERVICE_ACCOUNT_JSON_FILE}}:/config
       ports:
         - 127.0.0.1:5436:5436 
       command: "/cloud_sql_proxy -instances={{INSTANCE_CONNECTION_NAME}}=tcp:5436 -credential_file=/config/{{SERVICE_ACCOUNT_JSON_FILE_NAME}}"
   

2. Follow the instructions in the Start Airbyte section above
3. Once Airbyte loads, in the lefthand menu click Sources
4. Click + add new source
   1. Choose Postgres from the dropdown menu
   2. Host: ❓
   3. Port: 5436
   4. Fill in other fields
   5. Replication Method: Standard
   6. SSH Tunnel Method: No Tunnel
   7. Click Set up source

---

⚠️ This also did not work ⚠️
Run the Cloud SQL Auth proxy in a Docker container (per https://cloud.google.com/sql/docs/postgres/connect-admin-proxy#connecting-docker) as I couldn't figure out

1. Which Airbyte Docker container needed to connect to the Proxy Docker container
2. How to connect them

[RoseateSpoonbill]

I did get the combo of GCP Compute Engine and Cloud SQL Auth Proxy working and have submitted a PR to update https://docs.airbyte.com/deploying-airbyte/on-gcp-compute-engine for that use case: airbytehq/airbyte#12086