{"repo":"m-lab/prometheus-bigquery-exporter","free":true,"listed":false,"github":"https://github.com/m-lab/prometheus-bigquery-exporter","clone":"git clone https://github.com/m-lab/prometheus-bigquery-exporter.git","description":"An exporter for converting BigQuery results into Prometheus metrics","language":"Go","stars":49,"topics":["prometheus","bigquery","exporter","monitoring"],"license":"Apache-2.0","category":"analytics","readme_excerpt":"prometheus-bigquery-exporter An exporter for converting BigQuery results into Prometheus metrics. Limitations: No historical values Prometheus collects the current status of a system as reported by an exporter. Prometheus then associates the values collected with a timestamp of the time of collection. NOTE: there is no way to associate historical values with timestamps in the the past with this exporter! So, the results of queries run by prometheus-bigquery-exporter should represent a meaningful value at a fixed point in time relative to the time the query is made, e.g. total number of tests in a 5 minute window 1 hour ago. Query Formatting The prometheus-bigquery-exporter accepts arbitrary BQ queries. However, the query results must be structured in a predictable way for the exporter to successfully interpret and convert it into prometheus metrics. Metric names and values Metric names are derived from the query file name and query value columns. The bigquery-exporter identifies value columns by looking for column names that match the pattern: value([.+]) . All characters in the matching group ([.+]) are appended to the metric prefix taken from the query file name. For example: Filename: bq ndt test.sql Metric prefix: bq ndt test Column name: value count Final metric: bq ndt test count Value columns are required (at least one): value([.+]) - every query must define a result \"value\". Values must be integers or floats. For a query to return multiple values, prefix each with \"va","default_branch":null,"files":null,"tree":[],"storefront":"/r/m-lab","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/m-lab/prometheus-bigquery-exporter/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}