azurerm_mssql_database with DW SKU doesn't support retention policies

[favoretti]

Error: Error retrieving Long Term Policies for Database "centralus-fxs-apollo-np-dwh-dwh-qa-sqldb" (Sql Server "centralus-fxs-apollo-np-dwh-qa-sqls" ;Resource Group "centralus-fxs-apollo-np-qa-rg"): sql.BackupLongTermRetentionPoliciesClient#Get: Failure responding to request: StatusCode=400 -- Original Error: autorest/azure: Service returned an error. Status=400 Code="LongTermRetentionPolicyNotSupported" Message="Long Term Retention is not supported : Not supported for database with DataWarehouse edition."

[ghost]

This has been released in version 2.33.0 of the provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading. As an example:

provider "azurerm" {
    version = "~> 2.33.0"
}
# ... other configuration ...

[ghost]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 [email protected]. Thanks!