Förderjahr 2025 / Projekt Call #20 / ProjektID: 7918 / Projekt: Sovereign SOC
Netidee Förderungen enabled the OpenSource Pixie project to support long-term data retention and direct reads from the external datastore.
The Pixie team is excited to announce the beta availability of native ClickHouse DataFrame and export support in PxL. PxL is the panda-like native query language that makes Pixie's data available in the data-plane. This integration allows PxL scripts to read directly from ClickHouse tables through the DataFrame API, bringing externally stored columnar data into the same processing model used for Pixie’s native DataTables (eBPF network data, bpftrace and BCC data sources). PxL can also export telemetry directly to ClickHouse, providing another telemetry export option outside of its native OpenTelemetry export.
This work was made possible through this netidee grant by the Kubernetes Storm Center project and developed in close collaboration with the Pixie team. The collaboration brings together Pixie’s eBPF-based observability and PxL query engine with ClickHouse’s high-performance analytical storage, enabling new workflows for long-term telemetry retention, cross-cluster analysis, and security research. We’re excited to make this capability available to the Pixie community and to continue exploring how native integrations with analytical data stores can extend what’s possible with PxL.
For further information, please see the the relevant PRs
https://github.com/pixie-io/pixie/pull/2394
https://github.com/pixie-io/pixie/pull/2405
https://github.com/pixie-io/pixie/pull/2395
Constanze Roedig