SQL Superpowers and Smart Plant Monitoring with Grafana
Details
Agenda:
From SQL Expressions to Plant Monitoring in Grafana: join us to discover new Grafana features and exceptional use-cases.
18:00 Introductions & pizza
18:30 STEM in the garden: how to monitor plants with IoT sensors and Grafana Cloud by Marie Cruz, Senior Developer Advocate at Grafana Labs
Gardening meets Grafana in this beginner-friendly talk.
Marie will walk you through building a complete IoT monitoring pipeline using a soil moisture sensor, Arduino-compatible hardware, and Grafana Cloud.
- Setting up the tech: Arduino, Wi-Fi modules, and soil sensors
- Pushing metrics to the cloud with Prometheus and Grafana
- Designing the dashboard
19:15 Grafana’s New Superpower: Mastering SQL Expressions by Sam Jewell, Senior Software Engineer at Grafana Labs
Join Sam to discover a powerful new feature in Grafana, unlocking more power from your data and revolutionising your experience: SQL Expressions.
What we’ll cover:
- Performing last-mile transformations: show, hide, rename, filter, and order columns
- Using SQL features like subqueries and CTEs for in-memory data manipulation
- Joining data from unlimited data source queries
