Skip to content

Latest commit

 

History

History
36 lines (27 loc) · 1.22 KB

README.md

File metadata and controls

36 lines (27 loc) · 1.22 KB
Raw

Snowflake account_usage Prometheus exporter

A Prometheus exporter for monitoring your Snowflake account using the built in ACCOUNT_USAGE schema.

Prerequisites

Usage

  1. Build the docker image docker build -t snowflake_prometheus:latest .
  2. docker run -e CONFIG_YAML_PATH=./config.yaml -e SNOWFLAKE_ACCOUNT=account_string -e SNOWFLAKE_USERNAME=DANIELFITZGERALD -e SNOWFLAKE_PASSWORD=password -e SNOWFLAKE_ROLE=role your_repo:snowflake_prometheus:latest

Adding your own queries

  1. Add a new section to config.yaml following this convention
- category: "the category - all metrics in this category will have the same prefix"
    help: Example
    labels:
    - 'LABEL1'
    - 'LABEL2'
    metrics:
    - key: the column name that will be used as the metric value
      name: the name of the metric
      type: gauge
    - key: the column name that will be used as the metric value
      name: the name of the metric
      type: gauge
    statement: >-
        sqlText
  1. Based upon your SQL query, define which columns will be metrics and which will be labels applied to those metrics. Populate the labels section with a list of labels and the metrics section