Thanks Brahma, Appreciate the details. So looks like catalog and schema are at the managed location and I cannot use the same location for the table to create it as external. I have created an external location and has all the privileges. when I create the catalog/schema I specify the external location so I was thinking it is in external location but it looks like catalog/schema are managed. when I try use the same location it's overlapping with managed location. Little confused. what should be the standard practice. I used ADLS location so it should treat it as external location while creating the catalog/schema,