Dremio Cloud
Dremio Software
 
On this page

    Dropping Apache Iceberg Tables

    For external Nessie datasources, the DROP TABLE command logically removes a table from the source. Even though the table is removed from the catalog, it still physically exists in storage until garbage collection removes it.

    For Amazon Glue and Amazon S3 datasources, the DROP TABLE command logically removes a table from the source and physically removes all files associated with the table. Once the table is dropped it is permanently deleted and can not be restored.

    The user ID being used to run this command must have the DROP privilege in Dremio Cloud.

    Syntax
    DROP TABLE <table_path>.<table_name>

    Parameters

    <table_path>

    String

    The path in which the table is located.

    <table_name>

    String

    The name of the table that you want to drop.