Connect a SQL warehouse to an Azure Blob container

[brendanc19]

Hi all,

I was wondering if it was possible to configure a single SQL warehouse to a specific Blob container?

I know you can add configuration properties to the Workspace from the Admin settings, but it appears that those configurations will be shared by ALL SQL warehouses in the workspace.

Therefore, is it possible via API or otherwise, to configure a single SQL warehouse with a SAS token or SPN to access an Azure Blob Container without affecting all SQL warehouses in the workspace?

[Kaniz · Accepted solution]

Hi @brendanc19, I'm sorry, but based on the provided information, it's impossible to configure a single SQL warehouse with an SAS token or SPN to access an Azure Blob Container without affecting all SQL warehouses in the workspace.

All SQL warehouses share the configuration properties in the workspace, and there's no mention of being able to configure individual SQL warehouses with unique access credentials to Azure Blob Containers.

However, it's important to note that you can control access to SQL warehouses at the user level, as detailed in the SQL warehouse access control document. This allows you to set permissions for individual users, potentially providing a workaround for your use case.

Sources:
- [Docs: compute](https://docs.databricks.com/data-governance/unity-catalog/compute.html)
- [Docs: sql-endpoint-acl](https://docs.databricks.com/security/auth-authz/access-control/sql-endpoint-acl.html)
- [Docs: wasb-blob](https://docs.databricks.com/archive/storage/wasb-blob.html)