This article is specific to the following platforms - Redshift.
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.
|Name||Text||A human-readable name for the component.|
|Schema||Select||Select the table schema. The special value, [Environment Default] will use the schema defined in the environment. For more information on using multiple schemas, see this article.|
|Table||Text||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||Text||The values for each partition column that are to be deleted. These correspond to folder names in the S3 bucket that the external table references.|
|Ignore Missing||Select||If 'No', the component will error when expecting a partition to delete that is not present. If 'Yes', errors will be ignored and the workflow will continue regardless.|