v.21.11New Features

Predefined Connections to External Data Sources

Allow predefined connections to external data sources. This allows to avoid specifying credentials or addresses while using external data sources, they can be referenced by names instead. Closes #28367. #28577 (Kseniia Sumarokova).
Introduces predefined connections for external data sources in ClickHouse, allowing users to reference external data sources by name without specifying credentials or addresses each time.

Why it matters

This feature simplifies the management and usage of external data sources by enabling users to avoid repeatedly specifying connection details such as credentials and addresses. It improves security and usability by centralizing connection information and reducing the risk of exposing sensitive data in queries.

How to use it

Users can configure predefined connections to external data sources in the ClickHouse configuration. Once defined, these connections can be referenced by their predefined names in queries and external table definitions without needing to provide credentials or addresses explicitly.