Delete partitions between interval

yaml
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') }}"

Dynamic YES

The dataset's user-defined ID.

Dynamic YES

The inclusive starting date or integer.

If the partition :

is a numeric range, must be a valid integer
is a date, must a valid datetime like {{ now() }}

Dynamic YES

Possible Values

DAYHOURMONTHYEARRANGE

The partition type of the table

Dynamic YES

The table's user-defined ID.

Dynamic YES

The inclusive ending date or integer.

If the partition :

is a numeric range, must be a valid integer
is a date, must a valid datetime like {{ now() }}

Dynamic YES

The GCP service account to impersonate.

Dynamic YES

The geographic location where the dataset should reside.

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

See Dataset Location

Dynamic YES

The GCP project ID.

Dynamic NO

SubType string

Dynamic YES

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.

SubType string

Dynamic YES

Default ["rateLimitExceeded","jobBackendError","internalError","jobInternalError"]

The reasons which would trigger an automatic retry.

SubType string

Dynamic YES

Default ["https://www.googleapis.com/auth/cloud-platform"]

The GCP scopes to be used.

Dynamic YES

The GCP service account.

The dataset's id

SubType string

Partitions deleted

The project's id

The table name

Dynamic NO

Format duration

Dynamic NO

Default RETRY_FAILED_TASK

Possible Values

RETRY_FAILED_TASKCREATE_NEW_EXECUTION

Dynamic NO

Minimum >= 1

Dynamic NO

Format duration

Dynamic NO

Default constant

Dynamic NO

Default false

Dynamic NO

Format duration

Dynamic NO

Format duration

Dynamic NO

Default RETRY_FAILED_TASK

Possible Values

RETRY_FAILED_TASKCREATE_NEW_EXECUTION

Dynamic NO

Minimum >= 1

Dynamic NO

Format duration

Dynamic NO

Default random

Dynamic NO

Default false

Dynamic NO

Format duration

Dynamic NO

Format duration

Dynamic NO

Default RETRY_FAILED_TASK

Possible Values

RETRY_FAILED_TASKCREATE_NEW_EXECUTION

Dynamic NO

Minimum >= 1

Dynamic NO

Format duration

Dynamic NO

Default exponential

Dynamic NO

Default false

​Delete​Partitions

DeletePartitions