Hi @mysura,

Is your workspace Unity Catalog enabled? do you have a metastore assigned? I think legacy hive_metastore will not support service principal to do this change.

I think the best approach is to create an external location based on the adfss and then create the table with location as external location table.

https://learn.microsoft.com/en-us/azure/databricks/connect/unity-catalog/cloud-storage/external-loca...

https://learn.microsoft.com/en-us/azure/databricks/dbfs/unity-catalog