queries.yml

# Use default data source
- nr_companies_per_country:
    help: Number of companies per country
    sql: >
        select country, count(1) as cnt from Companies group by country
    data-field: cnt

# Missing database user, data source 'my-ds-missing-user' shall be used instead of the default 'my-ds'
- error_missing_user:
    help: Data source error
    data-source: my-ds-missing-user
    sql: >
        select * from dual
    interval: 30s

# Missing table
- error_missing_table:
    help: Missing table
    sql: >
        select * from missing_table
    interval: 30s

# Sub queries
# This will register two metrics:
# - response_time_count with cnt as value
# - response_time_sum with rt as value
- response_time:
    help: Sub metrics
    sql: >
        select count(*) as cnt, sum(response_time) as rt from Requests
    sub-metrics:
      count: cnt
      sum: rt
    interval: 30s