Fix flaky tests #1795
Description
Several integration tests have been marked as flaky and are currently being skipped. With the recent introdaction of testcontainers-go for managing Cassandra clusters in test suite (PR), we now have a more robust and flexible environment. I propose revisiting these flaky tests to address the underlying issues and stabilize them using the new testcontainers-go approach.