SQL Database

Overview

{
    "sql_database": {
        "name": "sql-db-lp-test-{env}",
        "sku": { "name": "Standard", "capacity": "10"},
        "@sql_server_name": "sql-lp-test-{env}",

        "zone_redundant": true,
        "backup_redundancy": "Local",
        "size_in_bytes": 1073741824,
        "external": true,
        "resource_group_name": "my-rg-name",
        "tags": { "example": "S0" }
    }
}

SQL Server Database Reference

Key	Type	Description
name (required)	string	The name of the SQL Server Database(see how to name)
sku (required)	object of sku	The SKU of the database
@sql_server_name	string	The name of the SQL Server
zone_redundant	bool	Whether or not the database is zone redundant (defaults to false)
backup_redundancy	string	The redundancy of the database (defaults to Local)
size_in_bytes	int	The maximum size of the database in bytes (defaults to 1GB)
external	bool	A reference to an existing SQL Server Database (defaults to false)
resource_group_name	string	The name of the resource group where the resource is located, only with external resources (defaults to the resource group of the deployment)
tags	object	Additional tags for the resource (defaults to no additional tags)

---

SKU

Key	Type	Description
name (required)	string of name	The name of the SKU
capacity (required)	int	Capacity of the particular SKU

---

Name

Key	Description
Free	Only one is allowed per subscription
Basic	Good for development and production environments with low CPU usage (5ms read & 10ms write) DTUs
Standard	Good for development and production environments with low, medium and high CPU usage (5ms read & 10ms write), allows the usage of columnstore indexing Standard S3 or higher 3000 DTUs
Premium	Good for development and production environments with low, medium and high CPU usage (2ms read/write), allows the usage of columnstore indexing 4000 DTUs
GPGen5	(See detailed information about this tier here)
GPDC	(See detailed information about this tier here)
GPsGen5	(See detailed information about this tier here)
GPFsv2	(See detailed information about this tier here)

---