UpdateTableUpdateTable
UpdateTableCertified

yaml
type: "io.kestra.plugin.gcp.bigquery.UpdateTable"
yaml
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
Properties
Definitions
The KMS key name.string
Formatduration
SubTypestring
Definitions
interval*Requiredstring
Formatduration
type*Requiredobject
behaviorstring
DefaultRETRY_FAILED_TASK
Possible Values
RETRY_FAILED_TASKCREATE_NEW_EXECUTION
maxAttemptsinteger
Minimum>= 1
maxDurationstring
Formatduration
warningOnRetryboolean
Defaultfalse
interval*Requiredstring
Formatduration
maxInterval*Requiredstring
Formatduration
type*Requiredobject
behaviorstring
DefaultRETRY_FAILED_TASK
Possible Values
RETRY_FAILED_TASKCREATE_NEW_EXECUTION
delayFactornumber
maxAttemptsinteger
Minimum>= 1
maxDurationstring
Formatduration
warningOnRetryboolean
Defaultfalse
maxInterval*Requiredstring
Formatduration
minInterval*Requiredstring
Formatduration
type*Requiredobject
behaviorstring
DefaultRETRY_FAILED_TASK
Possible Values
RETRY_FAILED_TASKCREATE_NEW_EXECUTION
maxAttemptsinteger
Minimum>= 1
maxDurationstring
Formatduration
warningOnRetryboolean
Defaultfalse
SubTypestring
Default["due to concurrent update","Retrying the job may solve the problem","Retrying may solve the problem"]
SubTypestring
Default["rateLimitExceeded","jobBackendError","backendError","internalError","jobInternalError"]
SubTypestring
Default["https://www.googleapis.com/auth/cloud-platform"]
Definitions
externalTableDefinition
autodetectbooleanstring
compressionstring
formatTypestring
Possible Values
CSVJSONBIGTABLEDATASTORE_BACKUPAVROGOOGLE_SHEETSPARQUETORC
ignoreUnknownValuesbooleanstring
maxBadRecordsintegerstring
sourceUrisarray
SubTypestring
materializedViewDefinition
enableRefreshbooleanstring
lastRefreshDatestring
Formatdate-time
querystring
refreshIntervalstring
Formatduration
schema
The fields associated with this schema.array
descriptionstring
modestring
Possible Values
NULLABLEREQUIREDREPEATED
namestring
policyTags
subFieldsarray
typestring
Possible Values
BOOLINT64FLOAT64NUMERICBIGNUMERICSTRINGBYTESSTRUCTARRAYTIMESTAMPDATETIMEDATETIMEGEOGRAPHYJSONINTERVALRANGE
standardTableDefinition
clusteringarray
SubTypestring
rangePartitioning
The range of range partitioning.
The range partitioning field.string
streamingBuffer
estimatedBytesinteger
estimatedRowsinteger
oldestEntryTimeinteger
timePartitioning
expirationstring
Formatduration
fieldstring
requirePartitionFilterbooleanstring
typestring
Possible Values
DAYHOURMONTHYEAR
typestring
Possible Values
TABLEVIEWMATERIALIZED_VIEWEXTERNALMODEL
viewDefinition
querystring
viewUserDefinedFunctionsarray
The type of user defined function.string
Possible Values
INLINEFROM_URI
Type of UserDefinedFunctionstring
Formatdate-time
Definitions
externalTableDefinition
autodetectboolean
compressionstring
formatTypestring
Possible Values
CSVJSONBIGTABLEDATASTORE_BACKUPAVROGOOGLE_SHEETSPARQUETORC
ignoreUnknownValuesboolean
maxBadRecordsinteger
sourceUrisarray
SubTypestring
materializedViewDefinition
enableRefreshboolean
lastRefreshDatestring
Formatdate-time
querystring
refreshIntervalstring
Formatduration
schema
fieldsarray
descriptionstring
modestring
Possible Values
NULLABLEREQUIREDREPEATED
namestring
policyTags
subFieldsarray
typestring
Possible Values
BOOLINT64FLOAT64NUMERICBIGNUMERICSTRINGBYTESSTRUCTARRAYTIMESTAMPDATETIMEDATETIMEGEOGRAPHYJSONINTERVALRANGE
standardTableDefinition
clusteringarray
SubTypestring
rangePartitioning
fieldstring
range
streamingBuffer
estimatedBytesinteger
estimatedRowsinteger
oldestEntryTimeinteger
timePartitioning
expirationstring
Formatduration
fieldstring
requirePartitionFilterboolean
typestring
Possible Values
DAYHOURMONTHYEAR
typestring
Possible Values
TABLEVIEWMATERIALIZED_VIEWEXTERNALMODEL
viewDefinition
querystring
viewUserDefinedFunctionsarray
contentstring
typestring
Possible Values
INLINEFROM_URI
Definitions
kmsKeyNamestring
Formatdate-time
SubTypestring
Formatdate-time