LakeOpsLakeOps
Demo
Back to all articles

Trino articles

Trino query engine on Apache Iceberg — optimization, predicate pushdown, connector tuning, and integration with Iceberg lakehouses.

AllTrinoApache IcebergData LakehouseData PlatformsLakehouseLakeOpsCompactionObservabilityData GovernanceAI

6 articles

Faster Trino with Iceberg — Trino rabbit mascot with a speed gauge and layered Iceberg data blocks accelerating query performance
Apache IcebergTrinoLakeOps

Slow Trino Queries on Iceberg? 7 Fixes for Faster Trino Iceberg Performance

Slow Trino queries on Apache Iceberg are rarely a compute problem — they're a table layout problem. Unmaintained Iceberg tables turn sub-second Trino scans into minute-long full reads. This guide covers seven proven fixes for faster Trino Iceberg performance: compaction, query-aware sorting, partition strategy, manifest optimization, lifecycle cleanup, multi-engine routing, and continuous observability. Why Trino-native maintenance falls short — and how to automate each fix at scale.

Chris P
Chris P
25 min read
Apache Iceberg Multi-Engine Architecture — Spark, Trino, Snowflake, and Athena on the same Iceberg tables
Data PlatformsData LakehouseApache Iceberg

Apache Iceberg Multi-Engine Architecture: Spark, Trino, Snowflake, Athena on the Same Tables

How production Iceberg lakehouses run Spark, Trino, Snowflake, Athena, Flink, and DuckDB on the same tables — covering engine decoupling, write isolation, conflict resolution, catalog coordination, read path optimization, query routing, cross-engine governance, and the control plane that ties it together.

Jonathan Saring
Jonathan Saring
27 min read
Databricks to Iceberg smooth migration — Databricks and Apache Iceberg connected by a data bridge, with table data flowing into an open Iceberg lakehouse
DatabricksApache IcebergLakeOps

Databricks to Iceberg Smooth Migration

Databricks to Iceberg smooth migration opens a multi-engine lakehouse — not a platform exit. Databricks stays central for ML and Spark; Iceberg adds Trino, Snowflake, and open catalogs. Five tools: LakeOps, UC managed Iceberg, Delta UniForm, Spark, and Lakehouse Federation.

David W
David W
18 min read
Apache Iceberg with Trino Optimization — Trino logo with an optimization gauge sending query streams into a geometric iceberg, with performance metric icons for throughput, latency, and efficiency
Apache IcebergTrinoCompaction

Apache Iceberg with Trino: Performance Optimization Guide

A practical guide to optimizing Apache Iceberg queries and table maintenance with Trino — covering scan planning, predicate pushdown, file pruning, Trino-side tuning, maintenance procedures, physical layout optimization, and how a dedicated control plane eliminates JVM overhead while adding cross-engine intelligence.

Chris P
Chris P
18 min read
Multiple Query Engines with Iceberg — Ferris the Rust crab routing queries to Trino, Snowflake, DataFusion, Databricks, Presto, ClickHouse, DuckDB, and Apache Spark over an Iceberg Lakehouse
Apache IcebergData LakehouseQueryFlux

Routing Multiple Query Engines with Iceberg

How to route queries across Trino, Spark, DuckDB, Snowflake, Athena, and Flink on shared Iceberg tables — covering the architecture of a SQL routing proxy, dialect translation, routing strategies, table-aware optimization, and the tooling that makes it work.

Rob M
Rob M
18 min read
Introducing QueryFlux: Open-Source Universal Multi-Engine Query Router and SQL Proxy
QueryFluxApache IcebergData Platforms

Introducing QueryFlux: Open-Source Universal Multi-Engine Query Router and SQL Proxy

QueryFlux is a universal SQL proxy and multi-engine query router in Rust—one access layer in front of Trino, DuckDB, StarRocks, and Athena with routing, dialect translation, and observability.

Jonathan Saring
Jonathan Saring
12 min read