Google Cloud DeleteTable
CertifiedDelete a BigQuery table or partition
Google Cloud DeleteTable
Delete a BigQuery table or partition
Deletes the specified table or partition (using decorator syntax). Fails if the table does not exist.
type: io.kestra.plugin.gcp.bigquery.DeleteTableExamples
Delete a partition
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 *Requiredstring
Dataset ID
Target dataset name
table *Requiredstring
Table ID
Target table name
impersonatedServiceAccount string
The GCP service account to impersonate
location string
Dataset location
Optional BigQuery location for created or targeted resources. Experimental and may change; see BigQuery dataset location documentation.
pluginDefaultsRef Non-dynamicstring
Reference (ref) of the pluginDefaults to apply to this task.
projectId string
The GCP project ID
retryAuto Non-dynamic
Automatic BigQuery retry policy
Optional custom retry policy for retryable BigQuery errors. If unset, uses an exponential backoff starting at 5s (per-attempt interval capped at 60m), with a total duration of up to 15m and a maximum of 10 attempts.
Constant retry
Retry with a fixed delay between attempts.
durationRETRY_FAILED_TASKRETRY_FAILED_TASKCREATE_NEW_EXECUTION>= 1durationfalseExponential retry
Retry with exponentially increasing delays between attempts.
durationdurationRETRY_FAILED_TASKRETRY_FAILED_TASKCREATE_NEW_EXECUTION>= 1durationfalseRandom retry
Retry with a random delay within a configurable range between attempts.
durationdurationRETRY_FAILED_TASKRETRY_FAILED_TASKCREATE_NEW_EXECUTION>= 1durationfalseretryMessages array
["due to concurrent update","Retrying the job may solve the problem","Retrying may solve the problem"]Retry message substrings
Case-insensitive substrings that, if found in the error message, trigger an automatic retry
retryReasons array
["rateLimitExceeded","jobBackendError","backendError","internalError","jobInternalError"]Retry reasons
BigQuery error reasons that trigger an automatic retry; evaluated against error reason strings
scopes array
["https://www.googleapis.com/auth/cloud-platform"]The GCP scopes to be used
serviceAccount string
The GCP service account
Outputs
datasetId string
Dataset ID
projectId string
Project ID
table string
Table name
