auto-data-alerts

auto-data-alerts is a Python package that monitors Snowflake views and sends formatted alert messages to Slack channels. Point it at a view in your DATA_ALERTS schema, configure a template and channel, and it handles the rest — querying the data, formatting the message, sending to Slack, and logging the result.

Features

• Snowflake integration — queries any view in your DATA_ALERTS schema, no boilerplate required
• 5 message templates — from simple row-by-row lists to grouped data, metrics dashboards, and summary cards
• Smart skipping — if a view returns no rows, the alert is skipped and the outcome is still logged
• Alert history logging — every run (success or failure) is written back to Snowflake for auditing
• Debug mode — set DEBUG=TRUE to redirect all messages to a test channel without changing any code

Installation

Install the latest version directly from GitHub:

pip install git+https://github.com/cooper-richason/auto-data-alerts.git

Or from PyPI:

pip install auto-data-alerts

Setup

The package reads credentials from environment variables. Set the following before running:

How to use

The core function is send_alert. Call it with the Snowflake view name, a group label, a configuration dict, and the Slack channel ID:

from auto_data_alerts.core import send_alert

view_config = {
    'format_template': 'F1',          # which template to use
    'message_text': '@here, new alert:' # optional intro text
}

send_alert(
    view='my_alert_view',       # name of the Snowflake view in DATA_ALERTS schema
    view_group='my_team',       # prefix / team label used for titles and logging
    view_config=view_config,
    slack_channel='C01234ABCDE' # Slack channel ID
)

If the view returns no rows, the call returns early and logs a skipped result. If DEBUG=TRUE is set in the environment, the message is sent to your configured test channel instead.

See the full usage guide for complete setup instructions, Snowflake schema requirements, and configuration options.

Message Templates

Choose a template with the format_template key in view_config. All templates include a header derived from the view name and log the result to Snowflake.