ANSI SQL on your lakehouse. No warehouse copy.
Stop paying to copy your data to a warehouse so analysts can query it. DataLynxr's vectorized SQL engine queries your Iceberg and Delta tables directly on S3, GCS, or ADLS.
dlx> SELECT region,
SUM(revenue) AS total_revenue,
LAG(SUM(revenue)) OVER (
PARTITION BY region ORDER BY month
) AS prior_month
FROM s3://my-bucket/sales_facts
GROUP BY region, month;
✓ Query complete in 1.2s — 42.1 GB scanned
┌──────────┬───────────────┬────────────┐
│ region │ total_revenue │ prior_month│
├──────────┼───────────────┼────────────┤
│ US-West │ $4,821,032 │ $4,502,118 │
│ US-East │ $3,994,710 │ $4,111,225 │
└──────────┴───────────────┴────────────┘What you get with DataLynxr SQL
Vectorized execution engine
JIT-compiled columnar execution. Sub-second P95 on 10TB TPC-DS queries. SIMD-optimized aggregations and joins.
Full ANSI SQL
Window functions, CTEs, sub-queries, lateral joins, EXPLAIN plans. Compatible with Tableau, Metabase, Superset, and any JDBC/ODBC client.
Predicate pushdown + pruning
Z-ordering and column statistics push filters down to storage before reading. Pay only for data that actually answers your query.
Time-travel queries
Query any historical snapshot of your table up to 7 days back. Audit changes, debug anomalies, roll back bad writes.
Schema evolution
Add columns, rename columns, or evolve partition layouts without rewriting all existing data. Iceberg and Delta handle it transparently.
BI tool compatible
JDBC and ODBC drivers available. Connect Tableau, Metabase, Redash, Apache Superset, or any SQL client directly.
vs. Copy-to-warehouse approach
| Dimension | DataLynxr SQL | Copy-to-Warehouse |
|---|---|---|
| Data freshness | Real-time (live table) | 4-hour refresh lag (ETL schedule) |
| Cloud egress cost | Storage read only | Egress to warehouse + storage write |
| Data copy required | No | Yes — full or incremental copy |
| ETL pipelines to maintain | 0 | 3–6 Airflow DAGs typical |
| Schema drift risk | No — same schema as source | Source/warehouse schema mismatch common |
| Time-travel | 7-day snapshot built-in | Requires custom CDC implementation |
Query your lake in 10 minutes.
Connect your S3 bucket and run your first SQL query in under 10 minutes. Free tier — no credit card.