Why do we need Volumes when we can access the location using external locations? The doc says that it is to add governance, but we can already govern using external locations. So, why add another layer of governance? I am guessing that instead of giving access to the entire external location, we can provide access to a specific subfolder of the location using volumes.

I tried the following to get the compression format (File is in managed volume in Databricks catalog)

I need to copy a few tables(not all) from one schema to another (I am creating new schema from scratch).
What would be most efficient way to do this?
Create table newschema.table as select * from oldschema.table does not seem to be efficient.

I have setup Unity Catalog and have a storage credential that I can not access.
In the storage credential section I accedential unchecked the “All workspace have access” checkbox.
I had not given any Permissions grants on the storage credential.

Could you please confirm which API call in databricks we should use to retrieve the “who has access” details for the instance profile? I could not find option here . https://docs.databricks.com/api/workspace/instanceprofiles

Can someone let me know if there are nationwide issues with Databricks Unity Catalog. My Catalog Explore won’t load