avm-res-sql-managedinstance

Azure/avm-res-sql-managedinstance/azurerm

Terraform Module HCL AZURERM ✓ Verified

Terraform Azure Verified Resource Module for SQL Managed Instance

Install

module "avm-res-sql-managedinstance" {

source = "Azure/avm-res-sql-managedinstance/azurerm"

version = "0.2.0"

}

⭐ Source on GitHub 📦 Registry page

README

AVM module for SQL Managed Instance This is an Azure Verified Modules for SQL Managed Instances. The module supports the following capabilities: All supported AzureRM parameters for the azurerm_mssql_managed_instance resource. Advanced Threat Protection, enabled by default. Vulnerability Assessments & Security Access Policies with a restricted storage account (supplied via storage_account_resource_id) Configuration for a failover group A map of databases, along with support for all parameters, such as long term backup retention policies. > [!IMPORTANT] > As the overall AVM framework is not GA (generally available) yet - the CI framework and test automation is not fully functional and implemented across all supported languages yet - breaking changes are expected, and additional customer fee

Inputs (42)

Name	Type	Description	Default
location	string	Azure region where the resource should be deployed.	required
resource_group_name	string	The resource group where the resources will be deployed.	required
administrator_login	string	(Required) The administrator login name for the new SQL Managed Instance. Changi	required
license_type	string	(Required) What type of license the Managed Instance will use. Possible values a	required
subnet_id	string	(Required) The subnet resource id that the SQL Managed Instance will be associat	required
administrator_login_password	string	(Required) The password associated with the `administrator_login` user. Needs to	required
vcores	number	(Required) Number of cores that should be assigned to the SQL Managed Instance.	required
storage_size_in_gb	number	(Required) Maximum storage space for the SQL Managed instance. This should be a	required
name	string	The name of the this resource.	required
sku_name	string	(Required) Specifies the SKU Name for the SQL Managed Instance. Valid values inc	required
timezone_id	string	(Optional) The TimeZone ID that the SQL Managed Instance will be operating in. D	`null`
enable_telemetry	bool	This variable controls whether or not telemetry is enabled for the module. For m	`true`
role_assignments	map(object({ role_definiti	A map of role assignments to create on this resource. The map key is deliberatel	`{}`
active_directory_administrator	object({ login_username =	- `login_username` - (Required) The login name of the principal to set as the Ma	`{}`
maintenance_configuration_name	string	(Optional) The name of the Public Maintenance Configuration window to apply to t	`null`
memory_size_in_gb	number	(Optional) Memory size in GB for the SQL Managed Instance. Allows flexible memo	`null`
transparent_data_encryption	object({ auto_rotation_ena	- `auto_rotation_enabled` - (Optional) When enabled, the SQL Managed Instance wi	`{}`
retry	object({ mssql_managed_ins	The AzAPI resource retry configuration, per resource type. Will retry up to the	`{}`
is_general_purpose_v2	bool	(Optional) Whether or not this is a GPv2 (Next-gen General Purpose) variant of G	`false`
private_endpoints	map(object({ name = option	A map of private endpoints to create on this resource. The map key is deliberate	`{}`
advanced_threat_protection_enabled	bool	(Optional) Whether to enabled Defender for SQL Advanced Threat Protection.	`true`
storage_account_type	string	(Optional) Specifies the storage account type used to store backups for this dat	`"ZRS"`
diagnostic_settings	map(object({ name	A map of diagnostic settings to create on the Key Vault. The map key is delibera	`{}`
managed_identities	object({ system_assigned	Controls the Managed Identity configuration on this resource. The following prop	`{}`
tags	map(string)	(Optional) Tags of the resource.	`null`
collation	string	(Optional) Specifies how the SQL Managed Instance will be collated. Default valu	`null`
storage_account_resource_id	string	(Optional) Storage Account to store vulnerability assessments. The System Assig	`null`
lock	object({ kind = string	Controls the Resource Lock configuration for this resource. The following proper	`null`
private_endpoints_manage_dns_zone_group	bool	Whether to manage private DNS zone groups with this module. If set to false, you	`true`
minimum_tls_version	string	(Optional) The Minimum TLS Version. Default value is `1.2` Valid values include	`"1.2"`
… and 2 more inputs

Outputs (8)

is_general_purpose_v2 — Whether the SQL Managed Instance is using the Next-gen General Purpose (GPv2) service tier.

memory_size_in_gb — The actual memory size in GB allocated to the SQL Managed Instance.

private_endpoints — A map of the private endpoints created.

resource — This is the full output for the resource.

resource_id — This is the resource ID of the resource.

service_principal — The system-assigned service principal details for the SQL Managed Instance. Required for Windows Aut

storage_iops — The actual storage IOPS allocated to the SQL Managed Instance.

identity — Managed identities for the SQL MI instance. This is not available from the `resource` output becaus

Resources (12)

azapi_resource_actionazurerm_management_lockazurerm_monitor_diagnostic_settingazurerm_mssql_managed_databaseazurerm_mssql_managed_instanceazurerm_mssql_managed_instance_failover_groupazurerm_mssql_managed_instance_transparent_data_encryptionazurerm_private_endpointazurerm_private_endpoint_application_security_group_associationazurerm_role_assignmentmodtm_telemetryrandom_uuid

Details

FrameworkTerraform Module

LanguageHCL

Version0.2.0

Cloud AZURERM

★ Stars0

Forks14

Total downloads31.4k

Inputs42

Outputs8

Resources12

Examples1

LicenseMIT

NamespaceAzure

Updated