In case all Cassandra nodes associated with a DMA are down, database files will be offloaded to the system cache folder on disk, and will be pushed to the database once the connection becomes available again.
I wonder if there is a way to manually enable the offload while the database is up and running?
For debugging purposes, I'd like to see what exactly is being pushed to the database in terms of trend data, element data, etc..., without having to temporarily disconnect the database.
it’s indeed not possible to see which queries are running on a Cassandra database. There is however logging in SLDataGateway in case a queue starts to build up towards a certain table.
Next to that we are currently looking into creating a BPA that will be able to provide you this information
Thanks Marlies. It was actually a line in the SLDataGateway log file related to a build-up of element data changes that triggered us to check if there is an easy way to see what is pushed to db during a given time span.