AWS Keyspace(Cassandra) api error

If you mean you have configured AWS Access Credentials on your system by using the AWS cli to run aws configure, you can list Keyspaces with the command aws keyspaces list-keyspaces. You can also use an AWS SDK to list your keyspaces, such as the boto3 SDK for Python.

You appear to want to list keyspaces using the REST API, which is possible. You can use the API for data language definition (DDL) operations. This API reference describes the supported DDL operations in detail. https://docs.aws.amazon.com/keyspaces/latest/APIReference/Welcome.html

From there, you can find a list of supported Actions, including "ListKeyspaces" https://docs.aws.amazon.com/keyspaces/latest/APIReference/API_Operations.html

But if you're not using the CLI or an SDK, you'll need to sign your requests manually, which is not trival. https://docs.aws.amazon.com/general/latest/gr/signing-aws-api-requests.html

Here is an example in Python

import json
import pprint
import urllib3


headers = {
    "X-Amz-Target": "KeyspacesService.ListKeyspaces",
    "Content-Type": "application/x-amz-json-1.0",
    "X-Amz-Date": "20230214T153319Z",
    "Authorization": f"AWS4-HMAC-SHA256 Credential={my_access_key}/20230214/us-east-2/cassandra/aws4_request, SignedHeaders=content-type;host;x-amz-date;x-amz-target, Signature={my_signature}"
}

host = "cassandra.us-east-2.amazonaws.com"

http = urllib3.PoolManager()
r = http.request("POST", url=f"https://{host}", headers=headers)

pprint.pprint(json.loads(r.data.decode("utf-8")))

Here it is with the Python boto3 client

import boto3


client = boto3.client(
    "keyspaces",
    endpoint_url="https://cassandra.us-east-2.amazonaws.com",
    # endpoint_url='http://localhost:8000/',
)

response = client.list_keyspaces()

And if I swap-in localhost for the endpoint url and run a server locally to dump the headers, I can see these are the headers being sent to the Keyspaces API.

ERROR:root:Host: localhost:8000
Accept-Encoding: identity
X-Amz-Target: KeyspacesService.ListKeyspaces
Content-Type: application/x-amz-json-1.0
User-Agent: Boto3/1.26.70 Python/3.9.6 Darwin/21.6.0 Botocore/1.29.70
X-Amz-Date: 20230214T153319Z
Authorization: AWS4-HMAC-SHA256 Credential=<my_access_key>/20230214/us-east-2/cassandra/aws4_request, SignedHeaders=content-type;host;x-amz-date;x-amz-target, Signature=<my_signature>
amz-sdk-invocation-id: 20f45727-43a6-4f13-bbac-40502747a673
amz-sdk-request: attempt=5; max=5
Content-Length: 2