Shows health metrics, circuit breaker state, and maintenance scheduler status for a table.
DESCRIBE MAINTENANCE STATUS <table>## Overview Displays the current maintenance health of a Delta table, including circuit breaker state, scheduled maintenance operations, and key health metrics. This command is the primary diagnostic tool for understanding whether a table's automated maintenance is operating normally or has been halted due to errors. ## Behavior - Returns a result set with key-value rows describing the table's maintenance state. - Shows the circuit breaker state (Closed, Open, or Half-Open) and the timestamp of the last state transition. - Reports the last successful and failed maintenance operations (VACUUM, OPTIMIZE, ANALYZE) with timestamps and error messages. - Displays pending maintenance tasks and their scheduled execution times. - Shows table health metrics: number of files, total size, number of deletion vectors, and time since last optimization. - The circuit breaker moves to the Open state after repeated maintenance failures, halting automated operations until manually reset with RESET CIRCUIT BREAKER. ## Access Control No specific privilege required beyond table-level access. ## Compatibility DESCRIBE MAINTENANCE STATUS is a DeltaForge extension for monitoring automated table maintenance.
| Name | Type | Description |
|---|---|---|
table | Specifies the Delta table for which to display maintenance status. Accepts a table name or storage path. |
-- Show maintenance status for a table
DESCRIBE MAINTENANCE STATUS orders;-- Check maintenance status using a fully qualified name
DESCRIBE MAINTENANCE STATUS warehouse.sales.transactions;-- Check status for a table referenced by path
DESCRIBE MAINTENANCE STATUS 's3://bucket/tables/events';