DESC SERVICE and SHOW SERVICES command: New column(s) in output (Pending)¶
Attention
This behavior change is in the 2025_01 bundle.
For the current status of the bundle, refer to Bundle History.
When this behavior change bundle is enabled, the output of the DESCRIBE SERVICE and SHOW SERVICES commands include the following new columns:
Column name |
Description |
|---|---|
SUSPENDED_ON |
Timestamp when the service was last suspended. SUSPENDED_ON is set when Snowflake suspends a service and remains unchanged even after the service is resumed. If SUSPENDED_ON is NULL, the service was never suspended. |
AUTO_SUSPEND_SECS |
Number of seconds of inactivity after which Snowflake automatically suspends the service. If AUTO_SUSPEND_SECS is set to 0 or never set, Snowflake does not automatically suspend the service. |
IS_ASYNC_JOB |
If TRUE, the job service is running asynchronously. By default, Snowflake executes the job services synchronously. This column is included in the output of the DESC SERVICE, SHOW SERVICES, and SHOW JOB SERVICES commands but not in the output of the SHOW SERVICES EXCLUDING JOBS command. |
Note
The SUSPENDED_ON and AUTO_SUSPEND_SECS columns appear after the existing RESUMED_ON column.
The IS_ASYNC_JOB column appears after the existing IS_JOB column.
Ref: 1849, 1867