Timestream Data Model Structure

All data stored in a single schemaless record, not separate tables

Time Column
Dimensions (Attributes)
Measures (Metrics)
SensorData Timestream Table
Field Name Data Type Attribute Type Sample Value
timestamp TIMESTAMP TIME 2024-01-15T10:30:00Z
device_id VARCHAR DIMENSION sensor-001
location VARCHAR DIMENSION warehouse-a
sensor_type VARCHAR DIMENSION environmental
temperature DOUBLE MEASURE 22.5
humidity DOUBLE MEASURE 65.3
pressure DOUBLE MEASURE 1013.25

Single Record Structure: All fields exist in one record. Hover over rows to see category details.