How to send alert when a query hits certain threshold in Snowflake?

Question

I am trying to set up alert if someone tries to query > threshold of sensitive data(eg email) in Snowflake. How can I achieve this?

Answer 1

No built in functionality here. But with the content from here https://medium.com/hashmapinc/sending-email-notifications-from-snowflake-using-external-functions-4b985c182292 you can use external functions and AWS to send emails. The reason, why the email is triggered, is then your Snowflake implementation.

Answer 2

Snowflake does not have this functionality built in, but it is easily extensible. You can write functions or procedures in JAVA, Scala, Python (soon) and send notifications that way. Or you can use an external monitoring mechanism such as SNOWALERT