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.