Configure threads_per_core in subblock settings.advanced_machine_features for SQL Server

[arouxAgicap]

TL;DR

Hi !
It would be nice to be able to edit number of threads per core in a SQL Server instance on Cloud SQL.
As the subblock contains only on element we could define it like :

dynamic "advanced_machine_features" {
      for_each = var.threads_per_core == 1 ? [var.threads_per_core] : []
      content {
        threads_per_core = var.threads_per_core
      }
    }

and variable could be defined like this :

variable "threads_per_core" {
  description = "The number of threads per core. Can be 1 or 2. To disable SMT, set this flag to 1. Only for SQL Server instances"
  type = number
  default = 2
}

Terraform Resources

https://registry.terraform.io/providers/hashicorp/google/latest/docs/resources/sql_database_instance#threads_per_core-1

Detailed design

No response

Additional information

I had the occasion to test it locally without problem. If value set to 1 subblock is created. value isn't set, set to 2 or more, subblock is not created and default settings remains.