Search code examples
terraformazure-synapseterraform-provider-azureazure-cli

Azure Synapse - How to Create a Synapse Lake Database / Serverless Database via Terraform or Azure CLI

I am using Terraform scripts via Azure devOps Pipelines to create the underlying Azure Resources.

There is no a requirement to create a "Lake Database / Serverless Database" under Synapse.

I've had a look at the Terraform docs. but can't see any TF command that does this - I may well be missing something.

Is there a TF command to create a "Lake Database / Serverless Database" under Synapse ?

OR

Another method that can be automated - maybe an Azure CLI command(s) - again I could not find anything...?

Solution

  • As per this, Terraform does not support creating serverless databases or lake databases, and there is no CLI script available for this purpose. You can create a serverless SQL database using the SQL script below:

    CREATE DATABASE db

    This script will create a serverless SQL database successfully, as shown below:

    enter image description here

    Creating a lake database manually is the only option, as demonstrated below:

    enter image description here