Open Amazon Keyspaces Service: Navigate to the Amazon Keyspaces console after logging into the AWS Management Console.
Create Keyspace:
UserActivityKeyspace
as the name.
Open Keyspace: Locate UserActivityKeyspace
in the Amazon Keyspaces console.
Create Table:
UserActivityTable
.user_id
(UUID), activity_date
(DATE), activity_type
(TEXT), activity_description
(TEXT).user_id
and activity_date
as the primary key.
Open Table: Navigate to UserActivityTable
in UserActivityKeyspace
.
Click "Query table".
Run Below Query
INSERT INTO "UserActivityKeyspace"."UserActivityTable"
(user_id, activity_date, activity_type, activity_description)
VALUES
(uuid(), '2024-01-26', 'login', 'User logged in');
Run Below Query.
Note down UUID
SELECT * FROM "UserActivityKeyspace"."UserActivityTable";
Run Below Query.
Replace UUID.
UPDATE "UserActivityKeyspace"."UserActivityTable"
SET activity_description = 'User logged out'
WHERE user_id = 123e4567-e89b-12d3-a456-426614174000
AND activity_date = '2024-01-26';
Run Below Query.
Note down UUID
SELECT * FROM "UserActivityKeyspace"."UserActivityTable";
Run Below Query.
Replace UUID.
DELETE FROM "UserActivityKeyspace"."UserActivityTable"
WHERE user_id = 123e4567-e89b-12d3-a456-426614174000
AND activity_date = '2024-01-26';
Run Below Query.
SELECT * FROM "UserActivityKeyspace"."UserActivityTable";