Azure Synapse deployment failure

Question

Azure Synapse deployment failure

Croydyn Berly 0

While creating azure synapse analytics when i deploy the deployment fails with the following error .

The request content was invalid and could not be deserialized: Required property 'name' not found in 'sku'. (Code: InvalidRequestContent)

Please help me resolve this error

Ganesh Gurram 7,235 Reputation points Moderator

2024-12-31T06:27:39.2166667+00:00
Hi @Croydyn Berly

Welcome to Microsoft Q&A platform and thanks for posting your query here.

Based on the error message indicates that the deployment is failing because the sku property in your Synapse workspace deployment is missing the required name field.

Check the ARM template or the configuration file you are using to deploy the Synapse workspace. Look for a section like this:
"sku": {}
The issue arises because the name field is not included in the sku object.

The sku property requires a name field that specifies the service level for your Synapse workspace. For example:
"sku": { "name": "Standard" }

Use "Standard" for the default Synapse workspace SKU.

Example of a Correct Deployment of Synapse workspace:
{ "type": "Microsoft.Synapse/workspaces", "apiVersion": "2021-06-01", "name": "[parameters('workspaceName')]", "location": "[parameters('location')]", "sku": { "name": "Standard" }, "properties": { "defaultDataLakeStorage": { "accountUrl": "[parameters('accountUrl')]", "filesystem": "[parameters('filesystem')]" }, "sqlAdministratorLogin": "[parameters('sqlAdminLogin')]", "sqlAdministratorLoginPassword": "[parameters('sqlAdminPassword')]" } }

After adding the sku field, validate the template to ensure there are no syntax errors. You can use the Azure portal, CLI, or PowerShell to validate:
az deployment group validate --resource-group <resource-group> --template-file <template-file>

Once validated, proceed to redeploy the Synapse workspace using your preferred method (Azure portal, CLI, etc.).

Similar issue posted in Q&A forum: https://learn.microsoft.com/en-us/answers/questions/2136291/unable-to-create-synapse-workspace-property-name-n

https://learn.microsoft.com/en-nz/answers/questions/2128422/how-to-fix-this-error-the-request-content-was-inva

Hope this helps. Do let us know if you have any further queries.
Croydyn Berly 0 Reputation points

2024-12-31T16:03:33.6466667+00:00

Can you please guide me on how to edit the ARM template because it seems that ARM template is in read only format and not editable
Croydyn Berly 0 Reputation points

2024-12-31T16:06:07.67+00:00

Hi Ganesh

Thanks for your response . Can you please guide me on how to edit the ARM template as currently its in read only format and non editable .
Ganesh Gurram 7,235 Reputation points Moderator

2025-01-02T19:08:20.41+00:00

@Croydyn Berly - To edit the ARM template, follow these steps:

Navigate to the Azure Synapse Workspace - In the Azure portal, go to your Synapse Analytics workspace.

Export the Template - Go to Automation in the Synapse workspace page.

Choose Export Template (this will download the ARM template as a JSON file).

Edit the Template - Open the exported template file in any text editor (e.g., Visual Studio Code or Notepad++) and locate the sku section. Add the "name": "Standard" field under "sku".

For further details, please refer to the article that discusses a similar issue: https://www.reddit.com/r/AZURE/comments/1hld1j1/comment/m3lltj8/

Similar issue for reference: https://learn.microsoft.com/en-us/answers/questions/2139592/how-to-fix-the-error-while-creating-azure-synapse

I hope this information helps. Please do let us know if you have any further queries.
Ganesh Gurram 7,235 Reputation points Moderator

2025-01-03T16:12:35.4066667+00:00

@Croydyn Berly - Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.