Resource Monitor CREDIT_QUOTA type about terraform-provider-snowflake HOT 3 CLOSED

locals {
  resource_monitor_name = "FOO_RESOURCE_MONITOR"
  credit_quote          = 100
  warehouse_name        = "FOO_WAREHOUSE"
}

resource "snowflake_resource_monitor" "resource_monitors" {
  lifecycle {
    ignore_changes = [
      # Ignore changes to credit quota as they are modified via a manual sql file
      credit_quota
    ]
  }

  name         = local.resource_monitor_name
  credit_quota = 0
}

resource "null_resource" "resource_monitor_credit_quotas" {
  depends_on = [snowflake_resource_monitor.resource_monitors]

  # Run the script every time apply is run
  triggers = {
    run_always = "${timestamp()}"
  }

  provisioner "local-exec" {
    command = "/usr/local/bin/snowsql -o variable_substitution=true  -f ${path.module}/update-quotas.sql --variable resource_monitor=${snowflake_resource_monitor.resource_monitors.name} --variable credit_quota=${local.credit_quote}"
  }
}

resource "snowflake_warehouse" "warehouses" {
  name             = local.warehouse_name
  resource_monitor = snowflake_resource_monitor.resource_monitors.name
}