Apache Superset
SQL Lab
Dashboards
Charts
Datasets
Database
PostgreSQL // ignition_db
InfluxDB v2 // telemetry
Schema & Tables
scada_telemetry_log
5k+ rows
cyber_security_intel
482 rows
scada_alarms
table
cluster_storage_metrics
1TB NVMe
Interactive SQL Query (PostgreSQL live connector)
Run Query (Ctrl+Enter)
SELECT gateway, round(avg(voltage)::numeric, 2) as avg_voltage, round(avg(current)::numeric, 2) as avg_current, round(avg(power_kw)::numeric, 2) as avg_power_kw, round(avg(rpm)::numeric, 0) as avg_rpm, count(*) as total_samples FROM scada_telemetry_log GROUP BY gateway ORDER BY avg_power_kw DESC;
Executing query against PostgreSQL...
-- ms