Share via

Azure Synapse Analytics - Resource Class assignment to Active Directory Group

XchangeVisions 306 Reputation points
2020-09-30T12:41:26.59+00:00

I've assigned resource_class to a specific Active Directory group, but the user within that group gets the default resource_class assigned when executing queries.

User X is assigned to AD group Y.
Y is assigned to 'mediumrc' but the execution request of X get the default resource_class 'smallrc'.

Do we need to execute sp_addrolemember per user or should it be possible to add an AD group?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
Accepted answer
  1. XchangeVisions 306 Reputation points
    2020-10-05T10:21:25.34+00:00

    User is assigned to the AAD Admin usergroup.
    Added the 'dbo' role to the classifier and now it's assigned the expected resource class.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
    2020-10-02T19:48:30.01+00:00

    Hi @XchangeVisions ,

    Update: It is likely the user or group is part of the AAD admin which by default is routed to smallrc. Could you please creating a workload classifier on the ‘dbo’ role to mediumrc and that should address the situation.

    Please let us know how it goes.

    Thank you

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.