Skip to content

Latest commit

 

History

History
112 lines (72 loc) · 4.77 KB

GRAFANA.md

File metadata and controls

112 lines (72 loc) · 4.77 KB
Raw

Grafana

When first visiting grafana, you will be provided with a sample dashboard with some basic charts setup from the database

Contents

Section Link
Logging In View Section
Viewing All Dashboards View Section
Customizing a Dashboard View Section
Dashboard Settings View Section
Provisioning a Dashboard View Section
Troubleshooting DB Connection View Section

Logging In

Once the app is up and running, visit http://localhost:3002 to view the Grafana dashboard.

Default login credentials are:

  • Username: admin
  • Password: admin

Viewing All Dashboards

To see all dashboards created in Grafana visit /dashboards

Or, use the sidebar and click on Manage:

Screen Shot 2021-08-06 at 11 27 08 AM

Customizing a Dashboard

When viewing a dashboard, click the top bar of a panel, and go to edit

Screen Shot 2021-08-06 at 11 35 36 AM

Edit Dashboard Panel Page:

grafana-sections

1. Preview Area

  • Top Left is the variable select area (custom dashboard variables, used for switching projects, or grouping data)
  • Top Right we have a toolbar with some buttons related to the display of the data:
    • View data results in a table
    • Time range selector
    • Refresh data button
  • The Main Area will display the chart and should update in real time

Note: Data should refresh automatically, but may require a refresh using the button in some cases

2. Query Builder

Here we form the SQL query to pull data into our chart, from our database

  • Ensure the Data Source is the correct database

    Screen Shot 2021-08-06 at 10 14 22 AM

  • Select Format as Table, and Edit SQL buttons to write/edit queries as SQL

    Screen Shot 2021-08-06 at 10 17 52 AM

  • The Main Area is where the queries are written, and in the top right is the Query Inspector button (to inspect returned data)

    Screen Shot 2021-08-06 at 10 18 23 AM

3. Main Panel Toolbar

In the top right of the window are buttons for:

  • Dashboard settings (regarding entire dashboard)
  • Save/apply changes (to specific panel)

4. Grafana Parameter Sidebar

  • Change chart style (bar/line/pie chart etc)
  • Edit legends, chart parameters
  • Modify chart styling
  • Other Grafana specific settings

Dashboard Settings

When viewing a dashboard click on the settings icon to view dashboard settings. In here there is 2 pages important sections to use:

Screen Shot 2021-08-06 at 1 51 14 PM

  • Variables

    • Create variables to use throughout the dashboard panels, that are also built on SQL queries

    Screen Shot 2021-08-06 at 2 02 40 PM

  • JSON Model

    • Copy json code here and save it to a new file in /grafana/dashboards/ with a unique name in the lake repo. This will allow us to persist dashboards when we load the app

    Screen Shot 2021-08-06 at 2 02 52 PM

Provisioning a Dashboard

To save a dashboard in the lake repo and load it:

  1. Create a dashboard in browser (visit /dashboard/new, or use sidebar)
  2. Save dashboard (in top right of screen)
  3. Go to dashboard settings (in top right of screen)
  4. Click on JSON Model in sidebar
  5. Copy code into a new .json file in /grafana/dashboards

Troubleshooting DB Connection

To ensure we have properly connected our database to the data source in Grafana, check database settings in ./grafana/datasources/datasource.yml, specifically:

  • database
  • user
  • secureJsonData/password