Cassandra - CQL execution from Ansible

Hi All,

I’m using ansible for CQL automation for cassandra.

I want to execute CQL scripts (Mainly DDL) from ansible.

I would like to know , how I establish the connection to the cassandra cluster (cql - cassandra node) and how will I execute cql scripts on that node.

Help on this regards will be very helpful.

thanks.
Anumod.