Snowflake Alert Long Running Queries

1
votes

  1. How to alert long running queries, to multiple users in snowflake ? Right now the alert is sent only to the account admin role user.

    Is there any way to notify the long query alert to "the user running the query OR notify to multiple users belong to the particular warehouse/database" ?

  2. Is there any way to leverage Snowflake Notification Integration for the above alerts?

Thanks In Advance

Sundar

1
snowflake-cloud-data-platformsnowflake-tasksnowflake-pipe

1 Answers

0
votes

The only notification available out-of-the-box in Snowflake is the Resource Monitor whereby AccountAdmin members only can subscribe for notifications.

https://docs.snowflake.com/en/user-guide/resource-monitors.html#resource-monitor-properties