Source
Consumer-controlled maintenance policies
With Snowflake Native Apps, consumers can set a maintenance policy for an upgrade so that apps don’t update during specific time periods. When an upgrade is ready and a new release directive is set, the upgrade begins.
SYSTEM$GET_COMPUTE_POOL_PENDING_MAINTENANCE
Returns a JSON object that provides an indication of whether maintenance is required and the upcoming maintenance window timeline.