Frends.GoogleBigQuery.PatchResource / 2.0.0

Resource type.

Possible values:

• Dataset: The dataset resource.
• Table: The table resource.

Resource description. (Optional)

Friendly name for Dataset or Table resource. (Optional)

The geographic location where the resource should reside. See details at https://cloud.google.com/bigquery/docs/locations

Label(s) for Dataset or Table resource. (Optional) Label keys and values can be no longer than 63 characters, can only contain lowercase letters, numeric characters, underscores and dashes. International characters are allowed. Label keys must start with a letter and each label in the list must have a different key.

Set Dataset or Table encryption configuration.

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.

Storage billing model to be used for all tables in the dataset. Can be set to PHYSICAL.

Indicates if table names are case insensitive in the dataset.

Number of hours for the max time travel for all tables in the dataset. Unlimited if 0.

An array of objects that define dataset access for one or more entities. (Optional) 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;

The tags associated with this dataset. (Optional) Tag keys are globally unique.

If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified.

Describes the schema of this table.

Partition option.

Possible values:

• None: Hide options from UI.

• RangePartitioning: Range partitioning specification for this table.

• TimePartitioning: Time-based partitioning specification for this table.

The table is partitioned by this field. The field must be a top-level NULLABLE/REQUIRED field. The only supported type is INTEGER/INT64.

The start of range partitioning, inclusive

The end of range partitioning, exclusive.

The width of each interval.

If not set, the table is partitioned by pseudo column, referenced via either '_PARTITIONTIME' as TIMESTAMP type, or '_PARTITIONDATE' as DATE type. If field is specified, the table is instead partitioned by this field. The field must be a top-level TIMESTAMP or DATE field. Its mode must be NULLABLE or REQUIRED.

Generate one partition per day, hour, month, or year.

Possible values:

• DAY: Partition by day.
• HOUR: Partition by hour.
• MONTH: Partition by month.
• YEAR: Partition by year.

RequirePartitionFilter

Number of milliseconds for which to keep the storage for partitions in the table. The storage in a partition will have an expiration time of its partition time plus this value.