CODEWITHSUNDEEP
snowflake-cloud-data-platform
vamsi krishna
vamsi krishna

Reputation: 81

Snowflake failed queries alerts in real time

Is there any way I can get the failed queries running in snowflake in real-time. Is that even possible? I have seen this which is about notification integration in snowflake, what kind of notifications does it send? Any ideas or suggestions, please help me. https://docs.snowflake.com/en/sql-reference/sql/create-notification-integration.html'

Thank you

Upvotes: 0

Views: 560

Answers (1)

Gokhan Atil
Gokhan Atil

Reputation: 10059

Snowflake does not have an alert mechanism for failed queries.

For "real" real-time, your client calling the query should check the query's result and may produce an alert when the query fails.

If you mean "near" real-time monitoring any failed queries, you may schedule a job that will query information_schema.query_history every X minute(s).

https://docs.snowflake.com/en/sql-reference/functions/query_history.html

Upvotes: 1

Related Questions