At 5:01, you mentioned metadata for external table stored in the storage path mentioned in the syntax. I had a doubt for it. Only, the data got stored in the path mentioned, the metadata is always stored inside the databricks irrespective of table type. Correct me, if I understand wrong.
When it comes to external tables, you can only delete their schema or table in database. To delete the underlying data, you need to either delete the entire folder which was using that location for external table or delete files inside that folder.
At 5:01, you mentioned metadata for external table stored in the storage path mentioned in the syntax. I had a doubt for it. Only, the data got stored in the path mentioned, the metadata is always stored inside the databricks irrespective of table type. Correct me, if I understand wrong.
I think you are correct
Yes, Data is stored in external location. That's what if you drop the table, data still exists in external location.
audio-video is not aligned for this video. please check
audio with video is mismatching
The data for the external tables are stored in cloud and metadata is stored with in databricks.
audio-video is not aligned
Bro, If I want to delete external table completely, then how to do it? Please tell me
When it comes to external tables, you can only delete their schema or table in database. To delete the underlying data, you need to either delete the entire folder which was using that location for external table or delete files inside that folder.
Could you please create video on workflow job