Docs Home
Google Cloud v8.26.0 published on Thursday, Apr 10, 2025 by Pulumi
gcp.bigquery.DatasetAccess
Explore with Pulumi AI
- Example Usage
- Bigquery Dataset Access Basic User
- Bigquery Dataset Access View
- Bigquery Dataset Access Authorized Dataset
- Bigquery Dataset Access Authorized Routine
- Create DatasetAccess Resource
- Constructor syntax
- Constructor example
- DatasetAccess Resource Properties
- Inputs
- Outputs
- Look up Existing DatasetAccess Resource
- Supporting Types
- Import
- Package Details
Example Usage
Bigquery Dataset Access Basic User
import * as pulumi from "@pulumi/pulumi";
import * as gcp from "@pulumi/gcp";
const dataset = new gcp.bigquery.Dataset("dataset", {datasetId: "example_dataset"});
const bqowner = new gcp.serviceaccount.Account("bqowner", {accountId: "bqowner"});
const access = new gcp.bigquery.DatasetAccess("access", {
datasetId: dataset.datasetId,
role: "OWNER",
userByEmail: bqowner.email,
});
import pulumi
import pulumi_gcp as gcp
dataset = gcp.bigquery.Dataset("dataset", dataset_id="example_dataset")
bqowner = gcp.serviceaccount.Account("bqowner", account_id="bqowner")
access = gcp.bigquery.DatasetAccess("access",
dataset_id=dataset.dataset_id,
role="OWNER",
user_by_email=bqowner.email)
package main
import (
"github.com/pulumi/pulumi-gcp/sdk/v8/go/gcp/bigquery"
"github.com/pulumi/pulumi-gcp/sdk/v8/go/gcp/serviceaccount"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
dataset, err := bigquery.NewDataset(ctx, "dataset", &bigquery.DatasetArgs{
DatasetId: pulumi.String("example_dataset"),
})
if err != nil {
return err
}
bqowner, err := serviceaccount.NewAccount(ctx, "bqowner", &serviceaccount.AccountArgs{
AccountId: pulumi.String("bqowner"),
})
if err != nil {
return err
}
_, err = bigquery.NewDatasetAccess(ctx, "access", &bigquery.DatasetAccessArgs{
DatasetId: dataset.DatasetId,
Role: pulumi.String("OWNER"),
UserByEmail: bqowner.Email,
})
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 dataset = new Gcp.BigQuery.Dataset("dataset", new()
{
DatasetId = "example_dataset",
});
var bqowner = new Gcp.ServiceAccount.Account("bqowner", new()
{
AccountId = "bqowner",
});
var access = new Gcp.BigQuery.DatasetAccess("access", new()
{
DatasetId = dataset.DatasetId,
Role = "OWNER",
UserByEmail = bqowner.Email,
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.bigquery.Dataset;
import com.pulumi.gcp.bigquery.DatasetArgs;
import com.pulumi.gcp.serviceaccount.Account;
import com.pulumi.gcp.serviceaccount.AccountArgs;
import com.pulumi.gcp.bigquery.DatasetAccess;
import com.pulumi.gcp.bigquery.DatasetAccessArgs;
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 dataset = new Dataset("dataset", DatasetArgs.builder()
.datasetId("example_dataset")
.build());
var bqowner = new Account("bqowner", AccountArgs.builder()
.accountId("bqowner")
.build());
var access = new DatasetAccess("access", DatasetAccessArgs.builder()
.datasetId(dataset.datasetId())
.role("OWNER")
.userByEmail(bqowner.email())
.build());
}
}
resources:
access:
type: gcp:bigquery:DatasetAccess
properties:
datasetId: ${dataset.datasetId}
role: OWNER
userByEmail: ${bqowner.email}
dataset:
type: gcp:bigquery:Dataset
properties:
datasetId: example_dataset
bqowner:
type: gcp:serviceaccount:Account
properties:
accountId: bqowner
Bigquery Dataset Access View
import * as pulumi from "@pulumi/pulumi";
import * as gcp from "@pulumi/gcp";
const _private = new gcp.bigquery.Dataset("private", {datasetId: "example_dataset"});
const _public = new gcp.bigquery.Dataset("public", {datasetId: "example_dataset2"});
const publicTable = new gcp.bigquery.Table("public", {
deletionProtection: false,
datasetId: _public.datasetId,
tableId: "example_table",
view: {
query: "SELECT state FROM [lookerdata:cdc.project_tycho_reports]",
useLegacySql: false,
},
});
const access = new gcp.bigquery.DatasetAccess("access", {
datasetId: _private.datasetId,
view: {
projectId: publicTable.project,
datasetId: _public.datasetId,
tableId: publicTable.tableId,
},
});
import pulumi
import pulumi_gcp as gcp
private = gcp.bigquery.Dataset("private", dataset_id="example_dataset")
public = gcp.bigquery.Dataset("public", dataset_id="example_dataset2")
public_table = gcp.bigquery.Table("public",
deletion_protection=False,
dataset_id=public.dataset_id,
table_id="example_table",
view={
"query": "SELECT state FROM [lookerdata:cdc.project_tycho_reports]",
"use_legacy_sql": False,
})
access = gcp.bigquery.DatasetAccess("access",
dataset_id=private.dataset_id,
view={
"project_id": public_table.project,
"dataset_id": public.dataset_id,
"table_id": public_table.table_id,
})
package main
import (
"github.com/pulumi/pulumi-gcp/sdk/v8/go/gcp/bigquery"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
private, err := bigquery.NewDataset(ctx, "private", &bigquery.DatasetArgs{
DatasetId: pulumi.String("example_dataset"),
})
if err != nil {
return err
}
public, err := bigquery.NewDataset(ctx, "public", &bigquery.DatasetArgs{
DatasetId: pulumi.String("example_dataset2"),
})
if err != nil {
return err
}
publicTable, err := bigquery.NewTable(ctx, "public", &bigquery.TableArgs{
DeletionProtection: pulumi.Bool(false),
DatasetId: public.DatasetId,
TableId: pulumi.String("example_table"),
View: &bigquery.TableViewArgs{
Query: pulumi.String("SELECT state FROM [lookerdata:cdc.project_tycho_reports]"),
UseLegacySql: pulumi.Bool(false),
},
})
if err != nil {
return err
}
_, err = bigquery.NewDatasetAccess(ctx, "access", &bigquery.DatasetAccessArgs{
DatasetId: private.DatasetId,
View: &bigquery.DatasetAccessViewArgs{
ProjectId: publicTable.Project,
DatasetId: public.DatasetId,
TableId: publicTable.TableId,
},
})
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 @private = new Gcp.BigQuery.Dataset("private", new()
{
DatasetId = "example_dataset",
});
var @public = new Gcp.BigQuery.Dataset("public", new()
{
DatasetId = "example_dataset2",
});
var publicTable = new Gcp.BigQuery.Table("public", new()
{
DeletionProtection = false,
DatasetId = @public.DatasetId,
TableId = "example_table",
View = new Gcp.BigQuery.Inputs.TableViewArgs
{
Query = "SELECT state FROM [lookerdata:cdc.project_tycho_reports]",
UseLegacySql = false,
},
});
var access = new Gcp.BigQuery.DatasetAccess("access", new()
{
DatasetId = @private.DatasetId,
View = new Gcp.BigQuery.Inputs.DatasetAccessViewArgs
{
ProjectId = publicTable.Project,
DatasetId = @public.DatasetId,
TableId = publicTable.TableId,
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.bigquery.Dataset;
import com.pulumi.gcp.bigquery.DatasetArgs;
import com.pulumi.gcp.bigquery.Table;
import com.pulumi.gcp.bigquery.TableArgs;
import com.pulumi.gcp.bigquery.inputs.TableViewArgs;
import com.pulumi.gcp.bigquery.DatasetAccess;
import com.pulumi.gcp.bigquery.DatasetAccessArgs;
import com.pulumi.gcp.bigquery.inputs.DatasetAccessViewArgs;
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 private_ = new Dataset("private", DatasetArgs.builder()
.datasetId("example_dataset")
.build());
var public_ = new Dataset("public", DatasetArgs.builder()
.datasetId("example_dataset2")
.build());
var publicTable = new Table("publicTable", TableArgs.builder()
.deletionProtection(false)
.datasetId(public_.datasetId())
.tableId("example_table")
.view(TableViewArgs.builder()
.query("SELECT state FROM [lookerdata:cdc.project_tycho_reports]")
.useLegacySql(false)
.build())
.build());
var access = new DatasetAccess("access", DatasetAccessArgs.builder()
.datasetId(private_.datasetId())
.view(DatasetAccessViewArgs.builder()
.projectId(publicTable.project())
.datasetId(public_.datasetId())
.tableId(publicTable.tableId())
.build())
.build());
}
}
resources:
access:
type: gcp:bigquery:DatasetAccess
properties:
datasetId: ${private.datasetId}
view:
projectId: ${publicTable.project}
datasetId: ${public.datasetId}
tableId: ${publicTable.tableId}
private:
type: gcp:bigquery:Dataset
properties:
datasetId: example_dataset
public:
type: gcp:bigquery:Dataset
properties:
datasetId: example_dataset2
publicTable:
type: gcp:bigquery:Table
name: public
properties:
deletionProtection: false
datasetId: ${public.datasetId}
tableId: example_table
view:
query: SELECT state FROM [lookerdata:cdc.project_tycho_reports]
useLegacySql: false
Bigquery Dataset Access Authorized Dataset
import * as pulumi from "@pulumi/pulumi";
import * as gcp from "@pulumi/gcp";
const _private = new gcp.bigquery.Dataset("private", {datasetId: "private"});
const _public = new gcp.bigquery.Dataset("public", {datasetId: "public"});
const access = new gcp.bigquery.DatasetAccess("access", {
datasetId: _private.datasetId,
authorizedDataset: {
dataset: {
projectId: _public.project,
datasetId: _public.datasetId,
},
targetTypes: ["VIEWS"],
},
});
import pulumi
import pulumi_gcp as gcp
private = gcp.bigquery.Dataset("private", dataset_id="private")
public = gcp.bigquery.Dataset("public", dataset_id="public")
access = gcp.bigquery.DatasetAccess("access",
dataset_id=private.dataset_id,
authorized_dataset={
"dataset": {
"project_id": public.project,
"dataset_id": public.dataset_id,
},
"target_types": ["VIEWS"],
})
package main
import (
"github.com/pulumi/pulumi-gcp/sdk/v8/go/gcp/bigquery"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
private, err := bigquery.NewDataset(ctx, "private", &bigquery.DatasetArgs{
DatasetId: pulumi.String("private"),
})
if err != nil {
return err
}
public, err := bigquery.NewDataset(ctx, "public", &bigquery.DatasetArgs{
DatasetId: pulumi.String("public"),
})
if err != nil {
return err
}
_, err = bigquery.NewDatasetAccess(ctx, "access", &bigquery.DatasetAccessArgs{
DatasetId: private.DatasetId,
AuthorizedDataset: &bigquery.DatasetAccessAuthorizedDatasetArgs{
Dataset: &bigquery.DatasetAccessAuthorizedDatasetDatasetArgs{
ProjectId: public.Project,
DatasetId: public.DatasetId,
},
TargetTypes: pulumi.StringArray{
pulumi.String("VIEWS"),
},
},
})
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 @private = new Gcp.BigQuery.Dataset("private", new()
{
DatasetId = "private",
});
var @public = new Gcp.BigQuery.Dataset("public", new()
{
DatasetId = "public",
});
var access = new Gcp.BigQuery.DatasetAccess("access", new()
{
DatasetId = @private.DatasetId,
AuthorizedDataset = new Gcp.BigQuery.Inputs.DatasetAccessAuthorizedDatasetArgs
{
Dataset = new Gcp.BigQuery.Inputs.DatasetAccessAuthorizedDatasetDatasetArgs
{
ProjectId = @public.Project,
DatasetId = @public.DatasetId,
},
TargetTypes = new[]
{
"VIEWS",
},
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.bigquery.Dataset;
import com.pulumi.gcp.bigquery.DatasetArgs;
import com.pulumi.gcp.bigquery.DatasetAccess;
import com.pulumi.gcp.bigquery.DatasetAccessArgs;
import com.pulumi.gcp.bigquery.inputs.DatasetAccessAuthorizedDatasetArgs;
import com.pulumi.gcp.bigquery.inputs.DatasetAccessAuthorizedDatasetDatasetArgs;
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 private_ = new Dataset("private", DatasetArgs.builder()
.datasetId("private")
.build());
var public_ = new Dataset("public", DatasetArgs.builder()
.datasetId("public")
.build());
var access = new DatasetAccess("access", DatasetAccessArgs.builder()
.datasetId(private_.datasetId())
.authorizedDataset(DatasetAccessAuthorizedDatasetArgs.builder()
.dataset(DatasetAccessAuthorizedDatasetDatasetArgs.builder()
.projectId(public_.project())
.datasetId(public_.datasetId())
.build())
.targetTypes("VIEWS")
.build())
.build());
}
}
resources:
access:
type: gcp:bigquery:DatasetAccess
properties:
datasetId: ${private.datasetId}
authorizedDataset:
dataset:
projectId: ${public.project}
datasetId: ${public.datasetId}
targetTypes:
- VIEWS
private:
type: gcp:bigquery:Dataset
properties:
datasetId: private
public:
type: gcp:bigquery:Dataset
properties:
datasetId: public
Bigquery Dataset Access Authorized Routine
import * as pulumi from "@pulumi/pulumi";
import * as gcp from "@pulumi/gcp";
const _public = new gcp.bigquery.Dataset("public", {
datasetId: "public_dataset",
description: "This dataset is public",
});
const publicRoutine = new gcp.bigquery.Routine("public", {
datasetId: _public.datasetId,
routineId: "public_routine",
routineType: "TABLE_VALUED_FUNCTION",
language: "SQL",
definitionBody: "SELECT 1 + value AS value\n",
arguments: [{
name: "value",
argumentKind: "FIXED_TYPE",
dataType: JSON.stringify({
typeKind: "INT64",
}),
}],
returnTableType: JSON.stringify({
columns: [{
name: "value",
type: {
typeKind: "INT64",
},
}],
}),
});
const _private = new gcp.bigquery.Dataset("private", {
datasetId: "private_dataset",
description: "This dataset is private",
});
const authorizedRoutine = new gcp.bigquery.DatasetAccess("authorized_routine", {
datasetId: _private.datasetId,
routine: {
projectId: publicRoutine.project,
datasetId: publicRoutine.datasetId,
routineId: publicRoutine.routineId,
},
});
import pulumi
import json
import pulumi_gcp as gcp
public = gcp.bigquery.Dataset("public",
dataset_id="public_dataset",
description="This dataset is public")
public_routine = gcp.bigquery.Routine("public",
dataset_id=public.dataset_id,
routine_id="public_routine",
routine_type="TABLE_VALUED_FUNCTION",
language="SQL",
definition_body="SELECT 1 + value AS value\n",
arguments=[{
"name": "value",
"argument_kind": "FIXED_TYPE",
"data_type": json.dumps({
"typeKind": "INT64",
}),
}],
return_table_type=json.dumps({
"columns": [{
"name": "value",
"type": {
"typeKind": "INT64",
},
}],
}))
private = gcp.bigquery.Dataset("private",
dataset_id="private_dataset",
description="This dataset is private")
authorized_routine = gcp.bigquery.DatasetAccess("authorized_routine",
dataset_id=private.dataset_id,
routine={
"project_id": public_routine.project,
"dataset_id": public_routine.dataset_id,
"routine_id": public_routine.routine_id,
})
package main
import (
"encoding/json"
"github.com/pulumi/pulumi-gcp/sdk/v8/go/gcp/bigquery"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
public, err := bigquery.NewDataset(ctx, "public", &bigquery.DatasetArgs{
DatasetId: pulumi.String("public_dataset"),
Description: pulumi.String("This dataset is public"),
})
if err != nil {
return err
}
tmpJSON0, err := json.Marshal(map[string]interface{}{
"typeKind": "INT64",
})
if err != nil {
return err
}
json0 := string(tmpJSON0)
tmpJSON1, err := json.Marshal(map[string]interface{}{
"columns": []map[string]interface{}{
map[string]interface{}{
"name": "value",
"type": map[string]interface{}{
"typeKind": "INT64",
},
},
},
})
if err != nil {
return err
}
json1 := string(tmpJSON1)
publicRoutine, err := bigquery.NewRoutine(ctx, "public", &bigquery.RoutineArgs{
DatasetId: public.DatasetId,
RoutineId: pulumi.String("public_routine"),
RoutineType: pulumi.String("TABLE_VALUED_FUNCTION"),
Language: pulumi.String("SQL"),
DefinitionBody: pulumi.String("SELECT 1 + value AS value\n"),
Arguments: bigquery.RoutineArgumentArray{
&bigquery.RoutineArgumentArgs{
Name: pulumi.String("value"),
ArgumentKind: pulumi.String("FIXED_TYPE"),
DataType: pulumi.String(json0),
},
},
ReturnTableType: pulumi.String(json1),
})
if err != nil {
return err
}
private, err := bigquery.NewDataset(ctx, "private", &bigquery.DatasetArgs{
DatasetId: pulumi.String("private_dataset"),
Description: pulumi.String("This dataset is private"),
})
if err != nil {
return err
}
_, err = bigquery.NewDatasetAccess(ctx, "authorized_routine", &bigquery.DatasetAccessArgs{
DatasetId: private.DatasetId,
Routine: &bigquery.DatasetAccessRoutineArgs{
ProjectId: publicRoutine.Project,
DatasetId: publicRoutine.DatasetId,
RoutineId: publicRoutine.RoutineId,
},
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using System.Text.Json;
using Pulumi;
using Gcp = Pulumi.Gcp;
return await Deployment.RunAsync(() =>
{
var @public = new Gcp.BigQuery.Dataset("public", new()
{
DatasetId = "public_dataset",
Description = "This dataset is public",
});
var publicRoutine = new Gcp.BigQuery.Routine("public", new()
{
DatasetId = @public.DatasetId,
RoutineId = "public_routine",
RoutineType = "TABLE_VALUED_FUNCTION",
Language = "SQL",
DefinitionBody = @"SELECT 1 + value AS value
",
Arguments = new[]
{
new Gcp.BigQuery.Inputs.RoutineArgumentArgs
{
Name = "value",
ArgumentKind = "FIXED_TYPE",
DataType = JsonSerializer.Serialize(new Dictionary<string, object?>
{
["typeKind"] = "INT64",
}),
},
},
ReturnTableType = JsonSerializer.Serialize(new Dictionary<string, object?>
{
["columns"] = new[]
{
new Dictionary<string, object?>
{
["name"] = "value",
["type"] = new Dictionary<string, object?>
{
["typeKind"] = "INT64",
},
},
},
}),
});
var @private = new Gcp.BigQuery.Dataset("private", new()
{
DatasetId = "private_dataset",
Description = "This dataset is private",
});
var authorizedRoutine = new Gcp.BigQuery.DatasetAccess("authorized_routine", new()
{
DatasetId = @private.DatasetId,
Routine = new Gcp.BigQuery.Inputs.DatasetAccessRoutineArgs
{
ProjectId = publicRoutine.Project,
DatasetId = publicRoutine.DatasetId,
RoutineId = publicRoutine.RoutineId,
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.bigquery.Dataset;
import com.pulumi.gcp.bigquery.DatasetArgs;
import com.pulumi.gcp.bigquery.Routine;
import com.pulumi.gcp.bigquery.RoutineArgs;
import com.pulumi.gcp.bigquery.inputs.RoutineArgumentArgs;
import com.pulumi.gcp.bigquery.DatasetAccess;
import com.pulumi.gcp.bigquery.DatasetAccessArgs;
import com.pulumi.gcp.bigquery.inputs.DatasetAccessRoutineArgs;
import static com.pulumi.codegen.internal.Serialization.*;
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 public_ = new Dataset("public", DatasetArgs.builder()
.datasetId("public_dataset")
.description("This dataset is public")
.build());
var publicRoutine = new Routine("publicRoutine", RoutineArgs.builder()
.datasetId(public_.datasetId())
.routineId("public_routine")
.routineType("TABLE_VALUED_FUNCTION")
.language("SQL")
.definitionBody("""
SELECT 1 + value AS value
""")
.arguments(RoutineArgumentArgs.builder()
.name("value")
.argumentKind("FIXED_TYPE")
.dataType(serializeJson(
jsonObject(
jsonProperty("typeKind", "INT64")
)))
.build())
.returnTableType(serializeJson(
jsonObject(
jsonProperty("columns", jsonArray(jsonObject(
jsonProperty("name", "value"),
jsonProperty("type", jsonObject(
jsonProperty("typeKind", "INT64")
))
)))
)))
.build());
var private_ = new Dataset("private", DatasetArgs.builder()
.datasetId("private_dataset")
.description("This dataset is private")
.build());
var authorizedRoutine = new DatasetAccess("authorizedRoutine", DatasetAccessArgs.builder()
.datasetId(private_.datasetId())
.routine(DatasetAccessRoutineArgs.builder()
.projectId(publicRoutine.project())
.datasetId(publicRoutine.datasetId())
.routineId(publicRoutine.routineId())
.build())
.build());
}
}
resources:
public:
type: gcp:bigquery:Dataset
properties:
datasetId: public_dataset
description: This dataset is public
publicRoutine:
type: gcp:bigquery:Routine
name: public
properties:
datasetId: ${public.datasetId}
routineId: public_routine
routineType: TABLE_VALUED_FUNCTION
language: SQL
definitionBody: |
SELECT 1 + value AS value
arguments:
- name: value
argumentKind: FIXED_TYPE
dataType:
fn::toJSON:
typeKind: INT64
returnTableType:
fn::toJSON:
columns:
- name: value
type:
typeKind: INT64
private:
type: gcp:bigquery:Dataset
properties:
datasetId: private_dataset
description: This dataset is private
authorizedRoutine:
type: gcp:bigquery:DatasetAccess
name: authorized_routine
properties:
datasetId: ${private.datasetId}
routine:
projectId: ${publicRoutine.project}
datasetId: ${publicRoutine.datasetId}
routineId: ${publicRoutine.routineId}
Create DatasetAccess Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new DatasetAccess(name: string, args: DatasetAccessArgs, opts?: CustomResourceOptions);@overload
def DatasetAccess(resource_name: str,
args: DatasetAccessInitArgs,
opts: Optional[ResourceOptions] = None)
@overload
def DatasetAccess(resource_name: str,
opts: Optional[ResourceOptions] = None,
dataset_id: Optional[str] = None,
authorized_dataset: Optional[DatasetAccessAuthorizedDatasetArgs] = None,
condition: Optional[DatasetAccessConditionArgs] = None,
domain: Optional[str] = None,
group_by_email: Optional[str] = None,
iam_member: Optional[str] = None,
project: Optional[str] = None,
role: Optional[str] = None,
routine: Optional[DatasetAccessRoutineArgs] = None,
special_group: Optional[str] = None,
user_by_email: Optional[str] = None,
view: Optional[DatasetAccessViewArgs] = None)func NewDatasetAccess(ctx *Context, name string, args DatasetAccessArgs, opts ...ResourceOption) (*DatasetAccess, error)public DatasetAccess(string name, DatasetAccessArgs args, CustomResourceOptions? opts = null)public DatasetAccess(String name, DatasetAccessArgs args)
public DatasetAccess(String name, DatasetAccessArgs args, CustomResourceOptions options)
type: gcp:bigquery:DatasetAccess
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name
This property is required. string - The unique name of the resource.
- args
This property is required. DatasetAccessArgs - The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name
This property is required. str - The unique name of the resource.
- args
This property is required. DatasetAccessInitArgs - The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name
This property is required. string - The unique name of the resource.
- args
This property is required. DatasetAccessArgs - The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name
This property is required. string - The unique name of the resource.
- args
This property is required. DatasetAccessArgs - The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name
This property is required. String - The unique name of the resource.
- args
This property is required. DatasetAccessArgs - The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var datasetAccessResource = new Gcp.BigQuery.DatasetAccess("datasetAccessResource", new()
{
DatasetId = "string",
AuthorizedDataset = new Gcp.BigQuery.Inputs.DatasetAccessAuthorizedDatasetArgs
{
Dataset = new Gcp.BigQuery.Inputs.DatasetAccessAuthorizedDatasetDatasetArgs
{
DatasetId = "string",
ProjectId = "string",
},
TargetTypes = new[]
{
"string",
},
},
Condition = new Gcp.BigQuery.Inputs.DatasetAccessConditionArgs
{
Expression = "string",
Description = "string",
Location = "string",
Title = "string",
},
Domain = "string",
GroupByEmail = "string",
IamMember = "string",
Project = "string",
Role = "string",
Routine = new Gcp.BigQuery.Inputs.DatasetAccessRoutineArgs
{
DatasetId = "string",
ProjectId = "string",
RoutineId = "string",
},
SpecialGroup = "string",
UserByEmail = "string",
View = new Gcp.BigQuery.Inputs.DatasetAccessViewArgs
{
DatasetId = "string",
ProjectId = "string",
TableId = "string",
},
});
example, err := bigquery.NewDatasetAccess(ctx, "datasetAccessResource", &bigquery.DatasetAccessArgs{
DatasetId: pulumi.String("string"),
AuthorizedDataset: &bigquery.DatasetAccessAuthorizedDatasetArgs{
Dataset: &bigquery.DatasetAccessAuthorizedDatasetDatasetArgs{
DatasetId: pulumi.String("string"),
ProjectId: pulumi.String("string"),
},
TargetTypes: pulumi.StringArray{
pulumi.String("string"),
},
},
Condition: &bigquery.DatasetAccessConditionArgs{
Expression: pulumi.String("string"),
Description: pulumi.String("string"),
Location: pulumi.String("string"),
Title: pulumi.String("string"),
},
Domain: pulumi.String("string"),
GroupByEmail: pulumi.String("string"),
IamMember: pulumi.String("string"),
Project: pulumi.String("string"),
Role: pulumi.String("string"),
Routine: &bigquery.DatasetAccessRoutineArgs{
DatasetId: pulumi.String("string"),
ProjectId: pulumi.String("string"),
RoutineId: pulumi.String("string"),
},
SpecialGroup: pulumi.String("string"),
UserByEmail: pulumi.String("string"),
View: &bigquery.DatasetAccessViewArgs{
DatasetId: pulumi.String("string"),
ProjectId: pulumi.String("string"),
TableId: pulumi.String("string"),
},
})
var datasetAccessResource = new DatasetAccess("datasetAccessResource", DatasetAccessArgs.builder()
.datasetId("string")
.authorizedDataset(DatasetAccessAuthorizedDatasetArgs.builder()
.dataset(DatasetAccessAuthorizedDatasetDatasetArgs.builder()
.datasetId("string")
.projectId("string")
.build())
.targetTypes("string")
.build())
.condition(DatasetAccessConditionArgs.builder()
.expression("string")
.description("string")
.location("string")
.title("string")
.build())
.domain("string")
.groupByEmail("string")
.iamMember("string")
.project("string")
.role("string")
.routine(DatasetAccessRoutineArgs.builder()
.datasetId("string")
.projectId("string")
.routineId("string")
.build())
.specialGroup("string")
.userByEmail("string")
.view(DatasetAccessViewArgs.builder()
.datasetId("string")
.projectId("string")
.tableId("string")
.build())
.build());
dataset_access_resource = gcp.bigquery.DatasetAccess("datasetAccessResource",
dataset_id="string",
authorized_dataset={
"dataset": {
"dataset_id": "string",
"project_id": "string",
},
"target_types": ["string"],
},
condition={
"expression": "string",
"description": "string",
"location": "string",
"title": "string",
},
domain="string",
group_by_email="string",
iam_member="string",
project="string",
role="string",
routine={
"dataset_id": "string",
"project_id": "string",
"routine_id": "string",
},
special_group="string",
user_by_email="string",
view={
"dataset_id": "string",
"project_id": "string",
"table_id": "string",
})
const datasetAccessResource = new gcp.bigquery.DatasetAccess("datasetAccessResource", {
datasetId: "string",
authorizedDataset: {
dataset: {
datasetId: "string",
projectId: "string",
},
targetTypes: ["string"],
},
condition: {
expression: "string",
description: "string",
location: "string",
title: "string",
},
domain: "string",
groupByEmail: "string",
iamMember: "string",
project: "string",
role: "string",
routine: {
datasetId: "string",
projectId: "string",
routineId: "string",
},
specialGroup: "string",
userByEmail: "string",
view: {
datasetId: "string",
projectId: "string",
tableId: "string",
},
});
type: gcp:bigquery:DatasetAccess
properties:
authorizedDataset:
dataset:
datasetId: string
projectId: string
targetTypes:
- string
condition:
description: string
expression: string
location: string
title: string
datasetId: string
domain: string
groupByEmail: string
iamMember: string
project: string
role: string
routine:
datasetId: string
projectId: string
routineId: string
specialGroup: string
userByEmail: string
view:
datasetId: string
projectId: string
tableId: string
DatasetAccess Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The DatasetAccess resource accepts the following input properties:
- Dataset
Id stringThis property is required. 
Changes to this property will trigger replacement. - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
Access Authorized Dataset - Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- Condition
Access Condition - Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- Domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- Group
By Email - An email address of a Google Group to grant access to.
- Iam
Member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - Project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- Role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- Routine
Access Routine - A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- Special
Group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- User
By Email - An email address of a user to grant access to. For example: fred@example.com
- View
Access View - A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
- Dataset
Id stringThis property is required. Changes to this property will trigger replacement. - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
Access Authorized Dataset Args - Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- Condition
Access Condition Args - Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- Domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- Group
By Email - An email address of a Google Group to grant access to.
- Iam
Member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - Project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- Role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- Routine
Access Routine Args - A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- Special
Group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- User
By Email - An email address of a user to grant access to. For example: fred@example.com
- View
Access View Args - A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
- dataset
Id StringThis property is required. Changes to this property will trigger replacement. - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
Access Authorized Dataset - Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- condition
Access Condition - Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- group
By Email - An email address of a Google Group to grant access to.
- iam
Member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- routine
Access Routine - A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- special
Group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- user
By Email - An email address of a user to grant access to. For example: fred@example.com
- view
Access View - A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
- dataset
Id stringThis property is required. Changes to this property will trigger replacement. - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
Access Authorized Dataset - Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- condition
Access Condition - Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- group
By Email - An email address of a Google Group to grant access to.
- iam
Member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- routine
Access Routine - A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- special
Group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- user
By Email - An email address of a user to grant access to. For example: fred@example.com
- view
Access View - A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
- dataset_
id strThis property is required. Changes to this property will trigger replacement. - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
Access Authorized Dataset Args - Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- condition
Access Condition Args - Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- group_
by_ email - An email address of a Google Group to grant access to.
- iam_
member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- routine
Access Routine Args - A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- special_
group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- user_
by_ email - An email address of a user to grant access to. For example: fred@example.com
- view
Access View Args - A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
- dataset
Id StringThis property is required. Changes to this property will trigger replacement. - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
- Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- condition
- Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- group
By Email - An email address of a Google Group to grant access to.
- iam
Member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- routine
- A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- special
Group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- user
By Email - An email address of a user to grant access to. For example: fred@example.com
- view
- A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
Outputs
All input properties are implicitly available as output properties. Additionally, the DatasetAccess resource produces the following output properties:
- Api
Updated boolMember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
- Id string
- The provider-assigned unique ID for this managed resource.
- Api
Updated boolMember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
- Id string
- The provider-assigned unique ID for this managed resource.
- api
Updated BooleanMember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
- id String
- The provider-assigned unique ID for this managed resource.
- api
Updated booleanMember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
- id string
- The provider-assigned unique ID for this managed resource.
- api_
updated_ boolmember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
- id str
- The provider-assigned unique ID for this managed resource.
- api
Updated BooleanMember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
- id String
- The provider-assigned unique ID for this managed resource.
Look up Existing DatasetAccess Resource
Get an existing DatasetAccess resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: DatasetAccessState, opts?: CustomResourceOptions): DatasetAccess@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
api_updated_member: Optional[bool] = None,
authorized_dataset: Optional[DatasetAccessAuthorizedDatasetArgs] = None,
condition: Optional[DatasetAccessConditionArgs] = None,
dataset_id: Optional[str] = None,
domain: Optional[str] = None,
group_by_email: Optional[str] = None,
iam_member: Optional[str] = None,
project: Optional[str] = None,
role: Optional[str] = None,
routine: Optional[DatasetAccessRoutineArgs] = None,
special_group: Optional[str] = None,
user_by_email: Optional[str] = None,
view: Optional[DatasetAccessViewArgs] = None) -> DatasetAccessfunc GetDatasetAccess(ctx *Context, name string, id IDInput, state *DatasetAccessState, opts ...ResourceOption) (*DatasetAccess, error)public static DatasetAccess Get(string name, Input<string> id, DatasetAccessState? state, CustomResourceOptions? opts = null)public static DatasetAccess get(String name, Output<String> id, DatasetAccessState state, CustomResourceOptions options)resources: _: type: gcp:bigquery:DatasetAccess get: id: ${id}- name
This property is required. - The unique name of the resulting resource.
- id
This property is required. - The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
This property is required. - The unique name of the resulting resource.
- id
This property is required. - The unique provider ID of the resource to lookup.
- name
This property is required. - The unique name of the resulting resource.
- id
This property is required. - The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
This property is required. - The unique name of the resulting resource.
- id
This property is required. - The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
This property is required. - The unique name of the resulting resource.
- id
This property is required. - The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
The following state arguments are supported:
- Api
Updated boolMember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
Access Authorized Dataset - Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- Condition
Access Condition - Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- Dataset
Id - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
- Domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- Group
By Email - An email address of a Google Group to grant access to.
- Iam
Member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - Project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- Role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- Routine
Access Routine - A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- Special
Group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- User
By Email - An email address of a user to grant access to. For example: fred@example.com
- View
Access View - A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
- Api
Updated boolMember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
Access Authorized Dataset Args - Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- Condition
Access Condition Args - Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- Dataset
Id - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
- Domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- Group
By Email - An email address of a Google Group to grant access to.
- Iam
Member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - Project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- Role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- Routine
Access Routine Args - A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- Special
Group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- User
By Email - An email address of a user to grant access to. For example: fred@example.com
- View
Access View Args - A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
- api
Updated BooleanMember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
Access Authorized Dataset - Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- condition
Access Condition - Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- dataset
Id - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
- domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- group
By Email - An email address of a Google Group to grant access to.
- iam
Member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- routine
Access Routine - A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- special
Group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- user
By Email - An email address of a user to grant access to. For example: fred@example.com
- view
Access View - A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
- api
Updated booleanMember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
Access Authorized Dataset - Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- condition
Access Condition - Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- dataset
Id - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
- domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- group
By Email - An email address of a Google Group to grant access to.
- iam
Member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- routine
Access Routine - A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- special
Group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- user
By Email - An email address of a user to grant access to. For example: fred@example.com
- view
Access View - A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
- api_
updated_ boolmember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
Access Authorized Dataset Args - Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- condition
Access Condition Args - Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- dataset_
id - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
- domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- group_
by_ email - An email address of a Google Group to grant access to.
- iam_
member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- routine
Access Routine Args - A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- special_
group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- user_
by_ email - An email address of a user to grant access to. For example: fred@example.com
- view
Access View Args - A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
- api
Updated BooleanMember - If true, represents that that the iam_member in the config was translated to a different member type by the API, and is stored in state as a different member type
- Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
- condition
- Condition for the binding. If CEL expression in this field is true, this access binding will be considered. Structure is documented below.
- dataset
Id - A unique ID for this dataset, without the project name. The ID
must contain only letters (a-z, A-Z), numbers (0-9), or
underscores (_). The maximum length is 1,024 characters.
- domain
- A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
- group
By Email - An email address of a Google Group to grant access to.
- iam
Member - Some other type of member that appears in the IAM Policy but isn't a user,
group, domain, or special group. For example:
allUsers - project
- The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
- role
- Describes the rights granted to the user specified by the other member of the access object. Basic, predefined, and custom roles are supported. Predefined roles that have equivalent basic roles are swapped by the API to their basic counterparts, and will show a diff post-create. See official docs.
- routine
- A routine from a different dataset to grant access to. Queries executed against that routine will have read access to tables in this dataset. The role field is not required when this field is set. If that routine is updated by any user, access to the routine needs to be granted again via an update operation. Structure is documented below.
- special
Group - A special group to grant access to. Possible values include:
projectOwners: Owners of the enclosing project.projectReaders: Readers of the enclosing project.projectWriters: Writers of the enclosing project.allAuthenticatedUsers: All authenticated BigQuery users.
- user
By Email - An email address of a user to grant access to. For example: fred@example.com
- view
- A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. Structure is documented below.
Supporting Types
DatasetAccessAuthorizedDataset, DatasetAccessAuthorizedDatasetArgs
, DatasetAccessAuthorizedDatasetArgs
- Dataset
Dataset
This property is required. Changes to this property will trigger replacement.Access Authorized Dataset Dataset - The dataset this entry applies to Structure is documented below.
- Target
Types List<string>This property is required. Changes to this property will trigger replacement. - Which resources in the dataset this entry applies to. Currently, only views are supported, but additional target types may be added in the future. Possible values: VIEWS
- Dataset
Dataset
This property is required. Changes to this property will trigger replacement.Access Authorized Dataset Dataset - The dataset this entry applies to Structure is documented below.
- Target
Types []stringThis property is required. Changes to this property will trigger replacement. - Which resources in the dataset this entry applies to. Currently, only views are supported, but additional target types may be added in the future. Possible values: VIEWS
- dataset
Dataset
This property is required. Changes to this property will trigger replacement.Access Authorized Dataset Dataset - The dataset this entry applies to Structure is documented below.
- target
Types List<String>This property is required. Changes to this property will trigger replacement. - Which resources in the dataset this entry applies to. Currently, only views are supported, but additional target types may be added in the future. Possible values: VIEWS
- dataset
Dataset
This property is required. Changes to this property will trigger replacement.Access Authorized Dataset Dataset - The dataset this entry applies to Structure is documented below.
- target
Types string[]This property is required. Changes to this property will trigger replacement. - Which resources in the dataset this entry applies to. Currently, only views are supported, but additional target types may be added in the future. Possible values: VIEWS
- dataset
Dataset
This property is required. Changes to this property will trigger replacement.Access Authorized Dataset Dataset - The dataset this entry applies to Structure is documented below.
- target_
types Sequence[str]This property is required. Changes to this property will trigger replacement. - Which resources in the dataset this entry applies to. Currently, only views are supported, but additional target types may be added in the future. Possible values: VIEWS
- dataset
Property Map
This property is required. Changes to this property will trigger replacement. - The dataset this entry applies to Structure is documented below.
- target
Types List<String>This property is required. Changes to this property will trigger replacement. - Which resources in the dataset this entry applies to. Currently, only views are supported, but additional target types may be added in the future. Possible values: VIEWS
DatasetAccessAuthorizedDatasetDataset, DatasetAccessAuthorizedDatasetDatasetArgs
, DatasetAccessAuthorizedDatasetDatasetArgs
- dataset_
id strThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- project_
id strThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
DatasetAccessCondition, DatasetAccessConditionArgs
, DatasetAccessConditionArgs
- Expression
string
This property is required. Changes to this property will trigger replacement. - Textual representation of an expression in Common Expression Language syntax.
- Description
- Description of the expression. This is a longer text which describes the expression, e.g. when hovered over it in a UI.
- Location
- String indicating the location of the expression for error reporting, e.g. a file name and a position in the file.
- Title
- Title for the expression, i.e. a short string describing its purpose. This can be used e.g. in UIs which allow to enter the expression.
- Expression
string
This property is required. Changes to this property will trigger replacement. - Textual representation of an expression in Common Expression Language syntax.
- Description
- Description of the expression. This is a longer text which describes the expression, e.g. when hovered over it in a UI.
- Location
- String indicating the location of the expression for error reporting, e.g. a file name and a position in the file.
- Title
- Title for the expression, i.e. a short string describing its purpose. This can be used e.g. in UIs which allow to enter the expression.
- expression
String
This property is required. Changes to this property will trigger replacement. - Textual representation of an expression in Common Expression Language syntax.
- description
- Description of the expression. This is a longer text which describes the expression, e.g. when hovered over it in a UI.
- location
- String indicating the location of the expression for error reporting, e.g. a file name and a position in the file.
- title
- Title for the expression, i.e. a short string describing its purpose. This can be used e.g. in UIs which allow to enter the expression.
- expression
string
This property is required. Changes to this property will trigger replacement. - Textual representation of an expression in Common Expression Language syntax.
- description
- Description of the expression. This is a longer text which describes the expression, e.g. when hovered over it in a UI.
- location
- String indicating the location of the expression for error reporting, e.g. a file name and a position in the file.
- title
- Title for the expression, i.e. a short string describing its purpose. This can be used e.g. in UIs which allow to enter the expression.
- expression
str
This property is required. Changes to this property will trigger replacement. - Textual representation of an expression in Common Expression Language syntax.
- description
- Description of the expression. This is a longer text which describes the expression, e.g. when hovered over it in a UI.
- location
- String indicating the location of the expression for error reporting, e.g. a file name and a position in the file.
- title
- Title for the expression, i.e. a short string describing its purpose. This can be used e.g. in UIs which allow to enter the expression.
- expression
String
This property is required. Changes to this property will trigger replacement. - Textual representation of an expression in Common Expression Language syntax.
- description
- Description of the expression. This is a longer text which describes the expression, e.g. when hovered over it in a UI.
- location
- String indicating the location of the expression for error reporting, e.g. a file name and a position in the file.
- title
- Title for the expression, i.e. a short string describing its purpose. This can be used e.g. in UIs which allow to enter the expression.
DatasetAccessRoutine, DatasetAccessRoutineArgs
, DatasetAccessRoutineArgs
- Dataset
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- Project
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- Routine
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
- Dataset
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- Project
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- Routine
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
- dataset
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- project
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- routine
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
- dataset
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- project
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- routine
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
- dataset_
id strThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- project_
id strThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- routine_
id strThis property is required. Changes to this property will trigger replacement. - The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
- dataset
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- project
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- routine
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the routine. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 256 characters.
DatasetAccessView, DatasetAccessViewArgs
, DatasetAccessViewArgs
- Dataset
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- Project
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- Table
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the table. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
- Dataset
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- Project
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- Table
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the table. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
- dataset
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- project
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- table
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the table. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
- dataset
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- project
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- table
Id stringThis property is required. Changes to this property will trigger replacement. - The ID of the table. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
- dataset_
id strThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- project_
id strThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- table_
id strThis property is required. Changes to this property will trigger replacement. - The ID of the table. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
- dataset
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the dataset containing this table.
- project
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the project containing this table.
- table
Id StringThis property is required. Changes to this property will trigger replacement. - The ID of the table. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
Import
This resource does not support import.
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- Google Cloud (GCP) Classic pulumi/pulumi-gcp
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
google-betaTerraform Provider.
- Example Usage
- Bigquery Dataset Access Basic User
- Bigquery Dataset Access View
- Bigquery Dataset Access Authorized Dataset
- Bigquery Dataset Access Authorized Routine
- Create DatasetAccess Resource
- Constructor syntax
- Constructor example
- DatasetAccess Resource Properties
- Inputs
- Outputs
- Look up Existing DatasetAccess Resource
- Supporting Types
- Import
- Package Details