Manage GCP BigQuery IAM Access

The gcp:bigquery/iamMember:IamMember resource, part of the Pulumi GCP provider, grants IAM roles to members for BigQuery tables without affecting other members of the same role. This guide focuses on three capabilities: single-member role grants, multi-member role management, and complete policy replacement.

BigQuery IAM resources reference existing tables by project, dataset, and table ID. The examples are intentionally small. Combine them with your own BigQuery tables and identity management.

Grant a role to a single member

Most IAM configurations add a specific role to one user or service account without affecting others who already have that role.

import * as pulumi from "@pulumi/pulumi";
import * as gcp from "@pulumi/gcp";

const member = new gcp.bigquery.IamMember("member", {
    project: test.project,
    datasetId: test.datasetId,
    tableId: test.tableId,
    role: "roles/bigquery.dataOwner",
    member: "user:jane@example.com",
});

import pulumi
import pulumi_gcp as gcp

member = gcp.bigquery.IamMember("member",
    project=test["project"],
    dataset_id=test["datasetId"],
    table_id=test["tableId"],
    role="roles/bigquery.dataOwner",
    member="user:jane@example.com")

package main

import (
	"github.com/pulumi/pulumi-gcp/sdk/v9/go/gcp/bigquery"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := bigquery.NewIamMember(ctx, "member", &bigquery.IamMemberArgs{
			Project:   pulumi.Any(test.Project),
			DatasetId: pulumi.Any(test.DatasetId),
			TableId:   pulumi.Any(test.TableId),
			Role:      pulumi.String("roles/bigquery.dataOwner"),
			Member:    pulumi.String("user:jane@example.com"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Gcp = Pulumi.Gcp;

return await Deployment.RunAsync(() => 
{
    var member = new Gcp.BigQuery.IamMember("member", new()
    {
        Project = test.Project,
        DatasetId = test.DatasetId,
        TableId = test.TableId,
        Role = "roles/bigquery.dataOwner",
        Member = "user:jane@example.com",
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.bigquery.IamMember;
import com.pulumi.gcp.bigquery.IamMemberArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var member = new IamMember("member", IamMemberArgs.builder()
            .project(test.project())
            .datasetId(test.datasetId())
            .tableId(test.tableId())
            .role("roles/bigquery.dataOwner")
            .member("user:jane@example.com")
            .build());

    }
}

resources:
  member:
    type: gcp:bigquery:IamMember
    properties:
      project: ${test.project}
      datasetId: ${test.datasetId}
      tableId: ${test.tableId}
      role: roles/bigquery.dataOwner
      member: user:jane@example.com

The member property specifies the identity receiving access (format: “user:email”, “serviceAccount:email”, “group:email”). The role property defines the permission level. IamMember is non-authoritative: it adds this member to the role without removing other members who already have it.

Grant a role to multiple members at once

When multiple users or service accounts need the same role, IamBinding manages all members for that role together.

import * as pulumi from "@pulumi/pulumi";
import * as gcp from "@pulumi/gcp";

const binding = new gcp.bigquery.IamBinding("binding", {
    project: test.project,
    datasetId: test.datasetId,
    tableId: test.tableId,
    role: "roles/bigquery.dataOwner",
    members: ["user:jane@example.com"],
});

import pulumi
import pulumi_gcp as gcp

binding = gcp.bigquery.IamBinding("binding",
    project=test["project"],
    dataset_id=test["datasetId"],
    table_id=test["tableId"],
    role="roles/bigquery.dataOwner",
    members=["user:jane@example.com"])

package main

import (
	"github.com/pulumi/pulumi-gcp/sdk/v9/go/gcp/bigquery"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := bigquery.NewIamBinding(ctx, "binding", &bigquery.IamBindingArgs{
			Project:   pulumi.Any(test.Project),
			DatasetId: pulumi.Any(test.DatasetId),
			TableId:   pulumi.Any(test.TableId),
			Role:      pulumi.String("roles/bigquery.dataOwner"),
			Members: pulumi.StringArray{
				pulumi.String("user:jane@example.com"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Gcp = Pulumi.Gcp;

return await Deployment.RunAsync(() => 
{
    var binding = new Gcp.BigQuery.IamBinding("binding", new()
    {
        Project = test.Project,
        DatasetId = test.DatasetId,
        TableId = test.TableId,
        Role = "roles/bigquery.dataOwner",
        Members = new[]
        {
            "user:jane@example.com",
        },
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.bigquery.IamBinding;
import com.pulumi.gcp.bigquery.IamBindingArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var binding = new IamBinding("binding", IamBindingArgs.builder()
            .project(test.project())
            .datasetId(test.datasetId())
            .tableId(test.tableId())
            .role("roles/bigquery.dataOwner")
            .members("user:jane@example.com")
            .build());

    }
}

resources:
  binding:
    type: gcp:bigquery:IamBinding
    properties:
      project: ${test.project}
      datasetId: ${test.datasetId}
      tableId: ${test.tableId}
      role: roles/bigquery.dataOwner
      members:
        - user:jane@example.com

The members property lists all identities that should have this role. IamBinding is authoritative for the specified role: it replaces any existing members with this list. Other roles on the table remain unchanged. Use IamBinding when you want to manage all members for a role as a single unit.

Replace the entire IAM policy for a table

Some deployments require complete control over all IAM bindings, replacing any existing policy.

import * as pulumi from "@pulumi/pulumi";
import * as gcp from "@pulumi/gcp";

const admin = gcp.organizations.getIAMPolicy({
    bindings: [{
        role: "roles/bigquery.dataOwner",
        members: ["user:jane@example.com"],
    }],
});
const policy = new gcp.bigquery.IamPolicy("policy", {
    project: test.project,
    datasetId: test.datasetId,
    tableId: test.tableId,
    policyData: admin.then(admin => admin.policyData),
});

import pulumi
import pulumi_gcp as gcp

admin = gcp.organizations.get_iam_policy(bindings=[{
    "role": "roles/bigquery.dataOwner",
    "members": ["user:jane@example.com"],
}])
policy = gcp.bigquery.IamPolicy("policy",
    project=test["project"],
    dataset_id=test["datasetId"],
    table_id=test["tableId"],
    policy_data=admin.policy_data)

package main

import (
	"github.com/pulumi/pulumi-gcp/sdk/v9/go/gcp/bigquery"
	"github.com/pulumi/pulumi-gcp/sdk/v9/go/gcp/organizations"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		admin, err := organizations.LookupIAMPolicy(ctx, &organizations.LookupIAMPolicyArgs{
			Bindings: []organizations.GetIAMPolicyBinding{
				{
					Role: "roles/bigquery.dataOwner",
					Members: []string{
						"user:jane@example.com",
					},
				},
			},
		}, nil)
		if err != nil {
			return err
		}
		_, err = bigquery.NewIamPolicy(ctx, "policy", &bigquery.IamPolicyArgs{
			Project:    pulumi.Any(test.Project),
			DatasetId:  pulumi.Any(test.DatasetId),
			TableId:    pulumi.Any(test.TableId),
			PolicyData: pulumi.String(admin.PolicyData),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Gcp = Pulumi.Gcp;

return await Deployment.RunAsync(() => 
{
    var admin = Gcp.Organizations.GetIAMPolicy.Invoke(new()
    {
        Bindings = new[]
        {
            new Gcp.Organizations.Inputs.GetIAMPolicyBindingInputArgs
            {
                Role = "roles/bigquery.dataOwner",
                Members = new[]
                {
                    "user:jane@example.com",
                },
            },
        },
    });

    var policy = new Gcp.BigQuery.IamPolicy("policy", new()
    {
        Project = test.Project,
        DatasetId = test.DatasetId,
        TableId = test.TableId,
        PolicyData = admin.Apply(getIAMPolicyResult => getIAMPolicyResult.PolicyData),
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.organizations.OrganizationsFunctions;
import com.pulumi.gcp.organizations.inputs.GetIAMPolicyArgs;
import com.pulumi.gcp.bigquery.IamPolicy;
import com.pulumi.gcp.bigquery.IamPolicyArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var admin = OrganizationsFunctions.getIAMPolicy(GetIAMPolicyArgs.builder()
            .bindings(GetIAMPolicyBindingArgs.builder()
                .role("roles/bigquery.dataOwner")
                .members("user:jane@example.com")
                .build())
            .build());

        var policy = new IamPolicy("policy", IamPolicyArgs.builder()
            .project(test.project())
            .datasetId(test.datasetId())
            .tableId(test.tableId())
            .policyData(admin.policyData())
            .build());

    }
}

resources:
  policy:
    type: gcp:bigquery:IamPolicy
    properties:
      project: ${test.project}
      datasetId: ${test.datasetId}
      tableId: ${test.tableId}
      policyData: ${admin.policyData}
variables:
  admin:
    fn::invoke:
      function: gcp:organizations:getIAMPolicy
      arguments:
        bindings:
          - role: roles/bigquery.dataOwner
            members:
              - user:jane@example.com

The policyData property comes from getIAMPolicy, which defines all role bindings in a single policy document. IamPolicy is fully authoritative: it removes any bindings not explicitly defined. This resource cannot coexist with IamMember or IamBinding on the same table, as they will conflict over policy ownership.

Beyond these examples

These snippets focus on specific IAM management patterns: single-member grants (IamMember), multi-member role management (IamBinding), and complete policy replacement (IamPolicy). They’re intentionally minimal rather than full access control systems.

The examples reference pre-existing infrastructure such as BigQuery tables (dataset and table IDs) and a GCP project with BigQuery API enabled. They focus on granting access rather than provisioning tables or managing identities.

To keep things focused, common IAM patterns are omitted, including:

Conditional IAM bindings (condition property)
Custom role definitions
Service account creation and management
Dataset-level IAM (separate from table-level)

These omissions are intentional: the goal is to illustrate how each IAM resource type works, not provide drop-in access control modules. See the BigQuery IamMember resource reference for all available configuration options.

Let's manage GCP BigQuery IAM Access

Get started with Pulumi Cloud, then follow our quick setup guide to deploy this infrastructure.

Try Pulumi Cloud for FREE

Frequently Asked Questions

Resource Selection & Conflicts

What's the difference between IamPolicy, IamBinding, and IamMember?

gcp.bigquery.IamPolicy is authoritative and replaces the entire IAM policy. gcp.bigquery.IamBinding is authoritative for a specific role, managing all members for that role. gcp.bigquery.IamMember is non-authoritative, adding a single member to a role without affecting other members.

Can I use IamPolicy with IamBinding or IamMember?

No, gcp.bigquery.IamPolicy cannot be used with gcp.bigquery.IamBinding or gcp.bigquery.IamMember because they’ll conflict over the policy configuration.

Can I use IamBinding and IamMember together?

Yes, but only if they don’t grant privileges to the same role. If they target the same role, they’ll conflict.

When should I use IamMember vs IamBinding?

Use gcp.bigquery.IamMember to add individual members without affecting existing members. Use gcp.bigquery.IamBinding when you want to manage all members for a role authoritatively.

Configuration & Identity Formats

What identity formats can I use in the member field?

The member field supports: allUsers, allAuthenticatedUsers, user:{email}, serviceAccount:{email}, group:{email}, domain:{domain}, projectOwner:projectid, projectEditor:projectid, projectViewer:projectid, and federated identities like principal://iam.googleapis.com/....

What format do custom roles require?

Custom roles must use the format [projects|organizations]/{parent-name}/roles/{role-name}, for example projects/my-project/roles/my-custom-role.

How do I grant a single user access to a BigQuery table?

Use gcp.bigquery.IamMember with the member field set to user:{email} and specify the desired role, datasetId, and tableId.

Immutability & Lifecycle

What properties can't be changed after creating an IamMember?

All key properties are immutable: datasetId, tableId, project, role, member, and condition. Changing any of these requires recreating the resource.

Using a different cloud?

Explore security guides for other cloud providers:

AWS Guides Azure Guides