Skip to content

A general purpose tool for generating Slack Alerts via query results from Dune Analytics

Notifications You must be signed in to change notification settings

cowprotocol/dune-alerts

Repository files navigation

Query Monitor / Dune Alerts

This package combines both DuneAPI and SlackClient in a way that can send alerts in slack based on dune query results.

To run this monitoring system will require the following steps:

  1. An account on Dune Analytics and a query you would like to monitor.
  2. An existing slack bot (Create a Slack App)

To run the query monitor (for a single query) you will need to provide Dune credentials and Slack app details. Namely, the environment variables supplied in the sample env file.

Query Monitor from Configuration

Query Monitor objects are loaded from a yaml configuration file taking the following form:

name: Name of your Query
id: DUNE_QUERY_ID
window: (This is Optional)
  offset: how far in hours back in time from datetime.now()
  length: time interval length
parameters:
  - key: param1
    type: number
    value: 100
  - key: param2
    type: text
    value: example

where DUNE_QUERY_ID is found in the url of your existing query. Concretely, it is the integer at the end of this url https://dune.com/queries/857522.

For more examples on query parameter configuration, checkout our test examples ./tests/data

With all the configuration in place, then you can run the alerter with

python -m src.slackbot --query-config QUERY_CONFIG_PATH

where QUERY_CONFIG_PATH is a filepath to the yaml file containing your query configuration.

This will load the query details, refresh the query with given parameters, fetch the results and send an alert to the configured Slack channel if warranted.

Run with Docker

From the root of this project, assuming you have a .env file with dune and slack credentials and a query configuration config.yaml

# build
docker build -t slackbot .
docker run -v ${PWD}/config.yaml:/app/config.yaml --env-file .env slackbot --query-config config.yaml
docker run \
    -v ${PWD}/<CONFIG_FILE>:/app/cfg \
     --env-file .env \
     ghcr.io/cowprotocol/dune-alerts \
     --query-config cfg