ExtractToGcs
yaml
type: "io.kestra.plugin.gcp.bigquery.extracttogcs"Examples
yaml
id: gcp_bq_extract_to_gcs
namespace: company.team
tasks:
- id: extract_to_gcs
type: io.kestra.plugin.gcp.bigquery.ExtractToGcs
destinationUris:
- "gs://bucket_name/filename.csv"
sourceTable: "my_project.my_dataset.my_table"
format: CSV
fieldDelimiter: ';'
printHeader: true
Properties
compression string
destinationUris array
SubType string
fieldDelimiter string
format string
impersonatedServiceAccount string
jobTimeoutMs integerstring
labels object
SubType string
location string
printHeader booleanstring
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
sourceTable string
useAvroLogicalTypes booleanstring
Outputs
destinationUris array
SubType string
fileCounts array
SubType integer
jobId string
sourceTable string
Metrics
duration timer
output.file_counts counter
Definitions
io.kestra.core.models.tasks.retrys.Constant
interval *Requiredstring
Format
durationtype *Requiredobject
behavior string
Default
RETRY_FAILED_TASK Possible Values
RETRY_FAILED_TASKCREATE_NEW_EXECUTIONmaxAttempts integer
Minimum
>= 1maxDuration string
Format
durationwarningOnRetry boolean
Default
falseio.kestra.core.models.tasks.retrys.Random
maxInterval *Requiredstring
Format
durationminInterval *Requiredstring
Format
durationtype *Requiredobject
behavior string
Default
RETRY_FAILED_TASK Possible Values
RETRY_FAILED_TASKCREATE_NEW_EXECUTIONmaxAttempts integer
Minimum
>= 1maxDuration string
Format
durationwarningOnRetry boolean
Default
falseio.kestra.core.models.tasks.retrys.Exponential
interval *Requiredstring
Format
durationmaxInterval *Requiredstring
Format
durationtype *Requiredobject
behavior string
Default
RETRY_FAILED_TASK Possible Values
RETRY_FAILED_TASKCREATE_NEW_EXECUTIONdelayFactor number
maxAttempts integer
Minimum
>= 1maxDuration string
Format
durationwarningOnRetry boolean
Default
false