How can I set the data access for each SQL warehouse individually?

niklas
Contributor

‎06-01-2023 08:10 AM - last edited on ‎03-18-2025 09:40 AM by Community Manager

As far as the official documentation from Microsoft says and I understood it correctly, each SQL warehouse uses the same service principal for data access.

But I want to control the access to the data (Azure Data Lake Storage) for each SQL warehouse individually. Is this even possible?

Labels:
0 Kudos

Rajeev_Basu
Databricks Partner

‎06-02-2023 04:11 AM

following..

youssefmrini
Databricks Employee
Databricks Employee

‎06-02-2023 06:27 AM

It can be done but it's very tricky. You should create a service principal to whom you will grant permission over some tables then you can generate a token using the SP to access only this data.

View solution in original post