I don't do the "run txn & rollback". I use Docker and create a new instance for each test suite, or even each test. Depends on the startup characteristics of the db in the container. At the very least, I create a new keyspace for the tables in each test. The trick is configuration ... having a configuration that can communicate that to the necessary components, done in a way that can be easily overridden on a test-by-test basis.