A data engineer runs DROP TABLE on a Unity Catalog external table whose files sit in a storage path the team chose. What happens to the underlying data files?
Choose an answer to check it. Afterward, select any option to review its explanation.
Dropping a table never relocates its files; moving data to managed storage is what a managed conversion does.
That is what happens when a managed table is dropped, because Unity Catalog controls its file lifecycle. This table is external.
VACUUM removes unreferenced files of an existing table; it is not what governs files after an external table is dropped.
For an external table, Unity Catalog governs the metadata but you own the file lifecycle, so dropping it removes only the metadata and leaves the files where they are.
id q1ae0e43fcd