Monitoring Vertica using notifiers

A Vertica notifier is a push-based mechanism for sending messages from Vertica to endpoints like Apache Kafka or syslog. For example, you can configure a long-running script to send notifications at various stages and then at the completion of a task.

To use a notifier:

1. Use CREATE NOTIFIER to create one of the following notifier types:

   • Syslog

   • SNS

   • Kafka

2. Send a notification to the NOTIFIER endpoint with any of the following:

   • NOTIFY: Manually sends a message to the NOTIFIER endpoint.

   • SET_DATA_COLLECTOR_NOTIFY_POLICY: Creates a notification policy, which automatically sends a message to the NOTIFIER endpoint when a specified event occurs.