Synapse Analytics Dedicated SQL Pool - user not assigned to workload classifier

Anonymous
2022-10-17T11:08:05.657+00:00

I created a new user to the dedicate sql pool: CREATE LOGIN [testwg] WITH PASSWORD=N'*****' GO CREATE USER testwg FROM LOGIN testwg GO EXEC sp_addrolemember 'db_datareader', 'testwg' I created a new workload group: CREATE WORKLOAD GROUP w_group1 WITH ( MIN_PERCENTAGE_RESOURCE = 0 , CAP_PERCENTAGE_RESOURCE = 50 , REQUEST_MIN_RESOURCE_GRANT_PERCENT = 25 ,REQUEST_MAX_RESOURCE_GRANT_PERCENT = 25 ,IMPORTANCE = NORMAL ) and I created a new classifier assigned to the previous group and user: CREATE WORKLOAD CLASSIFIER w_classifier1 WITH ( WORKLOAD_GROUP = 'w_group1' ,MEMBERNAME = 'testwg' ,WLM_LABEL = 'test_label' ,IMPORTANCE = NORMAL) but when I run a query with the testwg user, this user seems not assigned to the correct classifier: ![251055-chrome-c316qjdmxl.png][1] [1]: /api/attachments/251055-chrome-c316qjdmxl.png?platform=QnA

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.
4,479 questions
{count} votes

Accepted answer
  1. BhargavaGunnam-MSFT 27,661 Reputation points Microsoft Employee
    2022-10-19T20:04:57.997+00:00

    Hello anonymous user,

    The problem seems to be with the label in the work load classifier. Can you please remove the WLM_LABEL and try again(this is optional parameter)

    ,WLM_LABEL      = 'test_label'  
    

    252164-image.png

    If you are using label, make sure to use 'option (label ='test_label') in your query.

    Please use the below syntax:

     CREATE WORKLOAD CLASSIFIER w_classifier1 WITH    
     ( WORKLOAD_GROUP = 'w_group1'  
      ,MEMBERNAME     = 'testwg'    
      ,IMPORTANCE = NORMAL)  
    

0 additional answers

Sort by: Most helpful