Use the Clear SQL table instruction to delete all of the data in a managed table. This step is usually added to processes where all the data is refreshed each run.
1. Add a new data manipulation step to your process (learn how).
2. In the new step, add an instruction and select Clear SQL table.
3. Link your managed table to the instruction by typing the table name into the linking box.
4. Run the step. After it has completed successfully, open the managed table (that you linked) and confirm that it is now empty - showing 0 rows and 0KB of storage space:
Tips and Tricks:
You can achieve a similar outcome by checking the Clear old data box when importing data into your managed table (see step 11 in the following guide: link). This will ensure that all of the data from your managed table is removed before importing the new set of data.
One of the really important features of the Clear SQL table instruction is that it also clears the Transaction Log of the underlying SQL table. This can be very important for large data sets to ensure that your data storage does not build up over time.