Delete unused synapse managedrdg

Frederic 20 Reputation points
2023-03-01T15:07:58.78+00:00

Hello,

I have the following issue:

  • I have 2 synapse managedrg resource groups (but only one synapse workspace and resource group)
  • It seems that I have 1 synapse-managedrdg that is not linked to any synapse rdg and I would like to delete it (It may be linked to an issue while creating the synapse resources by script). Apparently it is the one located in East US that is not linked to my synapse RG. I am unable to delete it because of a deny assignment. The deny assignment cannot be modified.

Is there a way to confirm that this synapse-managed-rdg is not used by any synapse workspace and delete it?

User's image

User's image

Thank you!

Frederic

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,323 questions
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 37,656 Reputation points Microsoft Employee
    2023-03-03T16:24:43.6866667+00:00

    Hi Frederic Alizon,

    Thank you for posting query in Microsoft Q&A Platform.

    I researched a bit and find that with resource group name, we cannot get the corresponding synapse workspace name. But inside managed resource group, when we navigate to Resource Visualizer, we can see some in build SQL servers with the corresponding workspace name. This way we can locate the corresponding workspace names and then take a call to delete them or not.

    Please check below screenshots.

    User's image

    Hope this helps. Please let me know how it goes or if any further queries. Thank you.


    Please consider hitting Accept Answer button. Accepted answers help community as well.


0 additional answers

Sort by: Most helpful