question

AguilarRene-3594 avatar image
0 Votes"
AguilarRene-3594 asked KranthiPakala-MSFT answered

Deploying synapse workspace from arm template using New-AzResourceGroupDeployment

Hello rather new to arm and synapse, currently attempting to deploy synapse workspace and pools using the PowerShell command for arm deployment due to policy issues preventing the use of the task.
Created a synapse workspace and connected to git repo to get the template for workspace and parameter json files, passing those two files
New-AzResourceGroupDeployment -ResourceGroupName '${ { parameters.ResourceGroupName }}' -TemplateFile .\TemplateForWorkspace.json -TemplateParameterFile .\TemplateParametersForWorkspace.json -Mode Incremental

3 | New-AzResourceGroupDeployment -ResourceGroupName 'rg-synapse-wo …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| 8:31:34 PM - Error: Code=InvalidTemplateDeployment;
| Message=The template deployment failed with multiple errors.
| Please see details for more information.


Question is what changes must be made to the default arm template created in the git repo to be able to deploy the workspace and pools using arm.
And as a follow up is there a powershell alternative for synaplse deployment task other than manually having to deploy them with seperate powershell az synapse commands.
198382-parameters.txt198346-workspace.txt


azure-synapse-analyticsazure-dtl-arm-enviorments
parameters.txt (666 B)
workspace.txt (18.3 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered

Hello @AguilarRene-3594,

Thanks for the question and using MS Q&A platform.

In general, below are few details that you will have to update,

  • Subscription

  • Resource group

  • Region

  • Workspace Name

  • Storage account details that needs to be associated with your workspace.

  • SQL Administrator login Username

  • SQL Administrator password for the SQL Server

  • SQL pool names

  • Tag Values

And as a follow up is there a powershell alternative for synaplse deployment task other than manually having to deploy them with seperate powershell az synapse commands. - Do you mean is there any alternate to deploy ARM templates other than Powershell?





· 5
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AguilarRene-3594 avatar image AguilarRene-3594 ·

Thanks for the reply, for the follow up question I was asking if there was a PowerShell alternative for the synapse development task in the released pipeline for moving the synapse artifacts, since it is possible to deploy arm templates using PowerShell instead of the arm task in the release pipelines.

0 Votes 0 ·
KranthiPakala-MSFT avatar image KranthiPakala-MSFT AguilarRene-3594 ·

Hello @AguilarRene-3594,

The Az Synapse powershell commands are for creating one artifact at a time. The commands do not take arm template as input. They take the JSON definition of the artifact.
There is no bulk deployment powershell cmdlets specific to synapse. We will have to go with New-AzResourceGroupDeployment.

Hope this clarifies.

Thank you







0 Votes 0 ·
KranthiPakala-MSFT avatar image KranthiPakala-MSFT KranthiPakala-MSFT ·

Hello @AguilarRene-3594,

Just checking in to see if the above information was helpful. And, if you have any further query do let us know.

0 Votes 0 ·
Show more comments