Automations

Hands-free optimizations that continuously reduce your Snowflake compute spend while keeping performance intact.

Seemore's automation features actively manage your Snowflake warehouses in real time — suspending idle resources, scaling multi-cluster capacity based on load, right-sizing on a schedule, and protecting against sudden query spikes.

All automations are production-safe — no active queries are ever interrupted.

---

Auto Shutdown

Instantly suspends idle warehouses and eliminates unnecessary idle spend.

Auto Scaler

Scales multi-cluster warehouses in based on real-time query load.

Smart Pulse

Builds an hourly schedule to right-size warehouse capacity across the week.

Live Tuning

Temporarily override warehouse configuration for high query load, with automatic revert.

---

Managing warehouses with Terraform (or other IaC)

If you manage your Snowflake warehouses with Terraform (or another infrastructure-as-code tool), be aware that SeeMore automations tune warehouse settings at runtime — warehouse size, the idle (auto-suspend) timeout, and multi-cluster limits. Because those values now change outside of Terraform, your next terraform plan will show drift and a terraform apply would revert SeeMore's optimizations back to your baseline.

To avoid this, tell Terraform to ignore the attributes SeeMore manages by adding a lifecycle { ignore_changes = [...] } block to the warehouse resource. Terraform still creates and owns the warehouse; it just stops fighting SeeMore over the runtime-tuned attributes.

Add the ignore_changes block before you enable automations on a warehouse. Otherwise the first terraform apply after enabling them will overwrite SeeMore's tuning.

resource "snowflake_warehouse" "analytics" {
  name           = "ANALYTICS_WH"
  warehouse_size = "MEDIUM"   # baseline; SeeMore scales this at runtime
  auto_suspend   = 300        # baseline; SeeMore tunes the idle timeout
  auto_resume    = true

  # multi-cluster
  min_cluster_count = 1
  max_cluster_count = 3
  scaling_policy    = "STANDARD"

  lifecycle {
    ignore_changes = [
      warehouse_size,      # size scaling
      auto_suspend,        # idle-timeout tuning
      min_cluster_count,   # multi-cluster scaling
      max_cluster_count,
      scaling_policy,
    ]
  }
}

Keep only the attributes that the automations you enable actually change. For example, if you only use Auto Shutdown, ignoring auto_suspend is enough; add the multi-cluster attributes when you enable Auto Scaler or Smart Pulse.