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.
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.
Was this page helpful?
Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.