Truncating Apache Iceberg Tables
The TRUNCATE command deletes all rows from a table with minimal computation by restating the table with no data files.
This command is not supported on Amazon Glue datasources.
Before running this command, ensure that your user ID has the DELETE privilege in Dremio Cloud.
TRUNCATE [ TABLE ] [ IF EXISTS ] <table_path>.<table_name>
(Optional) Specifies that the object to be truncated is a table. If not used, the Dremio Cloud still recognizes that the object is a table. This option is for consistency with other query engines that can truncate the same tables that Dremio Cloud has access to on the datasource.
(Optional) Prevents the datasource from returning an error message if a table with the same definition does not exist in the specified location.
The path in which the table is located.
The name of the table that you want to truncate.