Explanation:
External (unmanaged) tables store data in an external storage path specified by a LOCATION clause. Dropping such a table only removes its metadata, not the underlying data files. Reference: Databricks Documentation on Unmanaged Tables
Ultimate access to all questions.
Why does dropping a Delta table only delete the table's metadata, leaving the data files intact in storage?
A
The table is deep cloned
B
Delta prevents deleting files less than retention threshold, ensuring no long-running operations reference files to be deleted
C
The user running the command lacks permission to delete the data files
D
The table is external
E
The table is managed
No comments yet.