Federated queries
Federated queries allow retrieving information from various data sources without needing to transfer the data from these sources into YDB storage. Currently, federated queries support interaction with ClickHouse, PostgreSQL, and S3-compatible data stores. Using YQL queries, you can access these databases without the need to duplicate data between systems.
To work with data stored in external DBMSs, it is sufficient to create an external data source. To work with unstructured data stored in S3 buckets, you additionally need to create an external table. In both cases, it is necessary to create secrets objects first that store confidential data required for authentication in external systems.
You can learn about the internals of the federated query processing system in the architecture section. Detailed information on working with various data sources is provided in the corresponding sections: