Unable to put a lake DB using azure rest API

Question

I m trying to create a lake DB from github actions using a json
Im following the rest API documentation
https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/put-database/put-database?view=rest-synapse-data-plane-2021-04-01&tabs=HTTP#ddltype

Im using this payload also tried changing it multiple ways but always gives the error
{

"Code": "InvalidSasDdlPayload",

"Message": "Bad request. Invalid DDL payload property \u0027createorUpdatePayload\u0027 for \u0027database-testDB\u0027"

}

what is the issue

Answer 1

Hi @Hitesh BK

Thanks for the question and using MS Q&A platform.

The error message "InvalidSasDdlPayload" with the message "Bad request. Invalid DDL payload property 'createorUpdatePayload' for 'database-testDB'" indicates that there is an issue with the payload that you are sending to create or update the database in Azure Synapse Analytics.

Based on the error message, it seems that there is a typo in the payload property name. The correct property name is "createOrUpdatePayload" (note the capitalization of "O" and "U"), but the error message shows "createorUpdatePayload" (missing the capital "O").

To resolve this issue, you should update the payload property name to "createOrUpdatePayload" and try again. Here is an example payload that you can use:

{

    "location": "<location>",

    "properties": {

        "collation": "<collation>",

        "maxSizeBytes": "<maxSizeBytes>",

        "readScale": "<readScale>",

        "requestedServiceObjectiveId": "<requestedServiceObjectiveId>"

    },

    "createOrUpdatePayload": {

        "name": "<databaseName>",

        "sku": {

            "name": "<skuName>",

            "tier": "<skuTier>"

        }

    }

}

Make sure to replace the placeholders with the appropriate values for your database.

I hope this helps! Let me know if you have any further questions.