Deleting an OTF Table - Teradata Vantage

Apache Iceberg and Delta Lake Open Table Format on VantageCloud Lake Getting Started

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-03
dita:mapPath
bsr1702324250454.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
bsr1702324250454

The DROP TABLE SQL removes an OTF table in the OTF metadata. The user must specify if the manifests and data should also be removed or just remove the table definition in the catalog.

Syntax

DROP TABLE <datalake_name>.<OTFdatabase_name>.<OTFtable_name> {PURGE ALL | NO PURGE};
<datalake_name> ::= !! name of the data lake object
<OTFdatabase_name> ::= !! name of the database in the OTF catalog
<OTFtable_name> ::= !! name of the OTF table

Example

DROP TABLE datalake_glue.MyDatabase.Tab2 PURGE ALL;

Usage Considerations

Either the PURGE ALL or the NO PURGE clause must be specified.

  • PURGE ALL removes the table entry from the catalog and deletes the manifests and data files.
  • NO PURGE removes the table entry from the catalog only. This is useful if the data is shared with another catalog. Then the manifests and data will still remain for the other catalog.