Resolved! How can I set the data access for each SQL warehouse individually?
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 ...
- 4977 Views
- 2 replies
- 3 kudos
Latest Reply
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.
- 3 kudos