Truncate Tables
Description
Truncate Tables removes all rows from one or more database tables without requiring you to write SQL commands. Use this process entry to clear staging or temporary tables before a workflow loads fresh data — for example, truncating a staging table at the start of a daily ETL process or clearing a work table before a new batch run. It supports selecting multiple tables from a connection and can use the result filenames list to specify tables dynamically.
Configurations
| Field Name | Description |
|---|---|
| Process Entry name | Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name. |
| Connection | Name of the database connection on which the tables reside. Use "Edit..." and "New..." to edit and/or create a new connection. |
| Previous results to args? | Check this option if you want to get in a dynamic way tables to truncate from results of previous process entry. Note: The first field has to be the table name and the second one the schema (leave it Null if it's not needed). |
| Click here to return tables name list | This button will return all tables defined on the connection. Select tables (one or several) and press "OK". Tables name will be automatically added to "Selected tables" grid. |
| Selected tables grid | Specify here the tables to truncate (insert it manually or use the previous button). If the table is in a different schema that the default one, please specify the schema name. |
| Delete | Remove entries from grid (select one several entries and click on this button to remove it). |
| OK | Click on this button to save process entry settings changes |
| Cancel | Discard process entry settings changes |