External Location not showing up

kjoudeh
New Contributor II

Hello, 

For some reason I am not able to see the external location that we have in our workspace. I am 100% sure that we have a lot that exist but some reason I am not able to see them, is there a reason why , am I missing something. I know other user are able to see it 

when I run this command it return with no rows (empty)

SHOW EXTERNAL LOCATIONS

 and I am not able to see the storage crendential.

SHOW STORAGE CREDENTIALS

return no rows 

Same thing with the UI (cant see credential or external location available )

Am I missing a step 

 

filipniziol
Esteemed Contributor

Hi @kjoudeh ,

It is due to permissions.For external locations you would need to have BROWSE permissions:
https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/manage-privileges/p...

Ask the metastore admin or a workspace admin to grant you the necessary permission:

 

GRANT BROWSE ON EXTERNAL LOCATION <your external location> TO `<your user>`

 

 

kjoudeh
New Contributor II

Thanks you @filipniziol  really appreciate it