Google BigQuery Table IAM

This page shows how to write Terraform for BigQuery Table IAM and write them securely.

google_bigquery_table_iam (Terraform)

The Table IAM in BigQuery can be configured in Terraform with the resource name google_bigquery_table_iam. The following sections describe how to use the resource and its parameters.

Example Usage from GitHub

An example could not be found in GitHub.


The following arguments are supported:

  • project - (Optional) The ID of the project in which the resource belongs. If it is not provided, the project will be parsed from the identifier of the parent resource. If no project is provided in the parent identifier and no project is specified, the provider project is used.

  • member/members - (Required) Identities that will be granted the privilege in role. Each entry can have one of the following values:

    • allUsers: A special identifier that represents anyone who is on the internet; with or without a Google account.
    • allAuthenticatedUsers: A special identifier that represents anyone who is authenticated with a Google account or a service account.
    • user:[emailid]: An email address that represents a specific Google account. For example, or
    • serviceAccount:[emailid]: An email address that represents a service account. For example,
    • group:[emailid]: An email address that represents a Google group. For example,
    • domain:[domain]: A G Suite domain (primary, instead of alias) name that represents all the users of that domain. For example, or
    • projectOwner:projectid: Owners of the given project. For example, "projectOwner:my-example-project"
    • projectEditor:projectid: Editors of the given project. For example, "projectEditor:my-example-project"
    • projectViewer:projectid: Viewers of the given project. For example, "projectViewer:my-example-project"
  • role - (Required) The role that should be applied. Only one google_bigquery_table_iam_binding can be used per role. Note that custom roles must be of the format [projects|organizations]/[parent-name]/roles/[role-name].

  • policy_data - (Required only by google_bigquery_table_iam_policy) The policy data generated by a google_iam_policy data source.

  • condition - (Optional, Beta) An IAM Condition for a given binding. Structure is documented below.

The condition block supports:

  • expression - (Required) Textual representation of an expression in Common Expression Language syntax.

  • title - (Required) A title for the expression, i.e. a short string describing its purpose.

  • description - (Optional) An optional description of the expression. This is a longer text which describes the expression, e.g. when hovered over it in a UI.

Warning: Terraform considers the role and condition contents (title+description+expression) as the identifier for the binding. This means that if any part of the condition is changed out-of-band, Terraform will consider it to be an entirely different resource and will treat it as such.

In addition to the arguments listed above, the following computed attributes are exported:

  • etag - (Computed) The etag of the IAM policy.

Explanation in Terraform Registry

Three different resources help you manage your IAM policy for BigQuery Table. Each of these resources serves a different use case:

  • google_bigquery_table_iam_policy: Authoritative. Sets the IAM policy for the table and replaces any existing policy already attached.
  • google_bigquery_table_iam_binding: Authoritative for a given role. Updates the IAM policy to grant a role to a list of members. Other roles within the IAM policy for the table are preserved.
  • google_bigquery_table_iam_member: Non-authoritative. Updates the IAM policy to grant a role to a new member. Other members for the role for the table are preserved.

    Note: google_bigquery_table_iam_policy cannot be used in conjunction with google_bigquery_table_iam_binding and google_bigquery_table_iam_member or they will fight over what your policy should be.

    Note: google_bigquery_table_iam_binding resources can be used in conjunction with google_bigquery_table_iam_member resources only if they do not grant privilege to the same role.

    Note: This resource supports IAM Conditions (beta) but they have some known limitations which can be found here. Please review this article if you are having issues with IAM Conditions.

Frequently asked questions

What is Google BigQuery Table IAM?

Google BigQuery Table IAM is a resource for BigQuery of Google Cloud Platform. Settings can be wrote in Terraform.


Scan your IaC problem in 3 minutes for free

You can keep your IaC security for free. No credit card required.