Delete Partition

Allows users to delete the S3 directory structure created for partitioned external table data. On S3, a single folder is created for each partition value and is named according to the corresponding partition key and value. These folders can be removed by defining partition values through the Delete Partition component.

For example, the partition value for the key 'Salesdate' might be '2016-01-07'. A directory would then be created on S3 named 'Salesdate=2017-04-31' containing this partition's data.

---

Properties

Name = string

A human-readable name for the component.

---

Schema = drop-down

Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on using multiple schemas, read Schemas.

---

Table = string

The table that has partitions to be deleted. This should be an external table that already has partitions defined through the Create External Table component..

---

Partition Values = column editor

Specify values for each partition to be deleted. These correspond to folder names in the S3 bucket that the external table references.

---

Ignore Missing = drop-down

When No, the component will error when expecting a partition to delete that is not present. When Yes, errors will be ignored and the workflow will continue regardless.

---

Snowflake	Delta Lake on Databricks	Amazon Redshift	Google BigQuery	Azure Synapse Analytics
❌	❌	✅	❌	❌