Performing Table Operations

Following are the steps to truncate and recrawl the table data:

1. Click View Source for the required source.
2. In the Tables tab, select the required tables.

Perform either of the following:

• Click Truncate/Reset to delete data from the target or reset the table metadata (row count and last ingested timestamp).

  • For Infoworks Managed Table, the underlying table data will be truncated and dropped. The state of table is reset to Metadata Crawled for a User to re-configure the table.

  • For User Managed Table without Data, the underlying data will be truncated and the table will not be dropped. The state of table is reset to Metadata Crawled for a User to re-configure the table.

  • For User Managed Table with Data, the underlying data will not be truncated. The state of the table is reset to Metadata Crawled for a User to re-configure the table.

• Click Recrawl Metadata to refresh the column list based on the schema from the source system.