Google Cloud DeletePartitions
CertifiedDelete BigQuery partitions in a range
Google Cloud DeletePartitions
Delete BigQuery partitions in a range
Lists partitions in the given date or range interval and deletes them. Fails if any targeted partition is missing.
type: io.kestra.plugin.gcp.bigquery.DeletePartitionsExamples
id: gcp_bq_delete_partitions
namespace: company.team
tasks:
- id: delete_partitions
type: io.kestra.plugin.gcp.bigquery.DeletePartitions
projectId: my-project
dataset: my-dataset
table: my-table
partitionType: DAY
from: "{{ now() | dateAdd(-30, 'DAYS') }}"
to: "{{ now() | dateAdd(-7, 'DAYS') }}"
Properties
dataset *Requiredstring
Dataset ID
Target dataset name
from *Requiredstring
Partition start
Inclusive start value. Use an integer for RANGE partitions or an ISO datetime for date/time partitions.
partitionType *Requiredstring
DAYHOURMONTHYEARRANGEPartition type
DAY, HOUR, MONTH, YEAR, or RANGE
table *Requiredstring
Table ID
Target table name
to *Requiredstring
Partition end
Inclusive end value. Use an integer for RANGE partitions or an ISO datetime for date/time partitions.
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
partitions array
Partitions deleted
projectId string
Project ID
table string
Table name
Metrics
size counter
The number of partitions deleted.
