Add Big lake in the google_bigquery_connection

[lucienfregosibodyguard]

Description

It would be nice to add the new biglake feature when creating a big query connection
https://registry.terraform.io/providers/hashicorp/google/latest/docs/resources/bigquery_connection
It's actually available through the UI.

New or Affected Resource(s)

• google_bigquery_connection

Potential Terraform Configuration

resource "google_bigquery_connection" "connection" {
    provider      = google-beta
    friendly_name = "👋"
    description   = "a riveting description"
    big_lake {
      connection_id = "my_connection_id"
      data_location = "eu"
    }
}

[gutschenritter]

I believe this was resolved in #GoogleCloudPlatform/magic-modules/pull/6020

[rileykarson]

That seemed to add serviceAccountId, but no other kind of cloud resource(s)

[gutschenritter]

A cloud_resource connection type only has one field, an output only field serviceAccountId. Cloud resource connection types can be created after pr 6020.

[julio-vaz]

Hello, any update on this?

[julio-vaz]

Hello again guys, this should be working already since 4.25.0 or I misunderstood it?

Thanks in advance!

[psvaiter]

BigLake table is a Cloud Resource, so you are able to create a connection with an empty cloud_resource block and use that in your google_bigquery_table resource.

(confirmed with v4.33.0)

[rileykarson]

Closing, seems the service has documentation confirming that's the case. With a Terraform config, too!

https://cloud.google.com/bigquery/docs/biglake-quickstart#terraform

[github-actions]

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 have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.