Why Skip Grafana?
Picture your business team drowning in spreadsheets, struggling to understand why deployment frequency dropped last quarter. The data is in Grafana, but access is limited to the engineering team. Over 60% of teams, according to McKinsey, face bottlenecks in data accessibility.
Welcome to accessible observability. We’ll show you how to export infrastructure metrics from Datadog, Prometheus, and CloudWatch into formats your entire team can grasp—without needing Grafana.
Exporting Prometheus Metrics
Prometheus, a DevOps favorite, offers a simple HTTP API for metric extraction. To export time-series data:
- 1Access the API: Use
curlto fetch metrics. For example:
curl 'http://your-prometheus-server/api/v1/query?query=up'
This retrieves the current status of your instances.
- 1Parse the JSON: Use tools like
jqto structure the data into CSV or JSON.
curl 'http://your-prometheus-server/api/v1/query?query=up' | jq '.data.result'
- 1Convert to CSV: A simple script transforms JSON to CSV, ready for Dashira visualizations.
Structuring Time-Series CSVs for Dashira
Once you have your data, structuring it is crucial. Dashira excels in creating interactive dashboards from CSVs:
- Headers: Include timestamps, metric names, and values to plot trends over time.
- Consistency: Ensure each row maintains the same structure to prevent data misinterpretation.
Building a Deployment Frequency Trend Chart
With your deployment frequency data exported, visualize it:
- 1Upload to Dashira: Drag-and-drop your CSV onto the platform.
- 2Select Chart Type: Opt for a line chart to display trends over time.
- 3Customize: Add labels, adjust axes, and apply filters for critical insights.
Visualizing P99 Latency Over 7-Day Windows
P99 latency is essential for performance tracking. Here's how:
- 1Aggregate Data: Use SQL or Pandas to calculate rolling averages.
- 2Export as CSV: Ensure your CSV reflects the rolling window format.
- 3Visualize in Dashira: Create a heatmap or line chart to spot anomalies easily.
Creating a Public Read-Only Dashboard
Your business team needs to see metrics, not edit them. Dashira lets you create read-only dashboards:
- Shareable Link: Generate a public link to your dashboard.
- Access Control: Maintain data integrity with view-only access.
Emphasizing DORA Metrics
DORA metrics—deployment frequency, lead time, MTTR, and change failure rate—are goldmines for reporting engineering excellence:
- 1Calculate Metrics: Use your existing data to derive these key metrics.
- 2Visualize Performance: Create dashboards highlighting improvements or areas needing attention.
- 3Share Insights: Empower non-technical stakeholders with clear, actionable insights.
What Not To Do
Avoid overwhelming stakeholders with data dumps. One team compiled a 50-page report only to find executives skimming the first two pages. Focus on clarity and brevity. Highlight what's important.
Conclusion
Translating operational data into clear, sharable insights keeps your team informed and drives strategic decisions. Next time you're tempted to send a Grafana screenshot, remember: your team deserves better.