TableMetadata
yaml
type: "io.kestra.plugin.gcp.bigquery.tablemetadata"
Examples
yaml
id: gcp_bq_table_metadata
namespace: company.team
tasks:
- id: table_metadata
type: io.kestra.plugin.gcp.bigquery.TableMetadata
projectId: my-project
dataset: my-dataset
table: my-table
Properties
dataset *Requiredstring
table *Requiredstring
ifNotExists string
Default
ERROR
Possible Values
ERROR
SKIP
impersonatedServiceAccount string
location string
projectId string
retryAuto Non-dynamicConstantExponentialRandom
retryMessages array
SubType string
Default
["due to concurrent update","Retrying the job may solve the problem","Retrying may solve the problem"]
retryReasons array
SubType string
Default
["rateLimitExceeded","jobBackendError","backendError","internalError","jobInternalError"]
scopes array
SubType string
Default
["https://www.googleapis.com/auth/cloud-platform"]
serviceAccount string
Outputs
creationTime string
Format
date-time
datasetId string
definition TableDefinition-Output
description string
encryptionConfiguration EncryptionConfiguration-Output
etag string
expirationTime string
Format
date-time
friendlyName string
generatedId string
labels object
SubType string
lastModifiedTime string
Format
date-time
numBytes integer
numLongTermBytes integer
numRows integer
projectId string
requirePartitionFilter boolean
selfLink string
table string
Definitions
io.kestra.core.models.tasks.retrys.Constant
interval *Requiredstring
Format
duration
type *Requiredobject
behavior string
Default
RETRY_FAILED_TASK
Possible Values
RETRY_FAILED_TASK
CREATE_NEW_EXECUTION
maxAttempts integer
Minimum
>= 1
maxDuration string
Format
duration
warningOnRetry boolean
Default
false
io.kestra.plugin.gcp.bigquery.models.EncryptionConfiguration-Output
kmsKeyName string
io.kestra.core.models.tasks.retrys.Exponential
interval *Requiredstring
Format
duration
maxInterval *Requiredstring
Format
duration
type *Requiredobject
behavior string
Default
RETRY_FAILED_TASK
Possible Values
RETRY_FAILED_TASK
CREATE_NEW_EXECUTION
delayFactor number
maxAttempts integer
Minimum
>= 1
maxDuration string
Format
duration
warningOnRetry boolean
Default
false
io.kestra.plugin.gcp.bigquery.models.RangePartitioning-Range-Output
end integer
interval integer
start integer
com.google.cloud.bigquery.StandardTableDefinition-StreamingBuffer
estimatedBytes integer
estimatedRows integer
oldestEntryTime integer
io.kestra.plugin.gcp.bigquery.models.Field-Output
description string
mode string
Possible Values
NULLABLE
REQUIRED
REPEATED
name string
policyTags PolicyTags-Output
type string
Possible Values
BOOL
INT64
FLOAT64
NUMERIC
BIGNUMERIC
STRING
BYTES
STRUCT
ARRAY
TIMESTAMP
DATE
TIME
DATETIME
GEOGRAPHY
JSON
INTERVAL
RANGE
io.kestra.plugin.gcp.bigquery.models.ViewDefinition-Output
io.kestra.plugin.gcp.bigquery.models.TimePartitioning-Output
expiration string
Format
duration
field string
requirePartitionFilter boolean
type string
Possible Values
DAY
HOUR
MONTH
YEAR
io.kestra.plugin.gcp.bigquery.models.UserDefinedFunction-Output
content string
type string
Possible Values
INLINE
FROM_URI
io.kestra.core.models.tasks.retrys.Random
maxInterval *Requiredstring
Format
duration
minInterval *Requiredstring
Format
duration
type *Requiredobject
behavior string
Default
RETRY_FAILED_TASK
Possible Values
RETRY_FAILED_TASK
CREATE_NEW_EXECUTION
maxAttempts integer
Minimum
>= 1
maxDuration string
Format
duration
warningOnRetry boolean
Default
false
io.kestra.plugin.gcp.bigquery.models.TableDefinition-Output
externalTableDefinition ExternalTableDefinition-Output
materializedViewDefinition MaterializedViewDefinition-Output
schema Schema-Output
standardTableDefinition StandardTableDefinition-Output
type string
Possible Values
TABLE
VIEW
MATERIALIZED_VIEW
EXTERNAL
MODEL
viewDefinition ViewDefinition-Output
io.kestra.plugin.gcp.bigquery.models.ExternalTableDefinition-Output
autodetect boolean
compression string
formatType string
Possible Values
CSV
JSON
BIGTABLE
DATASTORE_BACKUP
AVRO
GOOGLE_SHEETS
PARQUET
ORC
ignoreUnknownValues boolean
maxBadRecords integer
sourceUris array
SubType string
io.kestra.plugin.gcp.bigquery.models.MaterializedViewDefinition-Output
enableRefresh boolean
lastRefreshDate string
Format
date-time
query string
refreshInterval string
Format
duration
io.kestra.plugin.gcp.bigquery.models.RangePartitioning-Output
field string
io.kestra.plugin.gcp.bigquery.models.PolicyTags-Output
names array
SubType string
io.kestra.plugin.gcp.bigquery.models.StandardTableDefinition-Output
clustering array
SubType string