topic Re: External Location not showing up in Data Engineering

External Location not showing up

kjoudeh — Thu, 03 Oct 2024 17:38:27 GMT

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

Re: External Location not showing up

filipniziol — Thu, 03 Oct 2024 18:55:26 GMT

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/privileges

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>`

Re: External Location not showing up

kjoudeh — Thu, 03 Oct 2024 19:58:42 GMT

Thanks you @filipniziol really appreciate it