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
This scenario is also available on our datastax.com/dev site, where you can find many more resources to help you succeed with Apache Cassandra™.
In this scenario, you explored:
- Schema design for a sensor data use case
- Sample sensor data
- CQL queries over sensor data

Steps
Sensor Data Modeling Example for Cassandra
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;