Alerts in Snowsight¶

You can set up alerts for Snowflake features in Snowsight. This user interface simplifies how you monitor your Snowflake account.

Rather than executing SQL statements to create and manage alerts, you can use wizards in Snowsight to create, manage, and monitor your alerts.

The alerts management feature in Snowsight provides the following benefits:

Centralized visibility of alerts: In the Snowflake Alerts Center, you can view all alerts, the history of these alerts, and the execution status of these alerts.
Templates for creating alerts: You can quickly create alerts for the following features by using the alert templates provided in the Snowflake Alerts Center. You don’t need to write SQL statements to create these alerts.
Proactive monitoring of Snowflake features: You can easily configure notifications for failures, latency, or data anomalies to ensure your pipelines and budgets remain healthy.

Prerequisites¶

Before you can use Snowsight to create, monitor, and manage alerts, you must fulfill the following prerequisites:

Prerequisites for task alerts¶

If you plan to create, manage, and monitor alerts on tasks, you must do the following:

Set the severity level of logged messages that you want to capture for task events.

The task alerts monitor error messages that are logged to the event table. You must set the LOG_LEVEL parameter to at least ERROR for the tasks that you want to monitor. You can set this parameter on one of the following types of objects:
- To set the severity level to ERROR on all objects in the account (including tasks), execute ALTER ACCOUNT SET LOG_LEVEL:
  ALTER ACCOUNT SET LOG_LEVEL = ERROR;
  Note
  
  This setting also affects the messages logged by UDFs, stored procedures, and dynamic tables.
- To set the severity level to ERROR on all objects in a database containing the tasks, execute ALTER DATABASE … SET LOG_LEVEL:
  ALTER DATABASE my_task_db SET LOG_LEVEL = ERROR;
  Note
  
  This setting also affects the messages logged by UDFs, stored procedures, and dynamic tables in that database.
- To set the severity level to ERROR for specific tasks, execute ALTER TASK … SET LOG_LEVEL:
  ALTER TASK my_task SET LOG_LEVEL = ERROR;
Verify the privileges that have been granted to the role that you plan to use to access Snowsight.

That role must be granted the privileges to query the TASK_HISTORY view and QUERY_HISTORY view in the ACCOUNT_USAGE schema.

For information, see Enabling other roles to use schemas in the SNOWFLAKE database.

Prerequisites for Openflow alerts¶

The Openflow alerts monitor events recorded to an event table. Make sure that Openflow is configured to log events. For information, see the following sections:

Set up an event table to log Openflow events (required) (if you are using Openflow BYOC)
[Optional] Configure an Openflow-specific event table (if you are using Openflow Snowflake)

Prerequisites for data quality alerts¶

Make sure that Data Metric Functions (DMF) are registered and are running against the tables and views that you want to monitor.

For information, see Use SQL to set up data metric functions.

Setting up email notifications for alerts¶

When you create an alert in Snowsight, you can configure the alert to send an email notification.

Note

Other types of notifications currently aren’t supported.

To send an email notification, you must use an email notification integration. You can either use an existing email notification integration or create a new one:

To find an existing email integration that you can use, run SHOW NOTIFICATION INTEGRATIONS and use the pipe operator to filter the results by "type" = 'email':
```
SHOW NOTIFICATION INTEGRATIONS ->> SELECT * FROM $1 WHERE "type" = 'EMAIL';
```
To create a new email notification integration, see Sending email notifications.

Creating a role for accessing alerts in Snowsight¶

To allow users other than the account administrator to access alerts in Snowsight, you can create a custom role that has been granted all of the privileges needed to create, manage, and monitor alerts. You can grant this role to users and other roles that need to use alerts in Snowsight.

For example, suppose that you want to create a role named my_alert_center_role for this purpose. To create this role, complete the following steps:

Switch to a role that is allowed to create your custom role (for example, the ACCOUNTADMIN role):
```
USE ROLE ACCOUNTADMIN;
```
Create your custom role:
```
CREATE OR REPLACE ROLE my_alert_center_role;
```
Grant the USAGE privilege on a warehouse that you plan to use when accessing alerts in Snowsight. You must grant this privilege because some of the features require an active warehouse.
```
GRANT USAGE ON WAREHOUSE my_warehouse TO ROLE my_alert_center_role;
```
Grant the privileges for executing alerts to the role:
- If you plan to create alerts that use a specific warehouse for execution, grant the following privileges to that role:
  - EXECUTE ALERT privilege on the account
  - USAGE privilege on the warehouse that you want to use for the alert
  For example:
  GRANT EXECUTE ALERT ON ACCOUNT TO ROLE my_alert_center_role; GRANT USAGE ON WAREHOUSE my_warehouse TO ROLE my_alert_center_role;
- If you plan to create a serverless alert, grant the EXECUTE MANAGED ALERT privilege on the account:
  GRANT EXECUTE MANAGED ALERT ON ACCOUNT TO ROLE my_alert_center_role;
Grant the privileges required to create alerts in a database and schema.

