Difficulty: Beginner
Estimated Time: 15 minutes

In this scenario, you will:

  • Create tables for a sensor data use case
  • Populate tables with sample sensor data
  • Design and execute CQL queries over sensor data

In this scenario, you explored:

  • Schema design for a sensor data use case
  • Sample sensor data
  • CQL queries over sensor data

Sensor Data Modeling Example

Step 1 of 7

Create a keyspace

Create the sensor_data keyspace:

CREATE KEYSPACE sensor_data
WITH replication = {
  'class': 'NetworkTopologyStrategy', 
  'DC-Houston': 1 };

Set the current working keyspace:

USE sensor_data;