“ I have checked the documents of AWS to querying the table data in amazon keyspaces. Amazon Keyspaces makes it easy for developers and it's an Apache Cassandra compatible database service. In terms of cost, the solution is cheaper and highly available.”

Amazon Keyspaces (for Apache Cassandra) is a scalable, highly available and managed Apache Cassandra-compatible database service. With Amazon Keyspaces, you can run your Cassandra workloads on AWS using the same Cassandra application code and developer tools that you use today.

In this post, you will experience querying the table data in amazon keyspaces. Here I have created a keyspace and table with single region replication for querying the table.

Architecture Overview

The architecture diagram shows the overall deployment architecture with data flow, amazon keyspaces, keyspace and table.

Solution overview

The blog post consists of the following phases:

1. Creation of Keyspace with Single Region Replication
2. Creation of Table in Keyspace
3. Output of Table Query

Phase 1: Creation of Keyspace with Single Region Replication

1. Open the amazon keyspaces console, click on the keyspaces option on the left end. Create the keyspace with single region replication with a specify of keyspace name. Preview the query and then click on create a keyspace. The status of keyspace is active once created successfully.

Phase 2: Creation of Table in Keyspace

1. In the keyspace created, create a table with specifying table name. Add the columns with column name and data type. Select the partition key and add the clustering columns with default table settings. Query preview and then create a table. Once the table is created, do a query of the table.

Phase 3: Output of Table Query

Clean-up

Amazon Keyspaces : Delete of Keyspace and Table

Pricing

I review the pricing and estimated cost of this example.

Cost of Amazon Keyspaces (for Apache Cassandra) = $0.00 per million read request units in US East (N. Virginia) for first 30M read requests during free trial period = $0.00 x 4 Read Request Units = $0.00

Total Cost = $0.00

Summary

In this post, I showed “querying the table data in amazon keyspaces”.

For more details on Amazon Keyspaces, Checkout Get started Amazon Keyspaces, open the Amazon Keyspaces console. To learn more, read the Amazon Keyspaces documentation.

Thanks for reading!

Connect with me: Linkedin