Deploying synapse workspace from arm template using New-AzResourceGroupDeployment

Question

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

Answer 1

Hello @Aguilar, Rene ,

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?