How to Build Grafana Dashboards with InfluxDB, Flux and InfluxQL

Leverage InfluxQL in InfluxDB Cloud 2 with Grafana 7.1

Do more in your Grafana dashboard queries

  • Joins, to create graphs that span multiple buckets. For example, you might want a Grafana chart that displays both bytes transferred and requests per second; Flux allows you to query these two measurements and join them into a single table.
  • Math across measurements, which go beyond simple joins to allow you to do math on columns in the joined table. For example, you might want to divide an error rate by a request rate to get an error rate percentage.
  • Multiple datasources, allowing you to enrich time series data with metadata from relational databases such as MySQL, MariaDB, Postgres, Microsoft SQL Server, Snowflake, SQLite, AWS Athena, and Google BigTable; or from CSV files. This is useful when, for example, your time series data includes customer number fields but not customer names. Flux allows you to pull in the customer name so that it can be displayed in your Grafana dashboards. Here are some tutorials that explain further.

How to integrate Grafana with InfluxDB

  1. Choose the InfluxDB data source
  2. Choose the Flux language
  3. Fill in the connection details with your InfluxDB Cloud 2 URL, organization, token, and bucket
  • Create two data sources that point to the same InfluxDB instance, once of which uses Flux, and another that uses InfluxQL. (See screenshot below.)
  • Create multiple data sources to connect to different InfluxDB instances.

Demo of Grafana, InfluxDB, Flux and InfluxQL

More flexibility around writes

Availability

  • Grafana 7.1 dashboards using Flux, running against InfluxDB Cloud 2, InfluxDB OSS 2.0, or InfluxDB 1.8+ (Enterprise, Cloud 1, or OSS)
  • Grafana 7.1 dashboards using InfluxQL, running against InfluxDB Cloud 2, or InfluxDB 1.8+ (Enterprise, Cloud 1, or OSS)

What’s the price of Grafana + InfluxDB integration?

Get started with Grafana and InfluxDB

--

--

--

Occasional thoughts on tech, sailing, and San Francisco

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Am I good enough?

I am used to seeing patients in kidney failure Never, however, have I seen patients as sick as…

Wednesday Update from PointPay

How EVM opcodes run in SputnikVM(RUST) — part 1

Functional Endpoints

How to Convert Text to Columns in Excel

How to Fix Modulus Mismatch Error?

Why Python is still the Best Programming Language in 2021

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Al Sargent

Al Sargent

Occasional thoughts on tech, sailing, and San Francisco

More from Medium

CI/CD Pipeline for BitBucket with AWS SAM 🚀

Step-by-step guide to create an autoscaled GitLab runner on AWS

Install cfn_nag on Windows

Build Nginx-HTML Docker Image using Dockerfile

Build Nginx-HTML Docker Image using Dockerfile