Grafana Integration

Goal: Build Grafana dashboards from your governed warm queries.

---

Prerequisites

• Grafana instance (self-hosted or cloud)
• JSON API data source plugin installed
• API token from OpenIndustrial

---

Step 1: Install JSON Data Source

In Grafana:

1. Go to Configuration → Data Sources
2. Click Add data source
3. Search for "JSON API"
4. Install if not present

---

Step 2: Configure Data Source

1. Name: OpenIndustrial
2. URL: https://api.openindustrial.co/v1/queries
3. Auth: Add header
   • Header: Authorization
   • Value: Bearer YOUR_TOKEN
4. Click Save & Test

---

Step 3: Create Dashboard

1. Click + New Dashboard
2. Add a panel
3. Select your OpenIndustrial data source
4. Enter query path: /temperature-avg

---

Step 4: Configure Panel

For time-series data:

1. Path: $.results[*]
2. Time field: timestamp
3. Value field: avg_temp

Transformation:

1. Use Grafana transforms to reshape data
2. Apply calculations as needed

---

Template Variables

Create dynamic dashboards:

1. Go to Dashboard Settings → Variables
2. Add variable for query name
3. Use in panel: /${queryVar}

---

Alerting

Set up alerts on your data:

1. Edit panel → Alert tab
2. Define condition (e.g., temp > 80)
3. Configure notification channel
4. Save

---

Best Practices

Practice	Why
One query per panel	Cleaner, more maintainable
Use variables	Change queries without editing
Set appropriate refresh	Balance freshness vs load
Add descriptions	Help team understand dashboards

---

Next Steps

If you want to...	Go to...
Try Power BI instead	Power BI →
Connect AI tools	MCP Guide →