Truncate data from a table
Truncate data from a table from within the Data workspace in OpsCenter Monitoring. A message warns you that truncated data is lost from OpsCenter. If a snapshot of the table does not already exist, a snapshot is created on your behalf. That snapshot resides in a snapshot directory within its table directory. If you need to restore the table data at some point in the future, you must do so manually by running sstableloader on the SSTables in the snapshot. The snapshot cannot be restored from the Backup Service. See Restore from a snapshot in the DataStax Cassandra documentation.
To find out more about the ramifications of truncating data, and an alternative method of doing so manually, see TRUNCATE.
If OpsCenter authentication is enabled, you must have a role with the Truncate Data permission.
-
Click Cluster > Data in the left navigation pane.
-
Select the keyspace that contains the table to truncate.
-
In the Tables tab, select the table for which you want to truncate data.
You can only truncate data from one table at a time.
-
Click Truncate above the CQL pane.
When OpsCenter authentication is enabled, the Truncate link is only available if the Truncate Data permission is enabled for your assigned role.
Removal of the data is irreversible in OpsCenter.
-
Click Truncate name_of_table.
The Table Truncated dialog appears and informs you the table was truncated.
-
Click Close.
