Amazon Keyspaces

Hands-On

Demo

In this demo, we will:

Set up security credentials for programmatic access
Create a keyspace using the AWS Management Console
Create a table with appropriate schema design
Connect using AWS CloudShell and cqlsh-expansion
Perform CRUD operations (Create, Read, Update, Delete)
Enable and test Point-in-Time Recovery (PITR)
Clean up resources

Agenda

keyspaces-user

Create user

Set permissions

Review and create

Credentials for Amazon Keyspaces (for Apache Cassandra)

Credentials

Amazon Keyspaces

ecommerce_system

Create keyspace

Create table

order_details

Create table

customer_id

uuid

order_date

date

order_id

uuid

product_name

text

quantity

int

unit_price

decimal

order_status

text

Primary key

order_date

DESC

order_id

ASC

Table settings

Point-in-time recovery: Leave Disabled for now (we'll enable this later)

Other Settings

Table tags

Create table

order_details

AWS CloudShell

wget https://www.amazontrust.com/repository/AmazonRootCA1.pem -O ~/AmazonRootCA1.pem

ls -l ~/AmazonRootCA1.pem

echo -e "[ssl]\ncertfile = /home/cloudshell-user/AmazonRootCA1.pem" > ~/.cassandra/cqlshrc

cat ~/.cassandra/cqlshrc

cqlsh-expansion cassandra.us-east-1.amazonaws.com 9142 --ssl -u

Add Permissions to User

AmazonKeyspacesFullAccess

Add permissions

Review

keyspaces-user

Login Successful

SELECT * FROM system_schema.keyspaces;

USE ecommerce_system;

DESCRIBE TABLE order_details;

-- Set consistency level for writes
CONSISTENCY LOCAL_QUORUM;

-- Insert sample order data
INSERT INTO order_details (customer_id, order_date, order_id, product_name, quantity, unit_price, order_status)
VALUES (uuid(), '2024-01-15', uuid(), 'Wireless Headphones', 2, 99.99, 'shipped');

INSERT INTO order_details (customer_id, order_date, order_id, product_name, quantity, unit_price, order_status)
VALUES (uuid(), '2024-01-14', uuid(), 'Bluetooth Speaker', 1, 149.99, 'delivered');

INSERT INTO order_details (customer_id, order_date, order_id, product_name, quantity, unit_price, order_status)
VALUES (uuid(), '2024-01-13', uuid(), 'Gaming Mouse', 3, 79.99, 'processing');

-- Insert multiple orders for the same customer
INSERT INTO order_details (customer_id, order_date, order_id, product_name, quantity, unit_price, order_status)
VALUES (550e8400-e29b-41d4-a716-446655440000, '2024-01-12', uuid(), 'Mechanical Keyboard', 1, 129.99, 'delivered');

INSERT INTO order_details (customer_id, order_date, order_id, product_name, quantity, unit_price, order_status)
VALUES (550e8400-e29b-41d4-a716-446655440000, '2024-01-10', uuid(), 'USB-C Hub', 2, 49.99, 'shipped');

-- Read all order details (limited for performance)
SELECT * FROM order_details LIMIT 10;

-- Read orders for a specific customer (efficient query using partition key)
SELECT * FROM order_details 
WHERE customer_id = 550e8400-e29b-41d4-a716-446655440000;

-- Read orders within a date range for a customer
SELECT * FROM order_details 
WHERE customer_id = 550e8400-e29b-41d4-a716-446655440000 
AND order_date >= '2024-01-01' 
AND order_date <= '2024-01-31';

-- Update order status (you'll need to use actual UUIDs from your data)
UPDATE order_details 
SET order_status = 'delivered'
WHERE customer_id = 550e8400-e29b-41d4-a716-446655440000 
AND order_date = '2024-01-10' 
AND order_id = [use_actual_order_id_from_your_data];

-- Update quantity and unit price
UPDATE order_details 
SET quantity = 5, unit_price = 45.99
WHERE customer_id = 550e8400-e29b-41d4-a716-446655440000 
AND order_date = '2024-01-10' 
AND order_id = [use_actual_order_id_from_your_data];

-- Delete a specific order
DELETE FROM order_details 
WHERE customer_id = 550e8400-e29b-41d4-a716-446655440000 
AND order_date = '2024-01-10' 
AND order_id = [use_actual_order_id_from_your_data];

-- Delete all orders for a customer on a specific date
DELETE FROM order_details 
WHERE customer_id = 550e8400-e29b-41d4-a716-446655440000 
AND order_date = '2024-01-12';

Enable and Test Point-in-Time Recovery (PITR)

Turn on Point-in-time-recovery

INSERT INTO order_details (customer_id, order_date, order_id, product_name, quantity, unit_price, order_status)
VALUES (uuid(), '2024-01-16', uuid(), 'Test Product for PITR', 1, 1.00, 'test');

SELECT * FROM order_details WHERE product_name = 'Test Product for PITR' ALLOW FILTERING;

DELETE FROM order_details
WHERE customer_id = ;

Wait 5 minutes, then delete the test record.

Note the current time before deleting.

Restore Using PITR (Console Method)

order_details_restored

Restore to a point in time

cqlsh-expansion cassandra.us-east-1.amazonaws.com 9142 --ssl -u

Test PITR

USE ecommerce_system;

SELECT * FROM order_details_restored;

Delete Tables

-- Connect to cqlsh if not already connected
USE ecommerce_system;

-- Drop the restored table
DROP TABLE order_details_restored;

-- Drop the main table
DROP TABLE order_details;

-- Drop the entire keyspace
DROP KEYSPACE ecommerce_system;

Delete keyspace

Delete

Confirm

Delete IAM User

confirm

Amazon Keyspaces

Hands-On

Demo

Agenda

Create user

Set permissions

Review and create

Credentials for Amazon Keyspaces (for Apache Cassandra)

Credentials

Amazon Keyspaces

Create keyspace

Create keyspace

Create table

Create table

Primary key

Table settings

Other Settings

Table tags

Create table

order_details

AWS CloudShell

Add Permissions to User

Add permissions

Review

keyspaces-user

Login Successful

Enable and Test Point-in-Time Recovery (PITR)

Turn on Point-in-time-recovery

Wait 5 minutes, then delete the test record.

Note the current time before deleting.

Restore Using PITR (Console Method)

Restore to a point in time

Test PITR

Delete Tables

Delete keyspace

Delete keyspace

Confirm

Delete IAM User

🙏

Thanks

for

Watching

Amazon Keyspaces - Hands-On Demo

More from Deepak Dubey