Federated queries
Written by
Updated at October 22, 2024
Federated queries provide a way to process data from multiple data sources with a single query. Currently, federated queries can work with ClickHouse® and PostgreSQL databases and Yandex Object Storage data storages.
To work with data stored in external databases, you simply need to create a connection. To work with unschematized data stored in S3 buckets, you also need to create a data binding.
Read more about working with different data sources in these sections:
- ClickHouse®.
- Greenplum®.
- MySQL®.
- PostgreSQL.
- S3.
- YDB.
Example of how to use federated queries in Yandex Query: