1. Packages
  2. Google Cloud (GCP) Classic
  3. API Docs
  4. bigquery
  5. DatasetAccess
Google Cloud Classic v7.18.0 published on Wednesday, Apr 10, 2024 by Pulumi

gcp.bigquery.DatasetAccess

Explore with Pulumi AI

gcp logo
Google Cloud Classic v7.18.0 published on Wednesday, Apr 10, 2024 by Pulumi

    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/v7/go/gcp/bigquery"
    	"github.com/pulumi/pulumi-gcp/sdk/v7/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=gcp.bigquery.TableViewArgs(
            query="SELECT state FROM [lookerdata:cdc.project_tycho_reports]",
            use_legacy_sql=False,
        ))
    access = gcp.bigquery.DatasetAccess("access",
        dataset_id=private.dataset_id,
        view=gcp.bigquery.DatasetAccessViewArgs(
            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/v7/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=gcp.bigquery.DatasetAccessAuthorizedDatasetArgs(
            dataset=gcp.bigquery.DatasetAccessAuthorizedDatasetDatasetArgs(
                project_id=public.project,
                dataset_id=public.dataset_id,
            ),
            target_types=["VIEWS"],
        ))
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-gcp/sdk/v7/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=[gcp.bigquery.RoutineArgumentArgs(
            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=gcp.bigquery.DatasetAccessRoutineArgs(
            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/v7/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,
                      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 string
    The unique name of the resource.
    args DatasetAccessArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args 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 string
    The unique name of the resource.
    args DatasetAccessArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args DatasetAccessArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args DatasetAccessArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    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",
            },
        },
        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"),
    		},
    	},
    	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())
        .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=gcp.bigquery.DatasetAccessAuthorizedDatasetArgs(
            dataset=gcp.bigquery.DatasetAccessAuthorizedDatasetDatasetArgs(
                dataset_id="string",
                project_id="string",
            ),
            target_types=["string"],
        ),
        domain="string",
        group_by_email="string",
        iam_member="string",
        project="string",
        role="string",
        routine=gcp.bigquery.DatasetAccessRoutineArgs(
            dataset_id="string",
            project_id="string",
            routine_id="string",
        ),
        special_group="string",
        user_by_email="string",
        view=gcp.bigquery.DatasetAccessViewArgs(
            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"],
        },
        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
        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

    The DatasetAccess resource accepts the following input properties:

    DatasetId string
    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.


    AuthorizedDataset DatasetAccessAuthorizedDataset
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    Domain string
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    GroupByEmail string
    An email address of a Google Group to grant access to.
    IamMember string
    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 string
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    Role string
    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 DatasetAccessRoutine
    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.
    SpecialGroup string
    A special group to grant access to. Possible values include:
    UserByEmail string
    An email address of a user to grant access to. For example: fred@example.com
    View DatasetAccessView
    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.
    DatasetId string
    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.


    AuthorizedDataset DatasetAccessAuthorizedDatasetArgs
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    Domain string
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    GroupByEmail string
    An email address of a Google Group to grant access to.
    IamMember string
    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 string
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    Role string
    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 DatasetAccessRoutineArgs
    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.
    SpecialGroup string
    A special group to grant access to. Possible values include:
    UserByEmail string
    An email address of a user to grant access to. For example: fred@example.com
    View DatasetAccessViewArgs
    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.
    datasetId String
    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.


    authorizedDataset DatasetAccessAuthorizedDataset
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    domain String
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    groupByEmail String
    An email address of a Google Group to grant access to.
    iamMember String
    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 String
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    role String
    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 DatasetAccessRoutine
    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.
    specialGroup String
    A special group to grant access to. Possible values include:
    userByEmail String
    An email address of a user to grant access to. For example: fred@example.com
    view DatasetAccessView
    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.
    datasetId string
    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.


    authorizedDataset DatasetAccessAuthorizedDataset
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    domain string
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    groupByEmail string
    An email address of a Google Group to grant access to.
    iamMember string
    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 string
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    role string
    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 DatasetAccessRoutine
    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.
    specialGroup string
    A special group to grant access to. Possible values include:
    userByEmail string
    An email address of a user to grant access to. For example: fred@example.com
    view DatasetAccessView
    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 str
    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.


    authorized_dataset DatasetAccessAuthorizedDatasetArgs
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    domain str
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    group_by_email str
    An email address of a Google Group to grant access to.
    iam_member str
    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 str
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    role str
    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 DatasetAccessRoutineArgs
    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 str
    A special group to grant access to. Possible values include:
    user_by_email str
    An email address of a user to grant access to. For example: fred@example.com
    view DatasetAccessViewArgs
    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.
    datasetId String
    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.


    authorizedDataset Property Map
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    domain String
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    groupByEmail String
    An email address of a Google Group to grant access to.
    iamMember String
    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 String
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    role String
    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 Property Map
    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.
    specialGroup String
    A special group to grant access to. Possible values include:
    userByEmail String
    An email address of a user to grant access to. For example: fred@example.com
    view Property Map
    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:

    ApiUpdatedMember bool
    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.
    ApiUpdatedMember bool
    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.
    apiUpdatedMember Boolean
    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.
    apiUpdatedMember boolean
    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_member bool
    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.
    apiUpdatedMember Boolean
    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,
            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) -> DatasetAccess
    func 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)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    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
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    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
    The unique name of the resulting resource.
    id
    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
    The unique name of the resulting resource.
    id
    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:
    ApiUpdatedMember bool
    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
    AuthorizedDataset DatasetAccessAuthorizedDataset
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    DatasetId string
    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 string
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    GroupByEmail string
    An email address of a Google Group to grant access to.
    IamMember string
    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 string
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    Role string
    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 DatasetAccessRoutine
    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.
    SpecialGroup string
    A special group to grant access to. Possible values include:
    UserByEmail string
    An email address of a user to grant access to. For example: fred@example.com
    View DatasetAccessView
    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.
    ApiUpdatedMember bool
    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
    AuthorizedDataset DatasetAccessAuthorizedDatasetArgs
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    DatasetId string
    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 string
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    GroupByEmail string
    An email address of a Google Group to grant access to.
    IamMember string
    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 string
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    Role string
    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 DatasetAccessRoutineArgs
    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.
    SpecialGroup string
    A special group to grant access to. Possible values include:
    UserByEmail string
    An email address of a user to grant access to. For example: fred@example.com
    View DatasetAccessViewArgs
    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.
    apiUpdatedMember Boolean
    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
    authorizedDataset DatasetAccessAuthorizedDataset
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    datasetId String
    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 String
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    groupByEmail String
    An email address of a Google Group to grant access to.
    iamMember String
    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 String
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    role String
    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 DatasetAccessRoutine
    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.
    specialGroup String
    A special group to grant access to. Possible values include:
    userByEmail String
    An email address of a user to grant access to. For example: fred@example.com
    view DatasetAccessView
    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.
    apiUpdatedMember boolean
    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
    authorizedDataset DatasetAccessAuthorizedDataset
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    datasetId string
    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 string
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    groupByEmail string
    An email address of a Google Group to grant access to.
    iamMember string
    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 string
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    role string
    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 DatasetAccessRoutine
    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.
    specialGroup string
    A special group to grant access to. Possible values include:
    userByEmail string
    An email address of a user to grant access to. For example: fred@example.com
    view DatasetAccessView
    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_member bool
    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
    authorized_dataset DatasetAccessAuthorizedDatasetArgs
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    dataset_id str
    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 str
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    group_by_email str
    An email address of a Google Group to grant access to.
    iam_member str
    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 str
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    role str
    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 DatasetAccessRoutineArgs
    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 str
    A special group to grant access to. Possible values include:
    user_by_email str
    An email address of a user to grant access to. For example: fred@example.com
    view DatasetAccessViewArgs
    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.
    apiUpdatedMember Boolean
    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
    authorizedDataset Property Map
    Grants all resources of particular types in a particular dataset read access to the current dataset. Structure is documented below.
    datasetId String
    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 String
    A domain to grant access to. Any users signed in with the domain specified will be granted the specified access
    groupByEmail String
    An email address of a Google Group to grant access to.
    iamMember String
    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 String
    The ID of the project in which the resource belongs. If it is not provided, the provider project is used.
    role String
    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 Property Map
    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.
    specialGroup String
    A special group to grant access to. Possible values include:
    userByEmail String
    An email address of a user to grant access to. For example: fred@example.com
    view Property Map
    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

    Dataset DatasetAccessAuthorizedDatasetDataset
    The dataset this entry applies to Structure is documented below.
    TargetTypes List<string>
    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 DatasetAccessAuthorizedDatasetDataset
    The dataset this entry applies to Structure is documented below.
    TargetTypes []string
    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 DatasetAccessAuthorizedDatasetDataset
    The dataset this entry applies to Structure is documented below.
    targetTypes List<String>
    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 DatasetAccessAuthorizedDatasetDataset
    The dataset this entry applies to Structure is documented below.
    targetTypes string[]
    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 DatasetAccessAuthorizedDatasetDataset
    The dataset this entry applies to Structure is documented below.
    target_types Sequence[str]
    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
    The dataset this entry applies to Structure is documented below.
    targetTypes List<String>
    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

    DatasetId string
    The ID of the dataset containing this table.
    ProjectId string
    The ID of the project containing this table.
    DatasetId string
    The ID of the dataset containing this table.
    ProjectId string
    The ID of the project containing this table.
    datasetId String
    The ID of the dataset containing this table.
    projectId String
    The ID of the project containing this table.
    datasetId string
    The ID of the dataset containing this table.
    projectId string
    The ID of the project containing this table.
    dataset_id str
    The ID of the dataset containing this table.
    project_id str
    The ID of the project containing this table.
    datasetId String
    The ID of the dataset containing this table.
    projectId String
    The ID of the project containing this table.

    DatasetAccessRoutine, DatasetAccessRoutineArgs

    DatasetId string
    The ID of the dataset containing this table.
    ProjectId string
    The ID of the project containing this table.
    RoutineId string
    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.
    DatasetId string
    The ID of the dataset containing this table.
    ProjectId string
    The ID of the project containing this table.
    RoutineId string
    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.
    datasetId String
    The ID of the dataset containing this table.
    projectId String
    The ID of the project containing this table.
    routineId String
    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.
    datasetId string
    The ID of the dataset containing this table.
    projectId string
    The ID of the project containing this table.
    routineId string
    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 str
    The ID of the dataset containing this table.
    project_id str
    The ID of the project containing this table.
    routine_id str
    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.
    datasetId String
    The ID of the dataset containing this table.
    projectId String
    The ID of the project containing this table.
    routineId String
    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

    DatasetId string
    The ID of the dataset containing this table.
    ProjectId string
    The ID of the project containing this table.
    TableId string
    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.
    DatasetId string
    The ID of the dataset containing this table.
    ProjectId string
    The ID of the project containing this table.
    TableId string
    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.
    datasetId String
    The ID of the dataset containing this table.
    projectId String
    The ID of the project containing this table.
    tableId String
    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.
    datasetId string
    The ID of the dataset containing this table.
    projectId string
    The ID of the project containing this table.
    tableId string
    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 str
    The ID of the dataset containing this table.
    project_id str
    The ID of the project containing this table.
    table_id str
    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.
    datasetId String
    The ID of the dataset containing this table.
    projectId String
    The ID of the project containing this table.
    tableId String
    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-beta Terraform Provider.
    gcp logo
    Google Cloud Classic v7.18.0 published on Wednesday, Apr 10, 2024 by Pulumi