Google Cloud Native is in preview. Google Cloud Classic is fully supported.
google-native.bigquery/v2.Dataset
Explore with Pulumi AI
Google Cloud Native is in preview. Google Cloud Classic is fully supported.
Creates a new empty dataset. Auto-naming is currently not supported for this resource.
Create Dataset Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new Dataset(name: string, args?: DatasetArgs, opts?: CustomResourceOptions);
@overload
def Dataset(resource_name: str,
args: Optional[DatasetArgs] = None,
opts: Optional[ResourceOptions] = None)
@overload
def Dataset(resource_name: str,
opts: Optional[ResourceOptions] = None,
access: Optional[Sequence[DatasetAccessItemArgs]] = None,
dataset_reference: Optional[DatasetReferenceArgs] = None,
default_encryption_configuration: Optional[EncryptionConfigurationArgs] = None,
default_partition_expiration_ms: Optional[str] = None,
default_table_expiration_ms: Optional[str] = None,
description: Optional[str] = None,
external_dataset_reference: Optional[ExternalDatasetReferenceArgs] = None,
friendly_name: Optional[str] = None,
is_case_insensitive: Optional[bool] = None,
labels: Optional[Mapping[str, str]] = None,
location: Optional[str] = None,
max_time_travel_hours: Optional[str] = None,
project: Optional[str] = None,
storage_billing_model: Optional[str] = None,
tags: Optional[Sequence[DatasetTagsItemArgs]] = None)
func NewDataset(ctx *Context, name string, args *DatasetArgs, opts ...ResourceOption) (*Dataset, error)
public Dataset(string name, DatasetArgs? args = null, CustomResourceOptions? opts = null)
public Dataset(String name, DatasetArgs args)
public Dataset(String name, DatasetArgs args, CustomResourceOptions options)
type: google-native:bigquery/v2:Dataset
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 DatasetArgs
- 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 DatasetArgs
- 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 DatasetArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args DatasetArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args DatasetArgs
- 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 exampledatasetResourceResourceFromBigqueryv2 = new GoogleNative.BigQuery.V2.Dataset("exampledatasetResourceResourceFromBigqueryv2", new()
{
Access = new[]
{
new GoogleNative.BigQuery.V2.Inputs.DatasetAccessItemArgs
{
Dataset = new GoogleNative.BigQuery.V2.Inputs.DatasetAccessEntryArgs
{
Dataset = new GoogleNative.BigQuery.V2.Inputs.DatasetReferenceArgs
{
DatasetId = "string",
Project = "string",
},
TargetTypes = new[]
{
GoogleNative.BigQuery.V2.DatasetAccessEntryTargetTypesItem.TargetTypeUnspecified,
},
},
Domain = "string",
GroupByEmail = "string",
IamMember = "string",
Role = "string",
Routine = new GoogleNative.BigQuery.V2.Inputs.RoutineReferenceArgs
{
DatasetId = "string",
Project = "string",
RoutineId = "string",
},
SpecialGroup = "string",
UserByEmail = "string",
View = new GoogleNative.BigQuery.V2.Inputs.TableReferenceArgs
{
DatasetId = "string",
Project = "string",
TableId = "string",
},
},
},
DatasetReference = new GoogleNative.BigQuery.V2.Inputs.DatasetReferenceArgs
{
DatasetId = "string",
Project = "string",
},
DefaultEncryptionConfiguration = new GoogleNative.BigQuery.V2.Inputs.EncryptionConfigurationArgs
{
KmsKeyName = "string",
},
DefaultPartitionExpirationMs = "string",
DefaultTableExpirationMs = "string",
Description = "string",
ExternalDatasetReference = new GoogleNative.BigQuery.V2.Inputs.ExternalDatasetReferenceArgs
{
Connection = "string",
ExternalSource = "string",
},
FriendlyName = "string",
IsCaseInsensitive = false,
Labels =
{
{ "string", "string" },
},
Location = "string",
MaxTimeTravelHours = "string",
Project = "string",
StorageBillingModel = "string",
Tags = new[]
{
new GoogleNative.BigQuery.V2.Inputs.DatasetTagsItemArgs
{
TagKey = "string",
TagValue = "string",
},
},
});
example, err := bigquery.NewDataset(ctx, "exampledatasetResourceResourceFromBigqueryv2", &bigquery.DatasetArgs{
Access: bigquery.DatasetAccessItemArray{
&bigquery.DatasetAccessItemArgs{
Dataset: &bigquery.DatasetAccessEntryArgs{
Dataset: &bigquery.DatasetReferenceArgs{
DatasetId: pulumi.String("string"),
Project: pulumi.String("string"),
},
TargetTypes: bigquery.DatasetAccessEntryTargetTypesItemArray{
bigquery.DatasetAccessEntryTargetTypesItemTargetTypeUnspecified,
},
},
Domain: pulumi.String("string"),
GroupByEmail: pulumi.String("string"),
IamMember: pulumi.String("string"),
Role: pulumi.String("string"),
Routine: &bigquery.RoutineReferenceArgs{
DatasetId: pulumi.String("string"),
Project: pulumi.String("string"),
RoutineId: pulumi.String("string"),
},
SpecialGroup: pulumi.String("string"),
UserByEmail: pulumi.String("string"),
View: &bigquery.TableReferenceArgs{
DatasetId: pulumi.String("string"),
Project: pulumi.String("string"),
TableId: pulumi.String("string"),
},
},
},
DatasetReference: &bigquery.DatasetReferenceArgs{
DatasetId: pulumi.String("string"),
Project: pulumi.String("string"),
},
DefaultEncryptionConfiguration: &bigquery.EncryptionConfigurationArgs{
KmsKeyName: pulumi.String("string"),
},
DefaultPartitionExpirationMs: pulumi.String("string"),
DefaultTableExpirationMs: pulumi.String("string"),
Description: pulumi.String("string"),
ExternalDatasetReference: &bigquery.ExternalDatasetReferenceArgs{
Connection: pulumi.String("string"),
ExternalSource: pulumi.String("string"),
},
FriendlyName: pulumi.String("string"),
IsCaseInsensitive: pulumi.Bool(false),
Labels: pulumi.StringMap{
"string": pulumi.String("string"),
},
Location: pulumi.String("string"),
MaxTimeTravelHours: pulumi.String("string"),
Project: pulumi.String("string"),
StorageBillingModel: pulumi.String("string"),
Tags: bigquery.DatasetTagsItemArray{
&bigquery.DatasetTagsItemArgs{
TagKey: pulumi.String("string"),
TagValue: pulumi.String("string"),
},
},
})
var exampledatasetResourceResourceFromBigqueryv2 = new Dataset("exampledatasetResourceResourceFromBigqueryv2", DatasetArgs.builder()
.access(DatasetAccessItemArgs.builder()
.dataset(DatasetAccessEntryArgs.builder()
.dataset(DatasetReferenceArgs.builder()
.datasetId("string")
.project("string")
.build())
.targetTypes("TARGET_TYPE_UNSPECIFIED")
.build())
.domain("string")
.groupByEmail("string")
.iamMember("string")
.role("string")
.routine(RoutineReferenceArgs.builder()
.datasetId("string")
.project("string")
.routineId("string")
.build())
.specialGroup("string")
.userByEmail("string")
.view(TableReferenceArgs.builder()
.datasetId("string")
.project("string")
.tableId("string")
.build())
.build())
.datasetReference(DatasetReferenceArgs.builder()
.datasetId("string")
.project("string")
.build())
.defaultEncryptionConfiguration(EncryptionConfigurationArgs.builder()
.kmsKeyName("string")
.build())
.defaultPartitionExpirationMs("string")
.defaultTableExpirationMs("string")
.description("string")
.externalDatasetReference(ExternalDatasetReferenceArgs.builder()
.connection("string")
.externalSource("string")
.build())
.friendlyName("string")
.isCaseInsensitive(false)
.labels(Map.of("string", "string"))
.location("string")
.maxTimeTravelHours("string")
.project("string")
.storageBillingModel("string")
.tags(DatasetTagsItemArgs.builder()
.tagKey("string")
.tagValue("string")
.build())
.build());
exampledataset_resource_resource_from_bigqueryv2 = google_native.bigquery.v2.Dataset("exampledatasetResourceResourceFromBigqueryv2",
access=[{
"dataset": {
"dataset": {
"dataset_id": "string",
"project": "string",
},
"target_types": [google_native.bigquery.v2.DatasetAccessEntryTargetTypesItem.TARGET_TYPE_UNSPECIFIED],
},
"domain": "string",
"group_by_email": "string",
"iam_member": "string",
"role": "string",
"routine": {
"dataset_id": "string",
"project": "string",
"routine_id": "string",
},
"special_group": "string",
"user_by_email": "string",
"view": {
"dataset_id": "string",
"project": "string",
"table_id": "string",
},
}],
dataset_reference={
"dataset_id": "string",
"project": "string",
},
default_encryption_configuration={
"kms_key_name": "string",
},
default_partition_expiration_ms="string",
default_table_expiration_ms="string",
description="string",
external_dataset_reference={
"connection": "string",
"external_source": "string",
},
friendly_name="string",
is_case_insensitive=False,
labels={
"string": "string",
},
location="string",
max_time_travel_hours="string",
project="string",
storage_billing_model="string",
tags=[{
"tag_key": "string",
"tag_value": "string",
}])
const exampledatasetResourceResourceFromBigqueryv2 = new google_native.bigquery.v2.Dataset("exampledatasetResourceResourceFromBigqueryv2", {
access: [{
dataset: {
dataset: {
datasetId: "string",
project: "string",
},
targetTypes: [google_native.bigquery.v2.DatasetAccessEntryTargetTypesItem.TargetTypeUnspecified],
},
domain: "string",
groupByEmail: "string",
iamMember: "string",
role: "string",
routine: {
datasetId: "string",
project: "string",
routineId: "string",
},
specialGroup: "string",
userByEmail: "string",
view: {
datasetId: "string",
project: "string",
tableId: "string",
},
}],
datasetReference: {
datasetId: "string",
project: "string",
},
defaultEncryptionConfiguration: {
kmsKeyName: "string",
},
defaultPartitionExpirationMs: "string",
defaultTableExpirationMs: "string",
description: "string",
externalDatasetReference: {
connection: "string",
externalSource: "string",
},
friendlyName: "string",
isCaseInsensitive: false,
labels: {
string: "string",
},
location: "string",
maxTimeTravelHours: "string",
project: "string",
storageBillingModel: "string",
tags: [{
tagKey: "string",
tagValue: "string",
}],
});
type: google-native:bigquery/v2:Dataset
properties:
access:
- dataset:
dataset:
datasetId: string
project: string
targetTypes:
- TARGET_TYPE_UNSPECIFIED
domain: string
groupByEmail: string
iamMember: string
role: string
routine:
datasetId: string
project: string
routineId: string
specialGroup: string
userByEmail: string
view:
datasetId: string
project: string
tableId: string
datasetReference:
datasetId: string
project: string
defaultEncryptionConfiguration:
kmsKeyName: string
defaultPartitionExpirationMs: string
defaultTableExpirationMs: string
description: string
externalDatasetReference:
connection: string
externalSource: string
friendlyName: string
isCaseInsensitive: false
labels:
string: string
location: string
maxTimeTravelHours: string
project: string
storageBillingModel: string
tags:
- tagKey: string
tagValue: string
Dataset 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 Dataset resource accepts the following input properties:
- Access
List<Pulumi.
Google Native. Big Query. V2. Inputs. Dataset Access Item> - [Optional] An array of objects that define dataset access for one or more entities. You can set this property when inserting or updating a dataset in order to control who is allowed to access the data. If unspecified at dataset creation time, BigQuery adds default dataset access for the following entities: access.specialGroup: projectReaders; access.role: READER; access.specialGroup: projectWriters; access.role: WRITER; access.specialGroup: projectOwners; access.role: OWNER; access.userByEmail: [dataset creator email]; access.role: OWNER;
- Dataset
Reference Pulumi.Google Native. Big Query. V2. Inputs. Dataset Reference - [Required] A reference that identifies the dataset.
- Default
Encryption Pulumi.Configuration Google Native. Big Query. V2. Inputs. Encryption Configuration - Default
Partition stringExpiration Ms - [Optional] The default partition expiration for all partitioned tables in the dataset, in milliseconds. Once this property is set, all newly-created partitioned tables in the dataset will have an expirationMs property in the timePartitioning settings set to this value, and changing the value will only affect new tables, not existing ones. The storage in a partition will have an expiration time of its partition time plus this value. Setting this property overrides the use of defaultTableExpirationMs for partitioned tables: only one of defaultTableExpirationMs and defaultPartitionExpirationMs will be used for any new partitioned table. If you provide an explicit timePartitioning.expirationMs when creating or updating a partitioned table, that value takes precedence over the default partition expiration time indicated by this property.
- Default
Table stringExpiration Ms - [Optional] The default lifetime of all tables in the dataset, in milliseconds. The minimum value is 3600000 milliseconds (one hour). Once this property is set, all newly-created tables in the dataset will have an expirationTime property set to the creation time plus the value in this property, and changing the value will only affect new tables, not existing ones. When the expirationTime for a given table is reached, that table will be deleted automatically. If a table's expirationTime is modified or removed before the table expires, or if you provide an explicit expirationTime when creating a table, that value takes precedence over the default expiration time indicated by this property.
- Description string
- [Optional] A user-friendly description of the dataset.
- External
Dataset Pulumi.Reference Google Native. Big Query. V2. Inputs. External Dataset Reference - [Optional] Information about the external metadata storage where the dataset is defined. Filled out when the dataset type is EXTERNAL.
- Friendly
Name string - [Optional] A descriptive name for the dataset.
- Is
Case boolInsensitive - [Optional] Indicates if table names are case insensitive in the dataset.
- Labels Dictionary<string, string>
- The labels associated with this dataset. You can use these to organize and group your datasets. You can set this property when inserting or updating a dataset. See Creating and Updating Dataset Labels for more information.
- Location string
- The geographic location where the dataset should reside. The default value is US. See details at https://cloud.google.com/bigquery/docs/locations.
- Max
Time stringTravel Hours - [Optional] Number of hours for the max time travel for all tables in the dataset.
- Project string
- Storage
Billing stringModel - [Optional] Storage billing model to be used for all tables in the dataset. Can be set to PHYSICAL. Default is LOGICAL.
- List<Pulumi.
Google Native. Big Query. V2. Inputs. Dataset Tags Item> - [Optional]The tags associated with this dataset. Tag keys are globally unique.
- Access
[]Dataset
Access Item Args - [Optional] An array of objects that define dataset access for one or more entities. You can set this property when inserting or updating a dataset in order to control who is allowed to access the data. If unspecified at dataset creation time, BigQuery adds default dataset access for the following entities: access.specialGroup: projectReaders; access.role: READER; access.specialGroup: projectWriters; access.role: WRITER; access.specialGroup: projectOwners; access.role: OWNER; access.userByEmail: [dataset creator email]; access.role: OWNER;
- Dataset
Reference DatasetReference Args - [Required] A reference that identifies the dataset.
- Default
Encryption EncryptionConfiguration Configuration Args - Default
Partition stringExpiration Ms - [Optional] The default partition expiration for all partitioned tables in the dataset, in milliseconds. Once this property is set, all newly-created partitioned tables in the dataset will have an expirationMs property in the timePartitioning settings set to this value, and changing the value will only affect new tables, not existing ones. The storage in a partition will have an expiration time of its partition time plus this value. Setting this property overrides the use of defaultTableExpirationMs for partitioned tables: only one of defaultTableExpirationMs and defaultPartitionExpirationMs will be used for any new partitioned table. If you provide an explicit timePartitioning.expirationMs when creating or updating a partitioned table, that value takes precedence over the default partition expiration time indicated by this property.
- Default
Table stringExpiration Ms - [Optional] The default lifetime of all tables in the dataset, in milliseconds. The minimum value is 3600000 milliseconds (one hour). Once this property is set, all newly-created tables in the dataset will have an expirationTime property set to the creation time plus the value in this property, and changing the value will only affect new tables, not existing ones. When the expirationTime for a given table is reached, that table will be deleted automatically. If a table's expirationTime is modified or removed before the table expires, or if you provide an explicit expirationTime when creating a table, that value takes precedence over the default expiration time indicated by this property.
- Description string
- [Optional] A user-friendly description of the dataset.
- External
Dataset ExternalReference Dataset Reference Args - [Optional] Information about the external metadata storage where the dataset is defined. Filled out when the dataset type is EXTERNAL.
- Friendly
Name string - [Optional] A descriptive name for the dataset.
- Is
Case boolInsensitive - [Optional] Indicates if table names are case insensitive in the dataset.
- Labels map[string]string
- The labels associated with this dataset. You can use these to organize and group your datasets. You can set this property when inserting or updating a dataset. See Creating and Updating Dataset Labels for more information.
- Location string
- The geographic location where the dataset should reside. The default value is US. See details at https://cloud.google.com/bigquery/docs/locations.
- Max
Time stringTravel Hours - [Optional] Number of hours for the max time travel for all tables in the dataset.
- Project string
- Storage
Billing stringModel - [Optional] Storage billing model to be used for all tables in the dataset. Can be set to PHYSICAL. Default is LOGICAL.
- []Dataset
Tags Item Args - [Optional]The tags associated with this dataset. Tag keys are globally unique.
- access
List<Dataset
Access Item> - [Optional] An array of objects that define dataset access for one or more entities. You can set this property when inserting or updating a dataset in order to control who is allowed to access the data. If unspecified at dataset creation time, BigQuery adds default dataset access for the following entities: access.specialGroup: projectReaders; access.role: READER; access.specialGroup: projectWriters; access.role: WRITER; access.specialGroup: projectOwners; access.role: OWNER; access.userByEmail: [dataset creator email]; access.role: OWNER;
- dataset
Reference DatasetReference - [Required] A reference that identifies the dataset.
- default
Encryption EncryptionConfiguration Configuration - default
Partition StringExpiration Ms - [Optional] The default partition expiration for all partitioned tables in the dataset, in milliseconds. Once this property is set, all newly-created partitioned tables in the dataset will have an expirationMs property in the timePartitioning settings set to this value, and changing the value will only affect new tables, not existing ones. The storage in a partition will have an expiration time of its partition time plus this value. Setting this property overrides the use of defaultTableExpirationMs for partitioned tables: only one of defaultTableExpirationMs and defaultPartitionExpirationMs will be used for any new partitioned table. If you provide an explicit timePartitioning.expirationMs when creating or updating a partitioned table, that value takes precedence over the default partition expiration time indicated by this property.
- default
Table StringExpiration Ms - [Optional] The default lifetime of all tables in the dataset, in milliseconds. The minimum value is 3600000 milliseconds (one hour). Once this property is set, all newly-created tables in the dataset will have an expirationTime property set to the creation time plus the value in this property, and changing the value will only affect new tables, not existing ones. When the expirationTime for a given table is reached, that table will be deleted automatically. If a table's expirationTime is modified or removed before the table expires, or if you provide an explicit expirationTime when creating a table, that value takes precedence over the default expiration time indicated by this property.
- description String
- [Optional] A user-friendly description of the dataset.
- external
Dataset ExternalReference Dataset Reference - [Optional] Information about the external metadata storage where the dataset is defined. Filled out when the dataset type is EXTERNAL.
- friendly
Name String - [Optional] A descriptive name for the dataset.
- is
Case BooleanInsensitive - [Optional] Indicates if table names are case insensitive in the dataset.
- labels Map<String,String>
- The labels associated with this dataset. You can use these to organize and group your datasets. You can set this property when inserting or updating a dataset. See Creating and Updating Dataset Labels for more information.
- location String
- The geographic location where the dataset should reside. The default value is US. See details at https://cloud.google.com/bigquery/docs/locations.
- max
Time StringTravel Hours - [Optional] Number of hours for the max time travel for all tables in the dataset.
- project String
- storage
Billing StringModel - [Optional] Storage billing model to be used for all tables in the dataset. Can be set to PHYSICAL. Default is LOGICAL.
- List<Dataset
Tags Item> - [Optional]The tags associated with this dataset. Tag keys are globally unique.
- access
Dataset
Access Item[] - [Optional] An array of objects that define dataset access for one or more entities. You can set this property when inserting or updating a dataset in order to control who is allowed to access the data. If unspecified at dataset creation time, BigQuery adds default dataset access for the following entities: access.specialGroup: projectReaders; access.role: READER; access.specialGroup: projectWriters; access.role: WRITER; access.specialGroup: projectOwners; access.role: OWNER; access.userByEmail: [dataset creator email]; access.role: OWNER;
- dataset
Reference DatasetReference - [Required] A reference that identifies the dataset.
- default
Encryption EncryptionConfiguration Configuration - default
Partition stringExpiration Ms - [Optional] The default partition expiration for all partitioned tables in the dataset, in milliseconds. Once this property is set, all newly-created partitioned tables in the dataset will have an expirationMs property in the timePartitioning settings set to this value, and changing the value will only affect new tables, not existing ones. The storage in a partition will have an expiration time of its partition time plus this value. Setting this property overrides the use of defaultTableExpirationMs for partitioned tables: only one of defaultTableExpirationMs and defaultPartitionExpirationMs will be used for any new partitioned table. If you provide an explicit timePartitioning.expirationMs when creating or updating a partitioned table, that value takes precedence over the default partition expiration time indicated by this property.
- default
Table stringExpiration Ms - [Optional] The default lifetime of all tables in the dataset, in milliseconds. The minimum value is 3600000 milliseconds (one hour). Once this property is set, all newly-created tables in the dataset will have an expirationTime property set to the creation time plus the value in this property, and changing the value will only affect new tables, not existing ones. When the expirationTime for a given table is reached, that table will be deleted automatically. If a table's expirationTime is modified or removed before the table expires, or if you provide an explicit expirationTime when creating a table, that value takes precedence over the default expiration time indicated by this property.
- description string
- [Optional] A user-friendly description of the dataset.
- external
Dataset ExternalReference Dataset Reference - [Optional] Information about the external metadata storage where the dataset is defined. Filled out when the dataset type is EXTERNAL.
- friendly
Name string - [Optional] A descriptive name for the dataset.
- is
Case booleanInsensitive - [Optional] Indicates if table names are case insensitive in the dataset.
- labels {[key: string]: string}
- The labels associated with this dataset. You can use these to organize and group your datasets. You can set this property when inserting or updating a dataset. See Creating and Updating Dataset Labels for more information.
- location string
- The geographic location where the dataset should reside. The default value is US. See details at https://cloud.google.com/bigquery/docs/locations.
- max
Time stringTravel Hours - [Optional] Number of hours for the max time travel for all tables in the dataset.
- project string
- storage
Billing stringModel - [Optional] Storage billing model to be used for all tables in the dataset. Can be set to PHYSICAL. Default is LOGICAL.
- Dataset
Tags Item[] - [Optional]The tags associated with this dataset. Tag keys are globally unique.
- access
Sequence[Dataset
Access Item Args] - [Optional] An array of objects that define dataset access for one or more entities. You can set this property when inserting or updating a dataset in order to control who is allowed to access the data. If unspecified at dataset creation time, BigQuery adds default dataset access for the following entities: access.specialGroup: projectReaders; access.role: READER; access.specialGroup: projectWriters; access.role: WRITER; access.specialGroup: projectOwners; access.role: OWNER; access.userByEmail: [dataset creator email]; access.role: OWNER;
- dataset_
reference DatasetReference Args - [Required] A reference that identifies the dataset.
- default_
encryption_ Encryptionconfiguration Configuration Args - default_
partition_ strexpiration_ ms - [Optional] The default partition expiration for all partitioned tables in the dataset, in milliseconds. Once this property is set, all newly-created partitioned tables in the dataset will have an expirationMs property in the timePartitioning settings set to this value, and changing the value will only affect new tables, not existing ones. The storage in a partition will have an expiration time of its partition time plus this value. Setting this property overrides the use of defaultTableExpirationMs for partitioned tables: only one of defaultTableExpirationMs and defaultPartitionExpirationMs will be used for any new partitioned table. If you provide an explicit timePartitioning.expirationMs when creating or updating a partitioned table, that value takes precedence over the default partition expiration time indicated by this property.
- default_
table_ strexpiration_ ms - [Optional] The default lifetime of all tables in the dataset, in milliseconds. The minimum value is 3600000 milliseconds (one hour). Once this property is set, all newly-created tables in the dataset will have an expirationTime property set to the creation time plus the value in this property, and changing the value will only affect new tables, not existing ones. When the expirationTime for a given table is reached, that table will be deleted automatically. If a table's expirationTime is modified or removed before the table expires, or if you provide an explicit expirationTime when creating a table, that value takes precedence over the default expiration time indicated by this property.
- description str
- [Optional] A user-friendly description of the dataset.
- external_
dataset_ Externalreference Dataset Reference Args - [Optional] Information about the external metadata storage where the dataset is defined. Filled out when the dataset type is EXTERNAL.
- friendly_
name str - [Optional] A descriptive name for the dataset.
- is_
case_ boolinsensitive - [Optional] Indicates if table names are case insensitive in the dataset.
- labels Mapping[str, str]
- The labels associated with this dataset. You can use these to organize and group your datasets. You can set this property when inserting or updating a dataset. See Creating and Updating Dataset Labels for more information.
- location str
- The geographic location where the dataset should reside. The default value is US. See details at https://cloud.google.com/bigquery/docs/locations.
- max_
time_ strtravel_ hours - [Optional] Number of hours for the max time travel for all tables in the dataset.
- project str
- storage_
billing_ strmodel - [Optional] Storage billing model to be used for all tables in the dataset. Can be set to PHYSICAL. Default is LOGICAL.
- Sequence[Dataset
Tags Item Args] - [Optional]The tags associated with this dataset. Tag keys are globally unique.
- access List<Property Map>
- [Optional] An array of objects that define dataset access for one or more entities. You can set this property when inserting or updating a dataset in order to control who is allowed to access the data. If unspecified at dataset creation time, BigQuery adds default dataset access for the following entities: access.specialGroup: projectReaders; access.role: READER; access.specialGroup: projectWriters; access.role: WRITER; access.specialGroup: projectOwners; access.role: OWNER; access.userByEmail: [dataset creator email]; access.role: OWNER;
- dataset
Reference Property Map - [Required] A reference that identifies the dataset.
- default
Encryption Property MapConfiguration - default
Partition StringExpiration Ms - [Optional] The default partition expiration for all partitioned tables in the dataset, in milliseconds. Once this property is set, all newly-created partitioned tables in the dataset will have an expirationMs property in the timePartitioning settings set to this value, and changing the value will only affect new tables, not existing ones. The storage in a partition will have an expiration time of its partition time plus this value. Setting this property overrides the use of defaultTableExpirationMs for partitioned tables: only one of defaultTableExpirationMs and defaultPartitionExpirationMs will be used for any new partitioned table. If you provide an explicit timePartitioning.expirationMs when creating or updating a partitioned table, that value takes precedence over the default partition expiration time indicated by this property.
- default
Table StringExpiration Ms - [Optional] The default lifetime of all tables in the dataset, in milliseconds. The minimum value is 3600000 milliseconds (one hour). Once this property is set, all newly-created tables in the dataset will have an expirationTime property set to the creation time plus the value in this property, and changing the value will only affect new tables, not existing ones. When the expirationTime for a given table is reached, that table will be deleted automatically. If a table's expirationTime is modified or removed before the table expires, or if you provide an explicit expirationTime when creating a table, that value takes precedence over the default expiration time indicated by this property.
- description String
- [Optional] A user-friendly description of the dataset.
- external
Dataset Property MapReference - [Optional] Information about the external metadata storage where the dataset is defined. Filled out when the dataset type is EXTERNAL.
- friendly
Name String - [Optional] A descriptive name for the dataset.
- is
Case BooleanInsensitive - [Optional] Indicates if table names are case insensitive in the dataset.
- labels Map<String>
- The labels associated with this dataset. You can use these to organize and group your datasets. You can set this property when inserting or updating a dataset. See Creating and Updating Dataset Labels for more information.
- location String
- The geographic location where the dataset should reside. The default value is US. See details at https://cloud.google.com/bigquery/docs/locations.
- max
Time StringTravel Hours - [Optional] Number of hours for the max time travel for all tables in the dataset.
- project String
- storage
Billing StringModel - [Optional] Storage billing model to be used for all tables in the dataset. Can be set to PHYSICAL. Default is LOGICAL.
- List<Property Map>
- [Optional]The tags associated with this dataset. Tag keys are globally unique.
Outputs
All input properties are implicitly available as output properties. Additionally, the Dataset resource produces the following output properties:
- Creation
Time string - The time when this dataset was created, in milliseconds since the epoch.
- Default
Collation string - The default collation of the dataset.
- Default
Rounding stringMode - The default rounding mode of the dataset.
- Etag string
- A hash of the resource.
- Id string
- The provider-assigned unique ID for this managed resource.
- Kind string
- The resource type.
- Last
Modified stringTime - The date when this dataset or any of its tables was last modified, in milliseconds since the epoch.
- Satisfies
Pzs bool - Reserved for future use.
- Self
Link string - A URL that can be used to access the resource again. You can use this URL in Get or Update requests to the resource.
- Creation
Time string - The time when this dataset was created, in milliseconds since the epoch.
- Default
Collation string - The default collation of the dataset.
- Default
Rounding stringMode - The default rounding mode of the dataset.
- Etag string
- A hash of the resource.
- Id string
- The provider-assigned unique ID for this managed resource.
- Kind string
- The resource type.
- Last
Modified stringTime - The date when this dataset or any of its tables was last modified, in milliseconds since the epoch.
- Satisfies
Pzs bool - Reserved for future use.
- Self
Link string - A URL that can be used to access the resource again. You can use this URL in Get or Update requests to the resource.
- creation
Time String - The time when this dataset was created, in milliseconds since the epoch.
- default
Collation String - The default collation of the dataset.
- default
Rounding StringMode - The default rounding mode of the dataset.
- etag String
- A hash of the resource.
- id String
- The provider-assigned unique ID for this managed resource.
- kind String
- The resource type.
- last
Modified StringTime - The date when this dataset or any of its tables was last modified, in milliseconds since the epoch.
- satisfies
Pzs Boolean - Reserved for future use.
- self
Link String - A URL that can be used to access the resource again. You can use this URL in Get or Update requests to the resource.
- creation
Time string - The time when this dataset was created, in milliseconds since the epoch.
- default
Collation string - The default collation of the dataset.
- default
Rounding stringMode - The default rounding mode of the dataset.
- etag string
- A hash of the resource.
- id string
- The provider-assigned unique ID for this managed resource.
- kind string
- The resource type.
- last
Modified stringTime - The date when this dataset or any of its tables was last modified, in milliseconds since the epoch.
- satisfies
Pzs boolean - Reserved for future use.
- self
Link string - A URL that can be used to access the resource again. You can use this URL in Get or Update requests to the resource.
- creation_
time str - The time when this dataset was created, in milliseconds since the epoch.
- default_
collation str - The default collation of the dataset.
- default_
rounding_ strmode - The default rounding mode of the dataset.
- etag str
- A hash of the resource.
- id str
- The provider-assigned unique ID for this managed resource.
- kind str
- The resource type.
- last_
modified_ strtime - The date when this dataset or any of its tables was last modified, in milliseconds since the epoch.
- satisfies_
pzs bool - Reserved for future use.
- self_
link str - A URL that can be used to access the resource again. You can use this URL in Get or Update requests to the resource.
- creation
Time String - The time when this dataset was created, in milliseconds since the epoch.
- default
Collation String - The default collation of the dataset.
- default
Rounding StringMode - The default rounding mode of the dataset.
- etag String
- A hash of the resource.
- id String
- The provider-assigned unique ID for this managed resource.
- kind String
- The resource type.
- last
Modified StringTime - The date when this dataset or any of its tables was last modified, in milliseconds since the epoch.
- satisfies
Pzs Boolean - Reserved for future use.
- self
Link String - A URL that can be used to access the resource again. You can use this URL in Get or Update requests to the resource.
Supporting Types
DatasetAccessEntry, DatasetAccessEntryArgs
- Dataset
Pulumi.
Google Native. Big Query. V2. Inputs. Dataset Reference - [Required] The dataset this entry applies to.
- Target
Types List<Pulumi.Google Native. Big Query. V2. Dataset Access Entry Target Types Item>
- Dataset
Dataset
Reference - [Required] The dataset this entry applies to.
- Target
Types []DatasetAccess Entry Target Types Item
- dataset
Dataset
Reference - [Required] The dataset this entry applies to.
- target
Types List<DatasetAccess Entry Target Types Item>
- dataset
Dataset
Reference - [Required] The dataset this entry applies to.
- target
Types DatasetAccess Entry Target Types Item[]
- dataset
Dataset
Reference - [Required] The dataset this entry applies to.
- target_
types Sequence[DatasetAccess Entry Target Types Item]
- dataset Property Map
- [Required] The dataset this entry applies to.
- target
Types List<"TARGET_TYPE_UNSPECIFIED" | "VIEWS" | "ROUTINES">
DatasetAccessEntryResponse, DatasetAccessEntryResponseArgs
- Dataset
Pulumi.
Google Native. Big Query. V2. Inputs. Dataset Reference Response - [Required] The dataset this entry applies to.
- Target
Types List<string>
- Dataset
Dataset
Reference Response - [Required] The dataset this entry applies to.
- Target
Types []string
- dataset
Dataset
Reference Response - [Required] The dataset this entry applies to.
- target
Types List<String>
- dataset
Dataset
Reference Response - [Required] The dataset this entry applies to.
- target
Types string[]
- dataset
Dataset
Reference Response - [Required] The dataset this entry applies to.
- target_
types Sequence[str]
- dataset Property Map
- [Required] The dataset this entry applies to.
- target
Types List<String>
DatasetAccessEntryTargetTypesItem, DatasetAccessEntryTargetTypesItemArgs
- Target
Type Unspecified - TARGET_TYPE_UNSPECIFIEDDo not use. You must set a target type explicitly.
- Views
- VIEWSThis entry applies to views in the dataset.
- Routines
- ROUTINESThis entry applies to routines in the dataset.
- Dataset
Access Entry Target Types Item Target Type Unspecified - TARGET_TYPE_UNSPECIFIEDDo not use. You must set a target type explicitly.
- Dataset
Access Entry Target Types Item Views - VIEWSThis entry applies to views in the dataset.
- Dataset
Access Entry Target Types Item Routines - ROUTINESThis entry applies to routines in the dataset.
- Target
Type Unspecified - TARGET_TYPE_UNSPECIFIEDDo not use. You must set a target type explicitly.
- Views
- VIEWSThis entry applies to views in the dataset.
- Routines
- ROUTINESThis entry applies to routines in the dataset.
- Target
Type Unspecified - TARGET_TYPE_UNSPECIFIEDDo not use. You must set a target type explicitly.
- Views
- VIEWSThis entry applies to views in the dataset.
- Routines
- ROUTINESThis entry applies to routines in the dataset.
- TARGET_TYPE_UNSPECIFIED
- TARGET_TYPE_UNSPECIFIEDDo not use. You must set a target type explicitly.
- VIEWS
- VIEWSThis entry applies to views in the dataset.
- ROUTINES
- ROUTINESThis entry applies to routines in the dataset.
- "TARGET_TYPE_UNSPECIFIED"
- TARGET_TYPE_UNSPECIFIEDDo not use. You must set a target type explicitly.
- "VIEWS"
- VIEWSThis entry applies to views in the dataset.
- "ROUTINES"
- ROUTINESThis entry applies to routines in the dataset.
DatasetAccessItem, DatasetAccessItemArgs
- Dataset
Pulumi.
Google Native. Big Query. V2. Inputs. Dataset Access Entry - [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- Domain string
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- Group
By stringEmail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- Iam
Member string - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- Role string
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- Routine
Pulumi.
Google Native. Big Query. V2. Inputs. Routine Reference - [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- Special
Group string - [Pick one] 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. Maps to similarly-named IAM members.
- User
By stringEmail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- View
Pulumi.
Google Native. Big Query. V2. Inputs. Table Reference - [Pick one] 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.
- Dataset
Dataset
Access Entry - [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- Domain string
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- Group
By stringEmail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- Iam
Member string - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- Role string
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- Routine
Routine
Reference - [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- Special
Group string - [Pick one] 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. Maps to similarly-named IAM members.
- User
By stringEmail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- View
Table
Reference - [Pick one] 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.
- dataset
Dataset
Access Entry - [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- domain String
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- group
By StringEmail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- iam
Member String - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- role String
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- routine
Routine
Reference - [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- special
Group String - [Pick one] 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. Maps to similarly-named IAM members.
- user
By StringEmail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- view
Table
Reference - [Pick one] 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.
- dataset
Dataset
Access Entry - [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- domain string
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- group
By stringEmail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- iam
Member string - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- role string
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- routine
Routine
Reference - [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- special
Group string - [Pick one] 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. Maps to similarly-named IAM members.
- user
By stringEmail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- view
Table
Reference - [Pick one] 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.
- dataset
Dataset
Access Entry - [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- domain str
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- group_
by_ stremail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- iam_
member str - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- role str
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- routine
Routine
Reference - [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- special_
group str - [Pick one] 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. Maps to similarly-named IAM members.
- user_
by_ stremail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- view
Table
Reference - [Pick one] 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.
- dataset Property Map
- [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- domain String
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- group
By StringEmail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- iam
Member String - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- role String
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- routine Property Map
- [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- special
Group String - [Pick one] 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. Maps to similarly-named IAM members.
- user
By StringEmail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- view Property Map
- [Pick one] 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.
DatasetAccessItemResponse, DatasetAccessItemResponseArgs
- Dataset
Pulumi.
Google Native. Big Query. V2. Inputs. Dataset Access Entry Response - [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- Domain string
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- Group
By stringEmail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- Iam
Member string - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- Role string
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- Routine
Pulumi.
Google Native. Big Query. V2. Inputs. Routine Reference Response - [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- Special
Group string - [Pick one] 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. Maps to similarly-named IAM members.
- User
By stringEmail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- View
Pulumi.
Google Native. Big Query. V2. Inputs. Table Reference Response - [Pick one] 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.
- Dataset
Dataset
Access Entry Response - [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- Domain string
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- Group
By stringEmail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- Iam
Member string - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- Role string
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- Routine
Routine
Reference Response - [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- Special
Group string - [Pick one] 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. Maps to similarly-named IAM members.
- User
By stringEmail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- View
Table
Reference Response - [Pick one] 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.
- dataset
Dataset
Access Entry Response - [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- domain String
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- group
By StringEmail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- iam
Member String - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- role String
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- routine
Routine
Reference Response - [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- special
Group String - [Pick one] 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. Maps to similarly-named IAM members.
- user
By StringEmail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- view
Table
Reference Response - [Pick one] 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.
- dataset
Dataset
Access Entry Response - [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- domain string
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- group
By stringEmail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- iam
Member string - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- role string
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- routine
Routine
Reference Response - [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- special
Group string - [Pick one] 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. Maps to similarly-named IAM members.
- user
By stringEmail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- view
Table
Reference Response - [Pick one] 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.
- dataset
Dataset
Access Entry Response - [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- domain str
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- group_
by_ stremail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- iam_
member str - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- role str
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- routine
Routine
Reference Response - [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- special_
group str - [Pick one] 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. Maps to similarly-named IAM members.
- user_
by_ stremail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- view
Table
Reference Response - [Pick one] 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.
- dataset Property Map
- [Pick one] A grant authorizing all resources of a particular type in a particular dataset access to this dataset. Only views are supported for now. The role field is not required when this field is set. If that dataset is deleted and re-created, its access needs to be granted again via an update operation.
- domain String
- [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". Maps to IAM policy member "domain:DOMAIN".
- group
By StringEmail - [Pick one] An email address of a Google Group to grant access to. Maps to IAM policy member "group:GROUP".
- iam
Member String - [Pick one] Some other type of member that appears in the IAM Policy but isn't a user, group, domain, or special group.
- role String
- [Required] An IAM role ID that should be granted to the user, group, or domain specified in this access entry. The following legacy mappings will be applied: OWNER roles/bigquery.dataOwner WRITER roles/bigquery.dataEditor READER roles/bigquery.dataViewer This field will accept any of the above formats, but will return only the legacy format. For example, if you set this field to "roles/bigquery.dataOwner", it will be returned back as "OWNER".
- routine Property Map
- [Pick one] A routine from a different dataset to grant access to. Queries executed against that routine will have read access to views/tables/routines in this dataset. Only UDF is supported for now. 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.
- special
Group String - [Pick one] 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. Maps to similarly-named IAM members.
- user
By StringEmail - [Pick one] An email address of a user to grant access to. For example: fred@example.com. Maps to IAM policy member "user:EMAIL" or "serviceAccount:EMAIL".
- view Property Map
- [Pick one] 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.
DatasetReference, DatasetReferenceArgs
- dataset_
id str - [Required] 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.
- project str
- [Optional] The ID of the project containing this dataset.
DatasetReferenceResponse, DatasetReferenceResponseArgs
- dataset_
id str - [Required] 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.
- project str
- [Optional] The ID of the project containing this dataset.
DatasetTagsItem, DatasetTagsItemArgs
DatasetTagsItemResponse, DatasetTagsItemResponseArgs
EncryptionConfiguration, EncryptionConfigurationArgs
- Kms
Key stringName - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
- Kms
Key stringName - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
- kms
Key StringName - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
- kms
Key stringName - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
- kms_
key_ strname - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
- kms
Key StringName - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
EncryptionConfigurationResponse, EncryptionConfigurationResponseArgs
- Kms
Key stringName - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
- Kms
Key stringName - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
- kms
Key StringName - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
- kms
Key stringName - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
- kms_
key_ strname - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
- kms
Key StringName - Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
ExternalDatasetReference, ExternalDatasetReferenceArgs
- Connection string
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- External
Source string - [Required] External source that backs this dataset.
- Connection string
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- External
Source string - [Required] External source that backs this dataset.
- connection String
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- external
Source String - [Required] External source that backs this dataset.
- connection string
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- external
Source string - [Required] External source that backs this dataset.
- connection str
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- external_
source str - [Required] External source that backs this dataset.
- connection String
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- external
Source String - [Required] External source that backs this dataset.
ExternalDatasetReferenceResponse, ExternalDatasetReferenceResponseArgs
- Connection string
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- External
Source string - [Required] External source that backs this dataset.
- Connection string
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- External
Source string - [Required] External source that backs this dataset.
- connection String
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- external
Source String - [Required] External source that backs this dataset.
- connection string
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- external
Source string - [Required] External source that backs this dataset.
- connection str
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- external_
source str - [Required] External source that backs this dataset.
- connection String
- [Required] The connection id that is used to access the external_source. Format: projects/{project_id}/locations/{location_id}/connections/{connection_id}
- external
Source String - [Required] External source that backs this dataset.
RoutineReference, RoutineReferenceArgs
- dataset_
id str - The ID of the dataset containing this routine.
- project str
- The ID of the project containing this routine.
- 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.
RoutineReferenceResponse, RoutineReferenceResponseArgs
- dataset_
id str - The ID of the dataset containing this routine.
- project str
- The ID of the project containing this routine.
- 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.
TableReference, TableReferenceArgs
- Dataset
Id string - [Required] The ID of the dataset containing this table.
- Project string
- [Required] The ID of the project containing this table.
- Table
Id string - [Required] 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 string - [Required] The ID of the dataset containing this table.
- Project string
- [Required] The ID of the project containing this table.
- Table
Id string - [Required] 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 String - [Required] The ID of the dataset containing this table.
- project String
- [Required] The ID of the project containing this table.
- table
Id String - [Required] 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 string - [Required] The ID of the dataset containing this table.
- project string
- [Required] The ID of the project containing this table.
- table
Id string - [Required] 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 - [Required] The ID of the dataset containing this table.
- project str
- [Required] The ID of the project containing this table.
- table_
id str - [Required] 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 String - [Required] The ID of the dataset containing this table.
- project String
- [Required] The ID of the project containing this table.
- table
Id String - [Required] 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.
TableReferenceResponse, TableReferenceResponseArgs
- Dataset
Id string - [Required] The ID of the dataset containing this table.
- Project string
- [Required] The ID of the project containing this table.
- Table
Id string - [Required] 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 string - [Required] The ID of the dataset containing this table.
- Project string
- [Required] The ID of the project containing this table.
- Table
Id string - [Required] 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 String - [Required] The ID of the dataset containing this table.
- project String
- [Required] The ID of the project containing this table.
- table
Id String - [Required] 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 string - [Required] The ID of the dataset containing this table.
- project string
- [Required] The ID of the project containing this table.
- table
Id string - [Required] 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 - [Required] The ID of the dataset containing this table.
- project str
- [Required] The ID of the project containing this table.
- table_
id str - [Required] 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 String - [Required] The ID of the dataset containing this table.
- project String
- [Required] The ID of the project containing this table.
- table
Id String - [Required] 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.
Package Details
- Repository
- Google Cloud Native pulumi/pulumi-google-native
- License
- Apache-2.0
Google Cloud Native is in preview. Google Cloud Classic is fully supported.