BigQuery external tables should be able to be defined using HivePartitioningOptions

[preston-hf]

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

Hive partitioning on external tables is now supported (in beta) and it would be awesome if Terraform supported creating tables that use it.

New or Affected Resource(s)

• google_bigquery_table

Potential Terraform Configuration

resource "google_bigquery_table" "hive" {
  dataset_id = google_bigquery_dataset.default.dataset_id
  table_id   = "hive"

  external_data_configuration {
    autodetect    = true
    
    hive_partition_options {
      mode = "AUTO"
      source_uri_prefix = "gs://mybucket/foo"

      requirePartitionFilter = false
    }
  }
}

References

[preston-hf]

Is this something that Google is working on internally, or would you accept a pull request for it?

[preston-hf]

This is now GA. Is this something you'd accept a contribution for? Need this ASAP :)

[danawillow]

Always happy to look at PRs! Take a look at our contributing guide at https://github.com/terraform-providers/terraform-provider-google/blob/master/.github/CONTRIBUTING.md

[matteosdocsity]

are there any updates? is there a way to start using it?

[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 👉 [email protected]. Thanks!