The Data Hub task agent is used to remove old partitions from the database. This agent must be used in a Task workflow.
Configuration
Data Hub Task agent configuration
| Field | Description |
|---|---|
| Profile | Click Browse to select a predefined Data Hub profile. The profile contains the settings required to connect to the database. |
| Table | Select database table from the drop-down list. |
| Partition Column | Select a partition column in the table that is of integer type. The column should indicate the age of the inserted row. |
| Remove Older Than | Enter the maximum number of hours, days, months, or years that Data Hub should retain data. Note! The displayed time unit depends on the selected value in the Type Hint column in the Data Hub profile. For instance if you have selected YYYYMM the time unit will be months. For further information, see 3. Data Hub Profile. |