# Delete Action

This action is used to empty one, or multiple, tables in the database. Using the perimeter in the preferences section, you can limit the deletion to a specific subset of data. The perimeter can be preformed on:

* Based on predefined set (A table attribute) 
* Date perimeter of the workflow
* Based on attribute of the Project (An attribute of the Project)

> *Pro-tip*
>
>The perimeter type *Based on predefined set*  can have multiple values, but only one attribute can be selected. Whilst unorthodox, you can use segmentation to act as an additional attribute based on a table attribute.  

## Setup example

```
{ 
	"params": {
		"tables": [
			"dwh/default_dataset/table_1", 
			"dwh/analytics_dataset/table_2"
		]
	}
}
```

---

## Parameters

|                Parameter               | Description              | Example              | Required              | 
| :------------------------------: | -------------------------- | -------------------------- | -------------------------- | 
|            **tables**             | Tables to delete.             |    ```["dwh/default_dataset/table1", "dwh/analytics_dataset/table2"]```   | Yes              | 

*This parameter should be used carefully, as if the action terminates early, it will result in partial deletion of data, and if multiple tables are selected, some tables may not be deleted at all.