Building a Grafana dashboard with bit.io

Grafana is a popular dashboard technology that can easily be used to build dashboards from data in bit.io.

In this example, we'll show you how to build a dashboard from Adam's public repository of sensor data - in this case, humidity, temperature, pressure, and air quality.

492492

After logging into Grafana, click on the gear icon and click Data sources

25402540

Click Add Datasource

25462546

Scroll down to PostgreSQL and click Select.

12321232

Pop over to bit.io to grab your credentials - just click on the green Connect button and you can copy the database, password, and username. You'll need them back in Grafana.

19781978

In Grafana fill out the circled fields, and change the Postgres version to 12. Click Save & Test

980980

Click "Back" and then go to the dashboard you want to add your data to, and add a panel.

17721772

Change the data source to your new datasource.

17641764

Add your full schema (username and repo name, in quotes, and the table name) to the FROM box, set your time column, and set your select column - and you're done!


Did this page help you?