pivot
GitHub Get started

Analytics on open formats just got fast.

Pivot brings the speed and concurrency the AI era demands to open data formats. Run low-latency, high-concurrency queries on external Iceberg, or Pivot's managed Delta Lake - without duplicating your data into proprietary real-time analytics engines.

$ curl https://pivotlake.io | sh copy
Object storage
eventsDelta
ordersDelta
customersIceberg
Pivot server
pivot server
└ listening on :5432
Postgres protocol
SQL clients
Apps
psql
BI tools
Agents / CLI
pivot open s3://lake
└ opened 3 tables

01 — FASTThe fastest real-time analytical engine.

Relative query time, lower is better.

ClickBench
43 queries
pivot (Parquet)1.09×
ClickHouse (native)2.17×
DataFusion (Parquet)3.09×
ClickHouse (Parquet)3.61×
DuckDB (native)4.17×
DuckDB (Parquet)4.31×
Spark53.73×
TPC-H
SF1000
pivot (Parquet)1.00×
DuckDB (Parquet)2.16×
DuckDB (native)3.10×
ClickHouse (native)4.68×
DataFusion (Parquet)7.37×
ClickHouse (Parquet)27.14×
Spark43.59×
Star Schema Benchmark
SF1000
pivot (Parquet)1.00×
DuckDB (Parquet)2.58×
ClickHouse (native)3.36×
DuckDB (native)5.00×
DataFusion (Parquet)12.86×
Spark44.38×
ClickHouse (Parquet)120.51×

Benchmark harness and queries are in the repo — reproduce them yourself.

All runs: AWS c8gd.metal-48xl

02 — SCALABLEScale up, down, or to zero — almost instantly.

With object storage as its backing store and only state, Pivot can be scaled up, down, or to zero almost instantly.

Object storage
eventsDelta
ordersDelta
customersIceberg
instance 1
pivot server
serving
instance 2
pivot server
serving
instance 3
pivot server
serving
instance 4
pivot server
scaled to zero
instance 5
pivot server
scaled to zero

03 — PORTABLERun anywhere. Query the same Parquet.

Run Pivot as a shared server or locally for ad hoc queries and AI agents. Both access the same tables in object storage, with no extra copies to maintain.

Server mode

Connect applications, BI tools, and SQL clients to a shared Pivot server or cluster using the Postgres protocol.

Standalone mode

Run Pivot locally from your terminal or AI agent and query object storage directly, with no server to manage.

Clients
Apps
BI tools
psql
Terminal
pivot open s3://lake
└ opened 3 tables
AI agent
pivot open s3://lake
└ opened 3 tables
Postgres protocol
Pivot server
pivot server
└ listening on :5432
Shared tables in object storage
Same tables. Same source of truth.

04 — OPENOpen source. Open formats.

Built on Delta Lake and Apache Iceberg, Pivot keeps your data open and accessible to tools like Snowflake, Spark, DuckDB, and Trino.

Pivotlake datastore

Pivot handles ingestion, compaction, and statistics to keep your tables ready for sub-second SQL queries. Data is stored in Delta Lake, so other engines can query the same files.

Object storage
eventsDelta
ordersDelta
usersDelta
Pivot
pivot server
└ ingest · compact · query
Iceberg datastore

Connect Pivot to your existing Iceberg tables for low-latency queries at high concurrency. Your data stays where it is, with no migration or additional copy to maintain.

Object storage
customersIceberg
accountsIceberg
invoicesIceberg
Pivot
pivot open --kind iceberg http://catalog:8181
└ opened 3 tables
Read the docs Star on GitHub