IP address reference attribute for psc_auto_connections not documented

[Rei-Suzuki1729]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request.
• Please do not leave +1 or me too comments, they generate extra noise for issue followers and do not help prioritize the request.
• If you are interested in working on this issue or have submitted a pull request, please leave a comment.
• If an issue is assigned to a user, that user is claiming responsibility for the issue.
• Customers working with a Google Technical Account Manager or Customer Engineer can ask them to reach out internally to expedite investigation and resolution of this issue.

Description

In Terraform Provider for Google v6.12.0, the psc_auto_connections field was added to the google_sql_database_instance resource (#20307).However, there is no attribute listed in the official documentation that references the IP address associated with Private Service Connect (PSC) endpoints created using this field.

Currently, you need to use the Google Cloud Console or CLI to reference the IP address, which cannot be referenced directly within Terraform.

As an expected behaviour, we would like to see an attribute added that can refer to the IP address of PSC endpoints created by psc_auto_connections and clearly stated in the documentation.

New or Affected Resource(s)

• google_sql_database_instance

Potential Terraform Configuration

resource "google_sql_database_instance" "main" {
  name             = "psc-enabled-main-instance"
  database_version = "MYSQL_8_0"
  settings {
    tier = "db-f1-micro"
    ip_configuration {
      psc_config {
        psc_enabled                = true
        allowed_consumer_projects  = ["allowed-consumer-project-name"]
        psc_auto_connections {
          consumer_network           = "network-name"
          consumer_service_project_id = "project-id"
        }
      }
      ipv4_enabled = false
    }
    backup_configuration {
      enabled             = true
      binary_log_enabled  = true
    }
    availability_type = "REGIONAL"
  }
}

output "psc_endpoint_ip" {
  value = google_sql_database_instance.main.pscAuto_endpoint_ip
}

References

#20307
Terraform Provider for Google v6.12.0 Release Notes
Google Cloud SQL documentation: getting a Private Service Connect endpoint
Terraform Registry: google_sql_database_instance resource attribute reference

b/383122736