Get auto-tune status for a SQL warehouse

User-configured backoff thresholds for the 7-day post-apply monitor.

Mirrors Snowflake's BackoffConfiguration shape (percentages, not raw ratios) but adds bounds validation Snowflake's never had — a threshold below 110% would trigger backoff on ordinary noise, and an absurdly high one (past 1000%) defeats the monitor's purpose entirely. Both default to 150 (allow up to 1.5x the baseline before treating it as a regression).

The current actionable recommendation, if any.

The 7-day post-apply monitoring window, if one is in progress or has produced a stabilized/backed-off value.

The most recent audit event for this warehouse, for a lightweight "last changed" display without a full audit-history fetch.

Whether the SP can currently enable auto-tune on this warehouse.

Surfaced on the status response so the FE can render the Auto Tune Switch disabled with a persistent reason (instead of a momentary toast on a failed enable) when the service principal lacks CAN_MANAGE. Fail-open: any credential/read/timeout error leaves blocked=False (the hard enable-gate in the toggle path still protects the mutation).