Deployment Failed in Azure Synapse: SKU 'name' missing error

Question

"I'm trying to deploy an Azure Synapse Workspace and keep encountering the following error:

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

The full error is:

{

"code": "DeploymentFailed",

"message": "At least one resource deployment operation failed.",

"details": [

{

  "code": "InvalidRequestContent",

  "message": "The request content was invalid and could not be deserialized: Required property 'name' not found in 'sku'."

}

]

}

Answer 1

Hi @azizure
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:Copy

    "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:YAMLCopy

    "sku": {
        "name": "Standard"
      }
  

  Use "Standard" for the default Synapse workspace SKU.
• Example of a Correct Deployment of Synapse workspace:JSONCopy

    {
        "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:SQLCopy

    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-nz/answers/questions/2128422/how-to-fix-this-error-the-request-content-was-inva
https://learn.microsoft.com/en-us/answers/questions/2136291/unable-to-create-synapse-workspace-property-name-n

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

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.