Issue while changing resource group in synapse sql

UD 21 Reputation points
2021-10-13T10:56:52.573+00:00

I am getting below error message while changing the resource group. Kindly help:

140258-image.png

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

Accepted answer
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2021-10-14T03:29:04.813+00:00

    Hi @UD ,

    Welcome to Microsoft Q&A forum and thanks for reaching out here.

    As per my understanding you are trying to move your Azure Synapse workspace from one resource group to another. Please correct if I misunderstood your requirement.

    Unfortunately as of now, it’s not possible to move Azure Synapse Analytics workspace across resource groups, subscriptions and tenants. But product team is actively working on delivering this feature. But we do not have an ETA at the moment.

    You can refer to this doc where it confirms that the move operation isn't supported for Azure Synapse resource type: Microsoft.Synapse - Move Operation

    140366-image.png

    But in the mean time as a workaround you can try below:

    • Azure SQL scripts, Notebook can be imported/exported from Azure Synapse Studio.
    • For pipelines, linked services you can download the support files and copy the JSON template and create a new pipeline using the same JSON template. (As explained in this thread - Azure Data Factory V2 Arm template to Synpase Data Integration without Git)
    • You can also use Azure PowerShell modules for to import and export.

    For more details, refer Az.Synapse.

    Hope this helps. Do let us know if you any further queries.

    ----------

    • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

0 additional answers

Sort by: Most helpful