example reverse proxy VM for datastream

gistfile1.txt

# Proxy VM
resource "google_compute_instance" "reverse-proxy" {
  project      = var.project # app-ref project
  name         = "reverse-proxy"
  machine_type = "e2-medium"
  zone = "asia-southeast1-b"

  boot_disk {
    initialize_params {
      image = "debian-cloud/debian-11"
    }
  }

  network_interface {
    network    = data.google_compute_network.network.name # shared network name
    subnetwork = data.google_compute_subnetwork.subnetwork.id # subnetwork name

  }

  metadata_startup_script = <<EOT
#!/bin/sh
apt-get update
curl -o cloud-sql-proxy https://storage.googleapis.com/cloud-sql-connectors/cloud-sql-proxy/v2.9.0/cloud-sql-proxy.linux.amd64
chmod +x cloud-sql-proxy
./cloud-sql-proxy --private-ip ${google_sql_database_instance.instance.connection_name} --address 0.0.0.0 --port 5432
  EOT

  service_account {
    scopes = ["cloud-platform"]
  }
}