BI Connector (Grafana / SQL)¶

Location in Keel: Settings → BI Connector

The BI Connector exposes Keel's log store over a read-only, ClickHouse-compatible SQL endpoint so you can build your own dashboards and reports in external BI tools — Grafana, Metabase, Superset, or anything that speaks the ClickHouse/HTTP protocol — without copying your data anywhere. Everything stays on the appliance; the BI tool simply queries it.

Keel BI Connector settings

How it works¶

Enable the BI Connector under Settings → BI Connector. Keel provisions a dedicated, read-only SQL user and exposes a stable, queryable view of your logs.
Point your BI tool at the connector endpoint using that user. In Grafana, add a ClickHouse data source targeting the connector URL and credentials.
Queries run against your live, on-prem data — no export, no second copy.

Example: Grafana dashboard¶

The dashboard below is built entirely on the Keel BI Connector — log volume over time, errors and warnings, top services by error count, and recent error samples — proving the end-to-end integration (Grafana → BI Connector → Keel log store):

Grafana dashboard built on the Keel BI Connector

Notes¶

The connector is read-only — BI tools can query but never modify your data.
Use the credentials Keel issues for the connector; rotate them from the same settings page.
For large queries, prefer aggregations (the log store is column-oriented and fast at them).