Presto Federation

Presto Federation is an advanced extension of Presto (and Trino) that allows you to query data across multiple databases and data sources in a single SQL statement without moving the data. Instead of centralizing data through ETL, you connect Presto to each source (PostgreSQL, MySQL, Cassandra, Hive, etc.) and write queries that transparently join and aggregate across them. The federated architecture uses a coordinator node to parse and plan queries, and worker nodes that push predicates down to each source database for efficient execution. This is particularly powerful for organizations with polyglot data stacks—data spread across legacy relational databases, modern data warehouses, and NoSQL systems.