Best Practice for Managing BigQuery Resources with Terraform: Dataset vs. Dataset and Tables

[Nikita_G]

I’m working on managing Google BigQuery resources using Terraform and am trying to determine the best practice for defining these resources. Specifically, I’m considering whether it’s better to:

1. Create only BigQuery datasets using Terraform.
2. Create both BigQuery datasets and tables using Terraform.

I understand that defining both datasets and tables in Terraform can offer benefits such as consistency, manageability, but whenever when we need to multiple tables that are frequently created or deleted in that case  i think is it difficult to manage   However, I would like to get insights from the community on the following points.

Are there any additional best practices or considerations I should keep in mind when defining BigQuery datasets and tables with Terraform?

[jaia · Accepted solution]

Hello,

Thank you for contacting Google Cloud Community!

Ensure that your Terraform configurations adhere to appropriate security best practices, such as using IAM roles and policies to control access to BigQuery resources.

Regards,
Jai Ade

[jaia · Accepted solution]

Hello,

Thank you for contacting Google Cloud Community!

Ensure that your Terraform configurations adhere to appropriate security best practices, such as using IAM roles and policies to control access to BigQuery resources.

Regards,
Jai Ade

[jaia · Accepted solution]

Hello,

Thank you for your engagement regarding this issue. We haven’t heard back from you regarding this issue for sometime now. Hence, I'm going to close this issue which will no longer be monitored. However, if you have any new issues, Please don’t hesitate to create a new issue. We will be happy to assist you on the same.

Regards,
Jai Ade