External Tables - SQL

[NimaiAhl]

To create external tables we need to use the location keyword and use the link for the storage location, in reference to that does the user need to have permission for the storage location if not then will we use storage credentials to provide the access, am I assuming this right?

Thanks in advance

Nimai.

[Shikamaru]

Hi Nimai, That's partially right. You can grant permissions directly on the storage credential, but Databricks recommends that you reference it in an external location and grant permissions to that instead. An external location combines a storage credential with a specific path, and authorizes access only to that path and its contents. You can refer to this - https://docs.databricks.com/data-governance/unity-catalog/manage-external-locations-and-credentials.....