
UpdateTable
UpdateTable
yaml
type: "io.kestra.plugin.gcp.bigquery.UpdateTable"Examples
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
dataset*Requiredstring
table*Requiredstring
descriptionstring
encryptionConfigurationNon-dynamic
Definitions
io.kestra.plugin.gcp.bigquery.models.EncryptionConfiguration
The KMS key name.string
expirationDurationstring
Format
durationfriendlyNamestring
impersonatedServiceAccountstring
labelsobject
SubTypestring
locationstring
projectIdstring
requirePartitionFilterbooleanstring
retryAutoNon-dynamic
Definitions
io.kestra.core.models.tasks.retrys.Constant
interval*Requiredstring
Format
durationtype*Requiredobject
behaviorstring
Default
RETRY_FAILED_TASKPossible Values
RETRY_FAILED_TASKCREATE_NEW_EXECUTIONmaxAttemptsinteger
Minimum
>= 1maxDurationstring
Format
durationwarningOnRetryboolean
Default
falseio.kestra.core.models.tasks.retrys.Exponential
interval*Requiredstring
Format
durationmaxInterval*Requiredstring
Format
durationtype*Requiredobject
behaviorstring
Default
RETRY_FAILED_TASKPossible Values
RETRY_FAILED_TASKCREATE_NEW_EXECUTIONdelayFactornumber
maxAttemptsinteger
Minimum
>= 1maxDurationstring
Format
durationwarningOnRetryboolean
Default
falseio.kestra.core.models.tasks.retrys.Random
maxInterval*Requiredstring
Format
durationminInterval*Requiredstring
Format
durationtype*Requiredobject
behaviorstring
Default
RETRY_FAILED_TASKPossible Values
RETRY_FAILED_TASKCREATE_NEW_EXECUTIONmaxAttemptsinteger
Minimum
>= 1maxDurationstring
Format
durationwarningOnRetryboolean
Default
falseretryMessagesarray
SubTypestring
Default
["due to concurrent update","Retrying the job may solve the problem","Retrying may solve the problem"]retryReasonsarray
SubTypestring
Default
["rateLimitExceeded","jobBackendError","backendError","internalError","jobInternalError"]scopesarray
SubTypestring
Default
["https://www.googleapis.com/auth/cloud-platform"]serviceAccountstring
tableDefinitionNon-dynamic
Definitions
io.kestra.plugin.gcp.bigquery.models.TableDefinition
externalTableDefinition
io.kestra.plugin.gcp.bigquery.models.ExternalTableDefinition
autodetectbooleanstring
compressionstring
formatTypestring
Possible Values
CSVJSONBIGTABLEDATASTORE_BACKUPAVROGOOGLE_SHEETSPARQUETORCignoreUnknownValuesbooleanstring
maxBadRecordsintegerstring
sourceUrisarray
SubTypestring
materializedViewDefinition
io.kestra.plugin.gcp.bigquery.models.MaterializedViewDefinition
enableRefreshbooleanstring
lastRefreshDatestring
Format
date-timequerystring
refreshIntervalstring
Format
durationschema
io.kestra.plugin.gcp.bigquery.models.Schema
The fields associated with this schema.array
io.kestra.plugin.gcp.bigquery.models.Field
descriptionstring
modestring
Possible Values
NULLABLEREQUIREDREPEATEDnamestring
policyTags
subFieldsarray
typestring
Possible Values
BOOLINT64FLOAT64NUMERICBIGNUMERICSTRINGBYTESSTRUCTARRAYTIMESTAMPDATETIMEDATETIMEGEOGRAPHYJSONINTERVALRANGEstandardTableDefinition
io.kestra.plugin.gcp.bigquery.models.StandardTableDefinition
clusteringarray
SubTypestring
rangePartitioning
io.kestra.plugin.gcp.bigquery.models.RangePartitioning
The range of range partitioning.
The range partitioning field.string
streamingBuffer
com.google.cloud.bigquery.StandardTableDefinition-StreamingBuffer
estimatedBytesinteger
estimatedRowsinteger
oldestEntryTimeinteger
timePartitioning
io.kestra.plugin.gcp.bigquery.models.TimePartitioning
expirationstring
Format
durationfieldstring
requirePartitionFilterbooleanstring
typestring
Possible Values
DAYHOURMONTHYEARtypestring
Possible Values
TABLEVIEWMATERIALIZED_VIEWEXTERNALMODELviewDefinition
io.kestra.plugin.gcp.bigquery.models.ViewDefinition
querystring
viewUserDefinedFunctionsarray
io.kestra.plugin.gcp.bigquery.models.UserDefinedFunction
The type of user defined function.string
Possible Values
INLINEFROM_URIType of UserDefinedFunctionstring
Outputs
creationTimestring
Format
date-timedatasetIdstring
definition
Definitions
io.kestra.plugin.gcp.bigquery.models.TableDefinition-Output
externalTableDefinition
io.kestra.plugin.gcp.bigquery.models.ExternalTableDefinition-Output
autodetectboolean
compressionstring
formatTypestring
Possible Values
CSVJSONBIGTABLEDATASTORE_BACKUPAVROGOOGLE_SHEETSPARQUETORCignoreUnknownValuesboolean
maxBadRecordsinteger
sourceUrisarray
SubTypestring
materializedViewDefinition
io.kestra.plugin.gcp.bigquery.models.MaterializedViewDefinition-Output
enableRefreshboolean
lastRefreshDatestring
Format
date-timequerystring
refreshIntervalstring
Format
durationschema
io.kestra.plugin.gcp.bigquery.models.Schema-Output
fieldsarray
io.kestra.plugin.gcp.bigquery.models.Field-Output
descriptionstring
modestring
Possible Values
NULLABLEREQUIREDREPEATEDnamestring
policyTags
subFieldsarray
typestring
Possible Values
BOOLINT64FLOAT64NUMERICBIGNUMERICSTRINGBYTESSTRUCTARRAYTIMESTAMPDATETIMEDATETIMEGEOGRAPHYJSONINTERVALRANGEstandardTableDefinition
io.kestra.plugin.gcp.bigquery.models.StandardTableDefinition-Output
clusteringarray
SubTypestring
rangePartitioning
io.kestra.plugin.gcp.bigquery.models.RangePartitioning-Output
fieldstring
range
streamingBuffer
com.google.cloud.bigquery.StandardTableDefinition-StreamingBuffer
estimatedBytesinteger
estimatedRowsinteger
oldestEntryTimeinteger
timePartitioning
io.kestra.plugin.gcp.bigquery.models.TimePartitioning-Output
expirationstring
Format
durationfieldstring
requirePartitionFilterboolean
typestring
Possible Values
DAYHOURMONTHYEARtypestring
Possible Values
TABLEVIEWMATERIALIZED_VIEWEXTERNALMODELviewDefinition
io.kestra.plugin.gcp.bigquery.models.ViewDefinition-Output
querystring
viewUserDefinedFunctionsarray
io.kestra.plugin.gcp.bigquery.models.UserDefinedFunction-Output
contentstring
typestring
Possible Values
INLINEFROM_URIdescriptionstring
encryptionConfiguration
Definitions
io.kestra.plugin.gcp.bigquery.models.EncryptionConfiguration-Output
kmsKeyNamestring
etagstring
expirationTimestring
Format
date-timefriendlyNamestring
generatedIdstring
labelsobject
SubTypestring
lastModifiedTimestring
Format
date-time