Support failover rights for azurerm_mssql_managed_instance_failover_group via secondaryType property

[adamzeyinsurity]

Is there an existing issue for this?

• I have searched the existing issues

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment and review the contribution guide to help.

Description

In order to enable failover rights on a SQLMI failover group, we need to set the "secondaryType" field to "Standby". However, azurerm does not expose this field.

I found a prior issue covering this (#20401) that was closed because the REST API did not support the secondaryType field. However, checking the Azure documentation (https://learn.microsoft.com/en-us/rest/api/sql/instance-failover-groups/create-or-update) this field was added to the API in version 2022-05-01-preview, well before that issue was filed in 2023.

New or Affected Resource(s)/Data Source(s)

azurerm_mssql_managed_instance_failover_group

Potential Terraform Configuration

https://github.com/hashicorp/terraform-provider-azurerm/issues/20401
https://learn.microsoft.com/en-us/rest/api/sql/instance-failover-groups/create-or-update

References

No response