Clickhouse Database
Published 15 January 2025
- Verified Versions: N/A
- Maintainer: Flyway Open-Source Community
Supported Versions and Support Levels
- For information regarding the supported version and support levels available, please see Supported Databases for Flyway
- For information regarding the Flyway features available, please see Flyway feature summary
Driver
| Item | Details |
|---|---|
| URL format | jdbc:clickhouse://host:port/database |
| SSL support | Not tested |
| Ships with Flyway Command-line | No |
| JDBC driver download for Command-line | Clickhouse JDBC Drivers |
| Maven Central coordinates | com.clickhouse:clickhouse-jdbc |
| Supported versions | N/A |
| Default Java class | com.clickhouse.jdbc.ClickHouseDriver |
| Flyway Community implementation | flyway-community-db-support |
Related database-specific parameters
Whilst most databases Flyway supports have common configuration parameters, there are sometimes specific configurations available:
Java Usage
Clickhouse support is a separate dependency for Flyway and will need to be added to your Java project to access these features.
Maven
Open Source
<dependency>
<groupId>org.flywaydb</groupId>
<artifactId>flyway-database-clickhouse</artifactId>
</dependency>
Gradle
Open Source
dependencies {
compile "org.flywaydb:flyway-database-clickhouse"
}
Compression
By default, Clickhouse uses LZ4 compression.
This requires lz4-java which needs to be added to the classpath.
Alternatively, you can use a different algorithm by setting the compress_algorithm JDBC property, or disable it by setting compress to false.
