Skip to content

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.tf
  • modules/databases/mssql_database/db_permissions.tf
  • modules/databases/mssql_database/diagnostic.tf
  • modules/databases/mssql_database/locals.tf
  • modules/databases/mssql_database/locals_mssql_database.tf
  • modules/databases/mssql_database/main.tf
  • modules/databases/mssql_database/outputs.tf
  • modules/databases/mssql_database/variables.tf