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...?
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:
Creating a lake database manually is the only option, as demonstrated below:
- terraform tags for list variable not working
- Terraform 13, Validate variable base on the value of another
- How do I reference a resource created from different module in my current module?
- Terraform - GCP - Import project IAM member
- Creating an Azure Linux VM with Ubuntu 20.04 with Terraform
- Terraform doesn't allow to use variable when creating resource. How to go around?
- Authenticating using the Azure CLI is only supported as a User (not a Service Principal)
- Terraform outputs 'Error: Variables not allowed' when doing a plan
- Issue with Azure key vault and Azure storage account deployment
- temporary_name_for_rotation must be specified when changing any of the following properties: pod_subnet_id
- Why is TF build failing with "Error refreshing state: HTTP remote state endpoint requires auth"?
- With Gitlab, in the CI/CD pipeline, how can I dynamically create and save SSH key pairs as CI/CD project variables?
- Conditionally add element to existing map
- Parse HCL block into Golang map
- Run an AWS ECS task
- Terraform Error: Error locking state: Error acquiring the state lock: 2 errors occurred:
- Terraform: Error: retrieving static website properties for Storage Account (Subscription: *** : context deadline exceeded
- How to add additional security groups to EKS cluster?
- How to use a blue/green deployment style with CodeDeploy and Auto Scaling Groups that allows for repetitive deployments in Terraform?
- Self referenced Security group inbound rule in AWS RDS terraform?
- How to run this terraform nested for loop?
- Error: Failure when executing a Terraform Resource creation request
- Conditionally add property to object
- Registering a private endpoint in Azure private DNS automatically using Terraform
- How to deal with "Error: Duplicate object key" in Terraform
- Unable to use VARs from a tfvars file in Terraform
- Terraform AWS Provider: SecretsManager can't apply because version was deleted
- Experimenting Locally with Terraform
- Upgrade terraform to specific version
- When I used Terraform to organize Docker for deployment, pulling the image failed