DeleteTable DeleteTable

yaml
type: "io.kestra.plugin.gcp.bigquery.DeleteTable"

Delete a table or a partition

Examples

Delete a partition

yaml
id: gcp_bq_delete_table
namespace: company.team

tasks:
  - id: delete_table
    type: io.kestra.plugin.gcp.bigquery.DeleteTable
    projectId: my-project
    dataset: my-dataset
    table: my-table$20130908

Properties

dataset

  • Type: string
  • Dynamic: ✔️
  • Required: ✔️

The dataset's user-defined ID.

table

  • Type: string
  • Dynamic: ✔️
  • Required: ✔️

The table's user-defined ID.

location

  • Type: string
  • Dynamic: ✔️
  • Required:

The geographic location where the dataset should reside.

This property is experimental and might be subject to change or removed.

See Dataset Location

projectId

  • Type: string
  • Dynamic: ✔️
  • Required:

The GCP project ID.

retryAuto

retryMessages

  • Type: array
  • SubType: string
  • Dynamic: ✔️
  • Required:
  • Default: [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.

retryReasons

  • Type: array
  • SubType: string
  • Dynamic: ✔️
  • Required:
  • Default: [rateLimitExceeded, jobBackendError, internalError, jobInternalError]

The reasons which would trigger an automatic retry.

scopes

  • Type: array
  • SubType: string
  • Dynamic: ✔️
  • Required:
  • Default: [https://www.googleapis.com/auth/cloud-platform]

The GCP scopes to be used.

serviceAccount

  • Type: string
  • Dynamic: ✔️
  • Required:

The GCP service account key.

Outputs

datasetId

  • Type: string
  • Required:

The dataset's id

projectId

  • Type: string
  • Required:

The project's id

table

  • Type: string
  • Required:

The table name

Definitions

io.kestra.core.models.tasks.retrys.Constant

Properties

interval
  • Type: string
  • Dynamic:
  • Required: ✔️
  • Format: duration
type
  • Type: string
  • Dynamic:
  • Required: ✔️
  • Default: constant
behavior
  • Type: string
  • Dynamic:
  • Required:
  • Default: RETRY_FAILED_TASK
  • Possible Values:
    • RETRY_FAILED_TASK
    • CREATE_NEW_EXECUTION
maxAttempt
  • Type: integer
  • Dynamic:
  • Required:
  • Minimum: >= 1
maxDuration
  • Type: string
  • Dynamic:
  • Required:
  • Format: duration
warningOnRetry
  • Type: boolean
  • Dynamic:
  • Required:
  • Default: false

io.kestra.core.models.tasks.retrys.Random

Properties

maxInterval
  • Type: string
  • Dynamic:
  • Required: ✔️
  • Format: duration
minInterval
  • Type: string
  • Dynamic:
  • Required: ✔️
  • Format: duration
type
  • Type: string
  • Dynamic:
  • Required: ✔️
  • Default: random
behavior
  • Type: string
  • Dynamic:
  • Required:
  • Default: RETRY_FAILED_TASK
  • Possible Values:
    • RETRY_FAILED_TASK
    • CREATE_NEW_EXECUTION
maxAttempt
  • Type: integer
  • Dynamic:
  • Required:
  • Minimum: >= 1
maxDuration
  • Type: string
  • Dynamic:
  • Required:
  • Format: duration
warningOnRetry
  • Type: boolean
  • Dynamic:
  • Required:
  • Default: false

io.kestra.core.models.tasks.retrys.Exponential

Properties

interval
  • Type: string
  • Dynamic:
  • Required: ✔️
  • Format: duration
maxInterval
  • Type: string
  • Dynamic:
  • Required: ✔️
  • Format: duration
type
  • Type: string
  • Dynamic:
  • Required: ✔️
  • Default: exponential
behavior
  • Type: string
  • Dynamic:
  • Required:
  • Default: RETRY_FAILED_TASK
  • Possible Values:
    • RETRY_FAILED_TASK
    • CREATE_NEW_EXECUTION
delayFactor
  • Type: number
  • Dynamic:
  • Required:
maxAttempt
  • Type: integer
  • Dynamic:
  • Required:
  • Minimum: >= 1
maxDuration
  • Type: string
  • Dynamic:
  • Required:
  • Format: duration
warningOnRetry
  • Type: boolean
  • Dynamic:
  • Required:
  • Default: false

Was this page helpful?