Hi All,
We have ran into scenario, where Azure Data Factory connecting to Azure Data Bricks through linkedServices,
Where its trying to connect with System Assigned Managed Identity (SAMI).
Specific SAMI added to compute and unity catalog for usage.
show grants `6b3xxxx-0xx9-4xx4-axx9-bxxxxxxbc` on schema dev.uef_db;
-----------------------------
Principal ActionType ObjectType ObjectKey
6b3xxxx-0xx9-4xx4-axx9-bxxxxxxbc USE SCHEMA CATALOG dev
But, still when we try to query or execute any notebooks from ADF LinkedServices (compute/delta lake connector)
User does not have USE SCHEMA on Schema 'dev.uef_db'. SQLSTATE: 42501
Any idea, where we missing permissions.
Thanks in Advance.