-> Classifying managed identities (MI) behavior differs between the dedicated SQL pool in Azure Synapse workspaces and the standalone dedicated SQL pool (formerly SQL DW). While the standalone dedicated SQL pool MI maintains the assigned identity, Azure Synapse workspaces adds MI to the dbo role. This cannot be changed. The dbo role, by default, is classified to smallrc. Creating a classifier for the dbo role will allows for assigning a workload group other than smallrc. If dbo is too generic of a role, consider using label, session or time-based classification in conjunction with the dbo role classification.
0 commit comments