Trying to find the `recommended dns` data for GCP Cloud SQL instance
23:16 03 Jun 2024

I'm working through the documentation for connecting to a private Cloud SQL instance. I created the instance with a private IP (no public access), set up cloud sql proxy on my local, and am able to connect to the network successfully. However, I see in the docs that the console does not automatically add the required private dns records to go from the proxy to the db instance.

When I run this with my sql instance, I do not see the mentioned recommended dns record in the result like the documentation claims exists.

gcloud sql instances describe INSTANCE_NAME \
--project=PROJECT_ID

I do get all the other configuration data, but nothing that matches the suggested dns format: INSTANCE_UID.PROJECT_DNS_LABEL.REGION_NAME.sql.goog.

My instance is a second gen, so I don't know if that has something to do with it. I'd like to get this working via the console before I seek to automate it with Terraform, e.g. I plan on automating this later, but that is not my current goal.

google-cloud-platform google-cloud-sql cloud-sql-proxy