Clickhouse
Setting up the Clickhouse connector
| No | Item | Required | Example | Notes |
|---|---|---|---|---|
| 1 | Host | Yes | The host endpoint of the Clickhouse cluster. | |
| 2 | Port | Yes | 8123 | The port of the database. |
| 3 | Database | Yes | default | The name of the database. |
| 4 | Username | Yes | The username which is used to access the database. | |
| 5 | Password | No | The password associated with this username. | |
| 6 | JDBC URL Parameters (Advanced) | No | Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (Eg. key1=value1&key2=value2&key3=value3). For more information read about JDBC URL parameters. | |
| 7 | SSL Connection | No | Encrypt data using SSL. |
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.