Unable to create synapse workspace - property 'name' not found in 'sku'

robjkc 0 Reputation points
2024-12-24T05:57:21.6+00:00

I'm trying to create a new synapse workspace and receive the following error.

{
  "code": "DeploymentFailed",

  "message": "At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-deployment-operations for usage details.",
  "details": [
    {
      "code": "InvalidRequestContent",
      "message": "The request content was invalid and could not be deserialized: Required property 'name' not found in 'sku'."
    }
  ]
}
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.
5,098 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Smaran Thoomu 18,795 Reputation points Microsoft Vendor
    2024-12-24T12:06:53.6166667+00:00

    Hi @robjkc
    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-nz/answers/questions/2128422/how-to-fix-this-error-the-request-content-was-inva

    Hope this helps. Do let us know if you 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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.