Actions
Update BigQuery Table
Updates information in an existing table. The update method replaces the entire table resource, whereas the patch method only replaces fields that are provided in the submitted table resource.
External Documentation
To learn more, visit the GCP documentation.
Basic Parameters
Parameter | Description |
---|---|
Dataset ID | Dataset ID of the table to update. |
Project ID | Project ID of the table to update. |
Table ID | Table ID of the table to update. |
Advanced Parameters
Parameter | Description |
---|---|
Clustering Fields | [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data. |
Default Collation | [Output-only] The default collation of the table. |
Description | [Optional] A user-friendly description of this table. |
Encryption Configuration Kms Key Name | [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. |
Expiration Time | [Optional] The time when this table expires, in milliseconds since the epoch. If not present, the table will persist indefinitely. Expired tables will be deleted and their storage reclaimed. The defaultTableExpirationMs property of the encapsulating dataset can be used to set a default expirationTime on newly created tables. |
External Data Configuration | Optional.Describes the data format, location, and other properties of a table stored outside of BigQuery.By defining these properties, the data source can then be queried as if it were a standard BigQuery table.For information on how to format the object, go to https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#ExternalDataConfiguration |
Friendly Name | [Optional] A descriptive name for this table. |
Kind | [Output-only] The type of the resource. |
Labels | The labels associated with this table. You can use these to organize and group your tables. 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 values are optional. Label keys must start with a letter and each label in the list must have a different key. |
Materialized View Enable Refresh | [Optional] [TrustedTester] Enable automatic refresh of the materialized view when the base table is updated. The default value is “true”. |
Materialized View Query | [Required] A query whose result is persisted. |
Materialized View Refresh Interval Ms | [Optional] [TrustedTester] The maximum frequency at which this materialized view will be refreshed. The default value is “1800000” (30 minutes). |
Require Partition Filter | [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. |
Schema Fields | Describes the fields in a table. |
Table Reference Dataset ID | [Required] The ID of the dataset containing this table. |
Table Reference Project ID | [Required] The ID of the project containing this table. |
Table Reference Table ID | [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. |
Time Partitioning Expiration Ms | [Optional] 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. |
Time Partitioning Field | [Beta] [Optional] 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. |
Time Partitioning Type | [Required] The supported types are DAY, HOUR, MONTH, and YEAR, which will generate one partition per day, hour, month, and year, respectively. When the type is not specified, the default behavior is DAY. |
View Query | [Required] A query that BigQuery executes when the view is referenced. |
View Use Legacy Sql | Specifies whether to use BigQuery’s legacy SQL for this view. The default value is true. If set to false, the view will use BigQuery’s standard SQL: https://cloud.google.com/bigquery/sql-reference/ Queries and views that reference this view must use the same flag value. |
View User Defined Function Resources | Describes user-defined function resources used in the query. |
Example Output
Workflow Library Example
Update Bigquery Table with Gcp and Send Results Via Email
Preview this Workflow on desktop
Was this page helpful?