The Cassandra workbench extension lets us run CQL queries from within VSCode. It uses a config file of this format for connection:
[ // AllowAllAuthenticator { "name": "Cluster AllowAllAuthenticator", "contactPoints": [ "127.0.0.1" ] }, //PasswordAuthenticator { "name": "Cluster PasswordAuthenticator", "contactPoints": [ "127.0.0.1" ], "authProvider": { "class": "PasswordAuthenticator", "username": "username", "password": "password" } } ]
I'm able to connect it with a Cassandra server running on localhost. I want to connect it with Astra, how can this be done? I tried replacing the IP address with
https://$ASTRA_DB_ID-$ASTRA_DB_REGION.apps.astra.datastax.com
but it didn't work (environment variables replaced with actual URL).
The Astra documentation mainly talks about Stargate based connections (REST, GraphQL etc). Please help.