Synapse Dedicated SQL Pool

Connect to your database using a tool like the Microsoft SQL Server Management Studio, and execute the following query. Note that the <entra_sp_name> should be replaced with the name of the Microsoft Entra Managed Identity or the Microsoft Entra Service Principal, depending on which authentication method you are using.

CREATE USER [<entra_sp_name>] FROM EXTERNAL PROVIDER;
 
EXEC sp_addrolemember 'db_datareader', '<entra_sp_name>';
EXEC sp_addrolemember 'db_datawriter', '<entra_sp_name>';