you need to have 3rd party vendor ODBC Driver
Check the link below for SIMBA Odbc Cassandra driver for MAC
With this you will be able to connect to Cassandra
Hope this helps kindly mark this answer as correct or helpful so that it will help others
HI Naveen -
This do help with first part of question. But can you help me with the configuration to connect my local instance?
Also this is something a paid tool anything as freeware.