CODEWITHSUNDEEP
snowflake-cloud-data-platformpii
piya
piya

Reputation: 27

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

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?

Upvotes: 0

Views: 500

Answers (2)

Michael Golos
Michael Golos

Reputation: 2059

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

enter image description here

Upvotes: 1

Marcel
Marcel

Reputation: 2612

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.

Upvotes: 1

Related Questions