https://community.databricks.com/t5/data-engineering/external-tables-sql/m-p/32156#M23432 <P>Hi Nimai, That's partially right. You can grant permissions directly on the storage credential, but&nbsp;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 - <A href="https://docs.databricks.com/data-governance/unity-catalog/manage-external-locations-and-credentials.html#:~:text=You%20can%20grant%20permissions%20directly,that%20path%20and%20its%20contents" target="test_blank">https://docs.databricks.com/data-governance/unity-catalog/manage-external-locations-and-credentials.html#:~:text=You%20can%20grant%20permissions%20directly,that%20path%20and%20its%20contents</A>.</P> Fri, 14 Apr 2023 07:23:22 GMT Anu-sha 2023-04-14T07:23:22Z https://community.databricks.com/t5/data-engineering/external-tables-sql/m-p/32155#M23431 <P>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?</P><P></P><P>Thanks in advance</P><P>Nimai.</P> Fri, 09 Sep 2022 05:24:11 GMT https://community.databricks.com/t5/data-engineering/external-tables-sql/m-p/32155#M23431 NimaiAhl 2022-09-09T05:24:11Z https://community.databricks.com/t5/data-engineering/external-tables-sql/m-p/32156#M23432 <P>Hi Nimai, That's partially right. You can grant permissions directly on the storage credential, but&nbsp;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 - <A href="https://docs.databricks.com/data-governance/unity-catalog/manage-external-locations-and-credentials.html#:~:text=You%20can%20grant%20permissions%20directly,that%20path%20and%20its%20contents" target="test_blank">https://docs.databricks.com/data-governance/unity-catalog/manage-external-locations-and-credentials.html#:~:text=You%20can%20grant%20permissions%20directly,that%20path%20and%20its%20contents</A>.</P> Fri, 14 Apr 2023 07:23:22 GMT https://community.databricks.com/t5/data-engineering/external-tables-sql/m-p/32156#M23432 Anu-sha 2023-04-14T07:23:22Z