Hi mridultuteja,

How are you doing today?, As per my understanding, If you’re getting an error like “no such location exists” when trying to create an external table, even though dbutils.fs.ls() works and lists your files, the issue is usually related to how paths are referenced when using Unity Catalog. When creating an external table, especially with CREATE TABLE ... LOCATION, Unity Catalog expects the path to be registered as an external location with proper permissions. Just because the notebook can read the path doesn't mean Unity Catalog has the right access. To fix this, go to the Databricks UI, register your external location under Data > External Locations, and make sure your storage credential has the correct access to the path. Once that’s done, try creating the table again using that external location. Let me know if you want help setting up the location registration—it’s a one-time thing, and then it works smoothly!

Regards,

Brahma