Question: what is the difference between external table and managed table?
Answer: What is the difference between an external table and a managed table? ¶ The main difference is that when you drop an external table, the underlying data files stay intact. ... With a managed table, the underlying directories and data get wiped out when the table is dropped.