Cassandra Database
Published 07 March 2024
Cassandra Database
- Verified Versions: N/A
- Maintainer: Redgate
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:cassandra://host:port?localdatacenter=datacenter1 |
| SSL support | Yes, add ;enablessl=true to URL |
| Ships with Flyway Command-line | Yes |
| Maven Central coordinates | com.ing.data:cassandra-jdbc-wrapper |
| Supported versions | 4.11.1 and later |
| Default Java class | com.ing.data.cassandra.jdbc.CassandraDriver |
Good to know
CQL file extensions
Cassandra migrations typically have a .cql migration suffix, we recommend configuring flyway to pick these up using the sqlMigrationSuffixes parameter.
You would specify this in your TOML configuration like this:
[flyway]
sqlMigrationSuffixes = [".cql"]
Default schema/keyspace
Flyway maps it's concept of schema onto a keyspace in Cassandra. You should specify a default schema to use as otherwise Flyway will default to system and you will have troubles working there (for example, clean won't be able to work correctly in the system keyspace).
This can be configured using one of the following parameters:
Limitations
- You can't currently do a Dry-run on operations with Cassandra.
Additional information
Our JDBC implementation for Cassandra comes from this Github project: Cassandra-jdbc-wrapper
