ClickHouse JDBC Bridge
JDBC bridge for ClickHouse is an extension that acts as a stateless proxy passing queries from ClickHouse to external data sources. This solution enables running distributed queries on ClickHouse across multiple data sources in real time, which simplifies the process of building data pipelines for data warehousing, monitoring and integrity check.
The JDBC bridge works in combination with the jdbc table function or the JDBC table engine, allowing ClickHouse to access data from any external data source for which a JDBC driver is available. This is particularly handy when there is no native built-in integration engine, table function, or external dictionary for the external data source available, but a JDBC driver for the data source exists.
Key capabilities and advantages:
Universal data access. The JDBC bridge provides access to any external data sources with available JDBC drivers, extending ClickHouse integration capabilities with various database systems.
Read and write operations support. The solution supports both reading data from external sources and writing data to them, ensuring bidirectional data exchange.
Parallel work with multiple sources. The JDBC bridge can simultaneously work with multiple external data sources, enabling distributed queries on ClickHouse across multiple external and internal data sources in real time.
Stateless architecture. The proxy operates without state preservation, ensuring high reliability and scalability of the solution.
Data pipeline building simplification. Integration of various data sources through a unified interface significantly simplifies creation and management of data pipelines for analytical tasks, monitoring and data integrity assurance.
The JDBC bridge for ClickHouse is a powerful tool for integrating heterogeneous data sources, enabling creation of a unified analytical platform based on ClickHouse with access to data from various external systems.
- Get an SSH key pair to connect to the virtual machine (VM).
- Create a VM from a public image. In the Image/Boot Disk Selection section, go to the Cloud Marketplace tab and select ClickHouse JDBC Bridge. In the Access section:
- enter the username in the Login field;
- paste the contents of the file with the public SSH key into the SSH Key field.
- Wait for the virtual machine to start.
- Connect to the VM via SSH. Use the login you specified when creating the VM and the private SSH key created earlier.
- Edit the configuration files for clickhouse-jdbc-bridge in /etc/clickhouse-jdbc-bridge/.
- Start clickhouse-jdbc-bridge using the command
sudo systemctl start clickhouse-jdbc-bridge.
- Building data pipelines for data warehousing with multiple data sources integration
- Monitoring and integrity checking of data between different database systems
- Executing distributed queries in real time across external and internal data sources
- Integration with external data sources when built-in ClickHouse engines or table functions are not available
Yandex Cloud technical support responds to requests 24 hours a day, 7 days a week. The types of requests available and their response time depend on your pricing plan. You can activate paid support in the management console. Learn more about requesting technical support.
Yandex Cloud does not provide technical support for the product. If you have any issues, please refer to the developer’s information resources.