Deploying synapse workspace from arm template using New-AzResourceGroupDeployment

Aguilar, Rene 1 Reputation point
2022-05-02T22:32:33.187+00:00

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 DevTest Labs
Azure DevTest Labs
An Azure service that is used for provisioning development and test environments.
262 questions
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,668 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee
    2022-05-05T18:14:19.783+00:00

    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?