Feature request: New resource type, BigQuery routines

[jamiekt]

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

On 2019-10-03 the BigQuery service gained the ability to use stored procedures and UDFs, see the release notes here: https://cloud.google.com/bigquery/docs/release-notes#October_03_2019

The routines resource on the BigQuery API supports management of stored procedures and UDFs: https://cloud.google.com/bigquery/docs/reference/rest/v2/routines

This issue is to request support in the Terraform GCP Provider for creating, modifying & destroying BigQuery stored procedures and UDFs.

New or Affected Resource(s)

• google_bigquery_routine

Potential Terraform Configuration

resource "google_bigquery_routine" "sproc" {
  project_id  = "myproject"
  dataset_id = "${google_bigquery_dataset.default.dataset_id}"
  routine_id     = "mysproc"
  routine_type = "PROCEDURE"
  language = "SQL"
  definition_body = "CREATE PROCEDURE ${google_bigquery_dataset.default.dataset_id}.mysproc () BEGIN SET x = x + delta; END"
  # see full list of attributes [here](https://cloud.google.com/bigquery/docs/reference/rest/v2/routines)
}

resource "google_bigquery_routine" "udf" {
  project_id  = "myproject"
  dataset_id = "${google_bigquery_dataset.default.dataset_id}"
  routine_id     = "myudf"
  routine_type = "SCALAR_FUNCTION"
  language = "SQL"
  definition_body = "${data.template.function_body}"
  # see full list of attributes [here](https://cloud.google.com/bigquery/docs/reference/rest/v2/routines)
}

[kurtmaile]

Yes yes please!

[kurtmaile]

Saved queries as well, not sure why they havent been added since they have been around for ages - or maybe I missed this?

The new scripts, stored procs, UDFs are really important to add, albeit beta, wont belong before GA I imagine. Many thanks!

[ghost]

I'd like to pick this up if no one's already working on it. :)

[paddycarver]

This appears to be a duplicate of #4493.

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