'How to have alert for the Kafka Connector down for Snowflake
How to have the alerts in the system for the Kafka connector is down with Snowflake database.
Solution 1:[1]
If Snowflake is down, or you get some network / query exception, you should expect connector logs to indicate the problem.
You'll therefore need a generic log aggregation framework that can read this and generate alerts. Splunk or Elasticsearch are the most commonly used products for this, in my experience.
Otherwise, you can poll the /status API endpoint of the connector and look for failed tasks and programmatically generate alerts to whatever API you want, such as PagerDuty or Slack
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | OneCricketeer |