proomt

Search

Search posts, papers, and topics

All posts

ClickHouseJames Cunningham10 min readintermediate

Introducing ClickHouse's new TimeSeries Engine: Your drop-In Prometheus replacement

Read on clickhouse.comHN 2·0 comments

Summary

ClickHouse Cloud adds a private‑preview TimeSeries engine that ingests Prometheus remote‑write data and serves it via native PromQL, letting you keep existing PromQL queries while storing metrics in ClickHouse.

  • Create a `TimeSeries` table (e.g. `CREATE TABLE prometheus.metrics ENGINE = TimeSeries;`).
  • Point Prometheus remote_write or OpenTelemetry remote‑write exporter at the ClickHouse endpoint (`/prometheus/api/v1/write`).
  • Query the data with any PromQL client (Grafana, curl, clickhouse‑client) – the server evaluates PromQL internally, exposing the same HTTP API as a Prometheus server.
  • SQL access is also provided via `prometheusQuery` and `prometheusQueryRange` table functions.

Teams can consolidate logs, traces, and metrics in a single ClickHouse cluster without rewriting dashboards or alerts, preserving exact PromQL semantics while gaining ClickHouse’s column‑store performance.

5/10
observabilityclickhouseprometheussqltime seriesgrafana

Related reading

  1. September 2026 newsletter

    ClickHouse's September 2026 newsletter highlights the 26.8 release with features like pipelined SQL and custom HTTP handlers, alongside previews for On-Demand Compute and a PromQL-compatible TimeSeries engine. It also covers new Postgres integration tools and a cost-performance benchmark for cloud data warehouses.

    ClickHouseclickhouse.com7 min

  2. ClickHouse is now available on the dbt platform

    ClickHouse released a public‑beta dbt v2 adapter written in Rust that ships inside the dbt binary and talks to ClickHouse via the new ADBC driver. The adapter promises up to 30× faster dbt parsing and leverages ClickHouse’s sub‑second, high‑concurrency engine (e.g., materialized views, MCP server). A private‑beta integration on the dbt Platform now lets users develop, schedule, and catalog ClickH…

    ClickHouseclickhouse.com8 min

  3. How Meshtastic Metrics Exporter Turned Eight Prometheus Queries Into One with Tiger Data

    A Python exporter reads Meshtastic mesh telemetry from MQTT and writes it directly into a TimescaleDB‑enabled PostgreSQL instance, replacing a Prometheus setup that hit ~0.5 M series for 10 k nodes. The single database lets Grafana dashboards join node metadata with eight time‑series tables in one query, eliminates scrape‑budget limits, and uses native retention/compression (14‑day compression, 3…

    Timescaletigerdata.com6 min

  4. ClickHouse welcomes RunReveal

    ClickHouse announced it has acquired RunReveal, a security data platform built on ClickHouse, to deepen its expertise in security workloads. The deal promises better guidance for security teams while keeping RunReveal's product unchanged for existing customers.

    ClickHouseclickhouse.com2 minHN7

  5. What's new in ClickStack - Aug ’26

    ClickStack August 2026 update adds general‑availability dashboard variables (including cross‑source SQL, Lucene, PromQL macros), chart formulas for derived metrics, a metrics explorer UI, release‑marker overlays, OIDC auth for the collector, and a beta LLM observability dashboard. It also introduces a private‑preview TimeSeries engine with PromQL support, letting ClickStack store and query Promet…

    ClickHouseclickhouse.com16 min

  6. The official ClickHouse provider for Apache Airflow is now available

    The post announces the official ClickHouse provider for Apache Airflow, showing how to install it, configure a ClickHouse connection, and run queries using standard SQL operators or a ClickHouseHook. It includes examples for both self‑hosted Airflow and the Astronomer managed platform.

    ClickHouseclickhouse.com5 min