How to access Amazon Keyspaces via shell?

361 views Asked by At

I tried writing cqlsh in the AWS shell, but it returned no output. I referred this tutorial

output:- bash: cqlsh: command not found

1

There are 1 answers

0
Autumn88 On

Yes, you can use cqlsh to access Amazon Keyspaces via the AWS Cloudshell. The repository for the Amazon Keyspaces toolkit has a shell script to setup the cqlsh in the AWS cloud shell. The Amazon Keyspaces toolkit is a repository for commonly used developer tooling configured for best practices in Amazon Keyspaces.

Here is a link to the github example: https://github.com/aws-samples/amazon-keyspaces-toolkit/tree/master/aws-cloudshell

Below are the steps to help you get started.

Run the following commands to download and execute the setup script wget https://raw.githubusercontent.com/aws-samples/amazon-keyspaces-toolkit/master/aws-cloudshell/setup.sh bash setup.sh

By using the cqlsh-expansion it also allows you to utilize the Sigv4 Authentication method, this method supports the Python Cassandra driver. For more information here is a Github page about our Sigv4 plug in and the Python driverhttps://github.com/aws/aws-sigv4-auth-cassandra-python-driver-plugin.

The plugin depends on the AWS SDK for Python (Boto3), uses boto3.Session to obtain credentials to connect to Amazon keyspaces using cqlsh-expansion

cqlsh-expansion cassandra.us-east-2.amazonaws.com 9142 --ssl --auth-provider "SigV4AuthProvider"

Additional info cqlsh-expansion https://github.com/aws-samples/amazon-keyspaces-toolkit/tree/master/cqlsh-expansion#readme AWS CloudShell https://docs.aws.amazon.com/cloudshell/latest/userguide/welcome.html