databases/mssql_database¶
Overview¶
This page documents the Terraform module implementation, key configuration surfaces, and how it integrates with CAF.
Dependency diagram (Mermaid)¶
graph TD
azurecaf_name.mssqldb["azurecaf_name.mssqldb"]
azurerm_mssql_database.mssqldb["azurerm_mssql_database.mssqldb"]
data.azurerm_storage_account.mssqldb_tdp["data.azurerm_storage_account.mssqldb_tdp"]
module.diagnostics["module.diagnostics"]
null_resource.set_db_permissions["null_resource.set_db_permissions"]
null_resource.set_db_permissions_with_logged_in["null_resource.set_db_permissions_with_logged_in"]
azurerm_mssql_database.mssqldb --> azurecaf_name.mssqldb
azurerm_mssql_database.mssqldb --> data.azurerm_storage_account.mssqldb_tdp
module.diagnostics --> azurerm_mssql_database.mssqldb
null_resource.set_db_permissions --> azurerm_mssql_database.mssqldb
null_resource.set_db_permissions_with_logged_in --> azurerm_mssql_database.mssqldb
Module Reference¶
Category: databases
Path: modules/databases/mssql_database
Azure Resources: azurecaf_name, azurerm_mssql_database, null_resource
Inputs¶
| Name | Description | Type | Required | Default | Validation |
|---|---|---|---|---|---|
"global_settings" |
"Global settings object (see module README.md)" | any |
yes | - |
- |
"cloud" |
any |
yes | - |
- | |
"location" |
any |
yes | - |
- | |
"settings" |
"The settings for the Azure resource." | any |
yes | - |
- |
"server_id" |
any |
yes | - |
- | |
"server_name" |
any |
yes | - |
- | |
"storage_accounts" |
any |
yes | - |
- | |
"elastic_pool_id" |
any |
no | - |
- | |
"base_tags" |
"Base tags for the resource to be inherited from the resource group." | map(any) |
yes | - |
- |
"sqlcmd_dbname" |
any |
no | - |
- | |
"managed_identities" |
any |
no | - |
- | |
"diagnostic_profiles" |
any |
no | {} |
- | |
"diagnostics" |
any |
no | - |
- |
Outputs¶
| Name | Description | Sensitive | Value |
|---|---|---|---|
"id" |
- | azurerm_mssql_database.mssqldb.id |
|
"name" |
- | azurerm_mssql_database.mssqldb.name |
|
"server_id" |
- | azurerm_mssql_database.mssqldb.server_id |
|
"server_name" |
- | var.server_name |
|
"server_fqdn" |
- | local.server_name |
Sources¶
modules/databases/mssql_database/database.tfmodules/databases/mssql_database/db_permissions.tfmodules/databases/mssql_database/diagnostic.tfmodules/databases/mssql_database/locals.tfmodules/databases/mssql_database/locals_mssql_database.tfmodules/databases/mssql_database/main.tfmodules/databases/mssql_database/outputs.tfmodules/databases/mssql_database/variables.tf