azurerm_mssql_database - support free limit attributes

Is there an existing issue for this?

[X] I have searched the existing issues

Community Note

Please vote on this issue by adding a :thumbsup: 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

A preview feature has recently become available to enable up to enable one database per subscription with free limits included

This tier is only valid for serverless SKUs GP_S_Gen5_XXX from my understanding

Exporting from exporting an ARM template in the azure portal, I found these two attributes which are new.

     "type": "Microsoft.Sql/servers/databases",
     "apiVersion": "2022-08-01-preview",
///
        "useFreeLimit": {
            "value": true
        },
        "freeLimitExhaustionBehavior": {
            "value": "AutoPause"
        },

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

azurerm_mssql_database

Potential Terraform Configuration

resource "azurerm_mssql_database" "example" {
  name           = "yyy"
  server_id      = "xxx"
  collation      = "SQL_Latin1_General_CP1_CI_AS"
  license_type   = "LicenseIncluded"
  max_size_gb    = 32
  sku_name       = "GP_S_Gen5_2"

  use_free_limit = true
  free_limit_exhaustion_behavior = "AutoPause"
}

References

https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer-faq?view=azuresql https://learn.microsoft.com/en-us/azure/templates/microsoft.sql/servers/databases?pivots=deployment-language-arm-template

hashicorp / terraform-provider-azurerm