Trino Presto Federated Query

Overview

Use this skill when Trino or Presto sits across multiple data systems as a federated query layer. It helps agents reason about federation boundaries, predicate pushdown limits, consistency trade-offs, performance planning, and governed consumption patterns.

When to Use

• querying across multiple heterogeneous data stores with Trino or Presto
• defining governed federated analytics access for users or applications
• managing performance, cost, and semantic consistency across systems
• building a query layer over lakehouse tables, relational databases, and object stores
• planning catalog and connector configuration for multi-source environments

Do not use this when all data lives in a single system or when a materialized serving layer would be simpler and more performant.

Workflow