How to show raw queries(CQL) in Scylla/Cassandra

Question

I am using Scylla(Cassandra's drop in replacement) db in docker container. I am using Python driver to connect with Scylla db for querying. I need to know the exact CQL query is applying on the database engine.

So, if there any way to print the query on the console(docker logs) or somewhere I can see and copy. Thanks

score 1 · Answer 1 · answered Mar 15 '23 at 15:36

1

You can use tracing to ask the database to store the queries in a table. Be careful as there is a large performance impact.

answered Mar 15 '23 at 15:36

Avi Kivity

1,362
9
17

How can I ask the database? Any example? – Mohammad Ashraful Islam Mar 16 '23 at 03:59
It depends on the driver. For the Python driver, use the [trace parameter](https://python-driver.docs.scylladb.com/stable/api/cassandra/cluster.html#cassandra.cluster.Session.execute_async). to `execute` or `execute_async`. – Avi Kivity Mar 16 '23 at 18:22

How to show raw queries(CQL) in Scylla/Cassandra

1 Answers1