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. However, if the consumer has set a maintenance policy, the upgrade is delayed until the start date and time specified in the maintenance policy.

To create and set a maintenance policy, the consumer uses the following SQL commands:

• CREATE MAINTENANCE POLICY: Creates a new maintenance policy. The customer sets a schedule for the maintenance policy to allow upgrades to begin at a specific time.

To view and manage maintenance policies, the consumer uses the following SQL commands:

• ALTER MAINTENANCE POLICY: Modifies an existing maintenance policy.

• ALTER ACCOUNT: Applies or removes a maintenance policy for all apps in the account.

• ALTER APPLICATION: Applies or removes a maintenance policy for a specific app.

• SHOW MAINTENANCE POLICIES: Lists the maintenance policies for the specified account or app.

• DESCRIBE MAINTENANCE POLICY: Shows the details of a maintenance policy.

• DROP MAINTENANCE POLICY: Removes a maintenance policy from the current or specified schema.

Note the following details about consumer-controlled maintenance policies:

• If a consumer does not set a maintenance policy, the upgrade begins when the default upgrade time is reached. For more information, see Maintenance window.

• Only the start time for a maintenance policy can be specified; not the end time or the duration of the maintenance policy.

• Each app or account can only have one maintenance policy set.

• The provider can set a maintenance deadline for an upgrade, so that the consumer can’t postpone the upgrade indefinitely. As a consumer, you should schedule your upgrades as soon as possible during a time when you can be available to test the upgrade and make any necessary adjustments, so that you can avoid having your app become unexpectedly unavailable during an upgrade.

CREATE MAINTENANCE POLICY my_maintenance_policy
  SCHEDULE = 'USING CRON 0 2 * * SAT UTC'
  COMMENT = 'Weekly Saturday maintenance policy';

ALTER ACCOUNT SET MAINTENANCE POLICY my_maintenance_policy FOR ALL APPLICATIONS;

ALTER APPLICATION my_app SET MAINTENANCE POLICY my_maintenance_policy;