cancel
Showing results for 
Search instead for 
Did you mean: 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

niklas
Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions

youssefmrini
Honored Contributor III

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

2 REPLIES 2

Rajeev_Basu
Contributor III

following..

youssefmrini
Honored Contributor III

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.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group