The TRUNCATE command deletes all rows from a table with minimal computation by restating the table with no data files.Syntax
TRUNCATE [ TABLE ] [ IF EXISTS ] <table_path>.<table_name>
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.
[ IF EXISTS ]
Prevents the datasource from returning an error message if a table with the same definition does not exist in the specified location.
The name of the table that you want to truncate.
AT BRANCH <branch_name>
Specifies the branch of the table that you want to truncate. When this parameter is omitted, the current branch is used.