Connect to aws keyspace with aws sigv4 plugin

[hfrs123]

We are using AWS keyspaces with IAM role for authentication instead of service credentials. we are connecting to AWS keyspaces from spring boot app using AWS sigv4 plugin. In this case, how can we integrate liquibase with AWS keyspaces.

As per the liquibase docs, we need to specify the user name and password in the liquibase properties file. Here we don't have user name and password. Instead we have IAM role with permission to keyspace. And the IAM role is attached in service which will be used by the AWS Sigv4 plugin to authenticate and connect.

[maximevw]

Hello @hfrs123

As announced in my message here, a new version (4.14.0) of Cassandra JDBC wrapper is now available including the support of Amazon Keyspaces and SigV4 plugin.

You can download the JDBC driver bundle here and place it into the Liquibase classpath (lib directory). I think this version would probably be included by default with Liquibase Cassandra in the next release.

Regarding the specific parameters of the JDBC URL to use to activate SigV4 authentication plugin, please refer to the JDBC driver documentation.