For example, if you plan to create the alerts in a database named my_alerts_database and in a schema named my_alert_schema, grant the USAGE privilege on that database and schema, and grant the CREATE ALERT privilege on the schema:
```
GRANT USAGE ON DATABASE my_alerts_database TO ROLE my_alert_center_role;
GRANT USAGE ON SCHEMA my_alerts_schema TO ROLE my_alert_center_role;
GRANT CREATE ALERT ON SCHEMA my_alerts_schema TO ROLE my_alert_center_role;
```
Grant the USAGE privilege on the email notification integration that you set up earlier:
```
GRANT USAGE ON INTEGRATION my_email_int TO ROLE my_alert_center_role;
```
Grant the application role that allows access to the default event table:
```
GRANT APPLICATION ROLE SNOWFLAKE.EVENTS_VIEWER TO ROLE my_alert_center_role;
```
If you plan to set up alerts for data quality monitoring, grant the application role and privileges required to monitor data quality and execute data metric functions:
```
GRANT APPLICATION ROLE SNOWFLAKE.DATA_QUALITY_MONITORING_VIEWER TO ROLE my_alert_center_role;
GRANT EXECUTE DATA METRIC FUNCTION ON ACCOUNT TO ROLE my_alert_center_role;
```

Grant the custom role to users or other roles:

GRANT ROLE my_alert_center_role TO USER my_user;
GRANT ROLE my_alert_center_role TO ROLE my_other_role;

Accessing alerts in Snowsight¶

To access the alerts in Snowsight:

Sign in to Snowsight.
In the navigation menu, select Monitoring » Alerts.

You can view a list of existing alerts and filter the alerts by the alert name and status. You can also view the status of recent executions of alerts.

Creating a new alert¶

You can create a new alert by using one of the templates provided. To create an alert, complete the following steps:

Sign in to Snowsight.
In the navigation menu, select Monitoring » Alerts, and select + Alert.
In the Name field, enter a name for the alert.
In the Description field, describe the purpose of the alert.
From the Location menu, choose the database and schema in which you want to create the alert.
From the Compute Type menu, choose one of the following options:
- To create a serverless alert, choose Serverless.
- To specify the warehouse that you want to use for the alert, choose Warehouse.
  
  If you selected this option, choose the warehouse from the Warehouse menu.
If you want to activate the alert after it is created, select Activate alert upon creation.

If you don’t select this option, the newly created alert is suspended. You must resume the alert to make the alert active.
Select Next.
From the Select warehouse menu, choose the warehouse that you want to use for the alert.

From the Alert template menu, choose one of the template groups for Snowflake features, and choose the template that you want to use to create the alert.

The following table lists the template groups and templates that you can choose.


Template group	Template	Description
DATA_QUALITY	Anomaly detection alert	Monitors for anomalies detected in data quality metrics, triggering an alert when unusual patterns or outliers are identified.
	Expectation violations alert	Monitors for data quality expectation violations, triggering an alert when defined expectations are violated.
OPENFLOW	High CPU alert	Monitors Openflow runtime pods for sustained high CPU usage (>90%), which can indicate a potential performance degradation.
	Connector backpressure (object count)	Monitors the connector queue count to determine if it exceeds the backpressure threshold, which can indicate that the downstream system can’t keep up with the data flow rate.
	Connector backpressure (bytes)	Monitors the connector queued bytes to determine if it exceeds the backpressure threshold, which can indicate that there is memory pressure in the data pipeline.
	High queued bytes alert	Monitors the connector queue bytes to determine if it approaches the backpressure threshold (>80%), which can provide an early warning before backpressure occurs.
	High queued count alert	Monitors the connector queue object count to determine if it approaches the backpressure threshold (>80%), which can provide an early warning before backpressure occurs.
	No data alert	Monitors for connectors that have an active processing time but are not receiving or sending any data, which can indicate potential data flow issues.
	Runtime high error rate alert	Monitors the Openflow runtime processors for a high volume of ERROR-level logs, which can indicate processing failures.
	Table replication failure alert	Monitors for table replication transitions to a FAILED state, which can indicate a critical data synchronization issues.
TASKS	Error rate alert	Triggers an alert when the cumulative task error rate exceeds a specified threshold.

Fill in the configuration fields for the alert. The fields depend on the template that you have chosen.
Select the scope that you want to monitor. The scope determines the objects that are monitored for the alert. For example, to monitor all objects in the account, choose Account from the Scope menu.
From the Schedule menu, choose the type of schedule that want to use to run the alert:
- To run the alert only when new objects are added (for example, new rows inserted into a table that you are monitoring), select When new events are detected.
- To run the alert on a regular schedule, and select the frequency for executing the alert (for example, every 10 minutes), select On a schedule.
From the Notification integration menu, choose the notification integration that you created earlier
From the Email recipients menu, choose the email addresses of the people to notify when the alert is triggered.
Select Create.

About the alerts created in Snowsight¶

When creating alerts in Snowsight, note the following:

The template wizard generates the SQL statements for creating the alert. If you need to customize the alerts, you can make changes to those statements.
The alerts are visible only if your current role has the MONITOR or OWNERSHIP privilege on the alert.
If you need to suspend or resume the alerts, select to the right of the alert, and choose Suspend or Resume.