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

[niklas]

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?

[Rajeev_Basu]

following..

[youssefmrini · Accepted solution]

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.