sql_database_instance doesn't have implicit dependency with private vpc connection when using private service access

[kenzht]

when using private service access, resource google_sql_database_instance doesn't implicitly depend on private_vpc_connection and hence, requires explicitly defining depends on relationship with private_vpc_connection.

resource "google_sql_database_instance" "foobar" {
  depends_on = ["google_service_networking_connection.private_vpc_connection"]

[emilymye]

Unfortunately, this is true and pretty much unavoidable since we can't actually reference the networking connection in the SQL instance. As you can see in our example for private ip instances we use a depends_on block.

We certainly can improve the documentation around it but as of now we aren't able to do much else.

[ghost]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 hashibot-feedback@hashicorp.com. Thanks!