GS SQL™ Query Editor
Purpose-built SQL for temporal data. Query the STREAM table with temporal range parameters, roll-up statistics, and time zone-aware functions.
AI & Intelligence
Eight forecasting model types, automatic correlation detection, and a multi-provider AI assistant that queries your data conversationally.
Dashboards & Data Studio
Customizable dashboards with charts, gauges, grids, pivot tables, and maps. Drag-and-drop stream selection, drill-through, and public sharing.
Roll-ups & Derivations
Real-time aggregation from seconds through years, plus Excel-style derived streams that chain formulas across components.
Events & Alerts
Configurable triggers with validation expressions, dwell times, and multi-channel notifications (email, SMS, HTTP, MQTT).
Organization & Security
Role-based security enforced at the query layer — every API, query, and dashboard respects the same permission model. Fine-grained access control, API key scoping, MQTT certificates, and security-aware dashboards.
Quick Links
Frequently Asked Questions • Developer Docs & API • Try a Sandbox
Learning Videos
Watch the full playlist on YouTube.
EL 7: GroveStreams SQL
EL 9: Forecasting the Future with AI
EL 1: Organizations, Components, Streams
EL 2: Real-time Stream Rollups
EL 3: Derived Streams from Expressions
EL 5: Real-time Derivation
EL 6: Templates
EL 4: Derived Streams Troubleshooting
EL 8: GroveStreams MQTT
