Support BigQuery external connection for Spanner in google_bigquery_connection

[yu-iskw]

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 the issue is assigned to the "modular-magician" user, it is either in the process of being autogenerated, or is planned to be autogenerated soon. If the issue is assigned to a user, that user is claiming responsibility for the issue. If the issue is assigned to "hashibot", a community member has claimed the issue already.

Description

As we can create BigQuery external connections with Cloud SQL for federated query, we should support that with Cloud Spanner as well.

New or Affected Resource(s)

• google_bigquery_connection

Potential Terraform Configuration

resource "google_bigquery_connection" "connection" {
  provider      = google-beta
  connection_id = "connection_to_spanner"
  location      = "US"
  description   = "A BigQuery external connection for Cloud Spanner"
  spanner {
    instance_id     = google_spanner_instance.instance.name
    database        = google_spanner_database.database.name
    type            = "SPANNER"
    use_parallelism = true
  }
}

References

• https://cloud.google.com/bigquery/docs/reference/bigqueryconnection/rest

[husseyd]

Yes please! Currently only supporting Cloud SQL :(

[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.