The token was fine, the SQL pool just didnt know the identity. You have to create a contained user for the Synapse workspace's managed identity in the database and grant it read access: ```sql CREATE USER [jsynapse] FROM EXTERNAL PROVIDER; ALTER ROLE db_datareader ADD MEMBER [jsynapse]; -- add db_da…
The token was fine, the SQL pool just didnt know the identity. You have to create a contained user for the Synapse workspace's managed identity in the database and grant it read access: ```sql CREATE USER [jsynapse] FROM EXTERNAL PROVIDER; ALTER ROLE db_datareader ADD MEMBER [jsynapse]; -- add db_da…