UpdateTable
Update table metadata
type: "io.kestra.plugin.gcp.bigquery.UpdateTable"id: gcp_bq_update_table
namespace: company.team
tasks:
- id: update_table
type: io.kestra.plugin.gcp.bigquery.UpdateTable
projectId: my-project
dataset: my-dataset
table: my-table
expirationDuration: PT48H
YESThe dataset's user-defined ID.
YESThe table's user-defined ID.
YESThe user-friendly description for the table.
NOThe encryption configuration.
YESdurationSets the duration, since now, when this table expires.
If not present, the table will persist indefinitely. Expired tables will be deleted and their storage reclaimed.
YESThe user-friendly name for the table.
YESThe GCP service account to impersonate.
YESReturn a map for labels applied to the table.
YESThe geographic location where the dataset should reside.
This property is experimental and might be subject to change or removed.
See Dataset Location
YESThe GCP project ID.
YESNOYES["due to concurrent update","Retrying the job may solve the problem"]The messages which would trigger an automatic retry.
Message is tested as a substring of the full message, and is case insensitive.
YES["rateLimitExceeded","jobBackendError","internalError","jobInternalError"]The reasons which would trigger an automatic retry.
YES["https://www.googleapis.com/auth/cloud-platform"]The GCP scopes to be used.
YESThe GCP service account.
NOThe table definition.
date-timeThe time when this table was created.
The dataset's ID.
The table definition.
The user-friendly description for the table.
The encryption configuration.
The hash of the table resource.
date-timeReturns the time when this table expires.
If not present, the table will persist indefinitely. Expired tables will be deleted and their storage reclaimed.
The user-friendly name for the table.
The service-generated id for the table.
Return a map for labels applied to the table.
date-timeThe time when this table was last modified.
The size of this table in bytes.
The number of bytes considered "long-term storage" for reduced billing purposes.
The number of rows of data in this table.
The project's ID.
Return true if a partition filter (that can be used for partition elimination) is required for queries over this table.
The URL that can be used to access the resource again. The returned URL can be used for get or update requests.
The table name.
NOdurationNORETRY_FAILED_TASKRETRY_FAILED_TASKCREATE_NEW_EXECUTIONNO >= 1NOdurationNOconstantNOfalseNOThe external table definition if the type is EXTERNAL.
NOThe materialized view definition if the type is MATERIALIZED_VIEW.
NOThe table's schema.
NOThe table definition if the type is TABLE.
NOThe view definition if the type is VIEW.
NOYESReturns the clustering configuration for this table. If {@code null}, the table is not clustered.
NOReturns the range partitioning configuration for this table. If {@code null}, the table is not range-partitioned.
NOReturns information on the table's streaming buffer, if exists. Returns {@code null} if no streaming buffer exists.
NOReturns the time partitioning configuration for this table. If {@code null}, the table is not time-partitioned.
NOdurationNOdurationNORETRY_FAILED_TASKRETRY_FAILED_TASKCREATE_NEW_EXECUTIONNONO >= 1NOdurationNOexponentialNOfalseNONONOYESYESYESNOdurationNOdurationNORETRY_FAILED_TASKRETRY_FAILED_TASKCREATE_NEW_EXECUTIONNO >= 1NOdurationNOrandomNOfalseNONONONONOTABLEVIEWMATERIALIZED_VIEWEXTERNALMODELNONOYESNONOdate-timeNONOdurationNONOYESNOYESNOdate-timeDate when this materialized view was last modified.
YESThe query whose result is persisted.
YESdurationThe maximum frequency at which this materialized view will be refreshed.
YESdurationThe number of milliseconds for which to keep the storage for a partition. When expired, the storage for the partition is reclaimed. If null, the partition does not expire.
YESIf not set, the table is partitioned by pseudo column '_PARTITIONTIME'; if set, the table is partitioned by this field.
YESYESThe field description.
YESNULLABLEREQUIREDREPEATEDThe field mode.
By default, Field.Mode.NULLABLE is used.
YESThe field name.
NOThe policy tags for the field.
YESINLINEFROM_URIYESIf type is UserDefinedFunction.Type.INLINE, this method returns a code blob.
If type is UserDefinedFunction.Type.FROM_URI, the method returns a Google Cloud Storage URI (e.g. gs://bucket/path).
YESYESThe compression type of the data source.
YESCSVJSONBIGTABLEDATASTORE_BACKUPAVROGOOGLE_SHEETSPARQUETORCThe source format, and possibly some parsing options, of the external data.
YESYESYESThe fully-qualified URIs that point to your data in Google Cloud Storage.
Each URI can
- contain one '*' wildcard character that must come after the bucket's name. Size limits related
- to load jobs apply to external data sources, plus an additional limit of 10 GB maximum size
- across all URIs.
NONONONOdurationNONONODAYHOURMONTHYEARNONOINLINEFROM_URINONONOCSVJSONBIGTABLEDATASTORE_BACKUPAVROGOOGLE_SHEETSPARQUETORCNONONONONONONO