Use Grafana to query and visualize data

When creating an InfluxDB data source that uses SQL to query data:

1. Under HTTP:

   • URL: Provide your InfluxDB cluster URL using the HTTPS protocol:

     https://cluster-host.com
     

2. Under InfluxDB Details:

   • Database: Provide a default database name to query.
   • Token: Provide a database token with read access to the databases you want to query.

3. Click Save & test.

   

When creating an InfluxDB data source that uses InfluxQL to query data:

1. Under HTTP:

   • URL: Provide your InfluxDB Clustered region URL using the HTTPS protocol:

     https://cluster-host.com
     

2. Under InfluxDB Details:

   • Database: Provide a default database name to query.

   • User: Provide an arbitrary string. This credential is ignored when querying InfluxDB Clustered, but it cannot be empty.

   • Password: Provide a database token with read access to the databases you want to query.

   • HTTP Method: Choose one of the available HTTP request methods to use when querying data:

     • POST (Recommended)
     • GET

3. Click Save & test.

   

1. Click Explore.

2. In the dropdown, select the saved InfluxDB data source to query.

3. Use the SQL query form to build your query:

   • Table: Select the measurement to query.

   • Column: Select one or more fields and tags to return as columns in query results.

     With SQL, select the time column to include timestamps with the data. Grafana relies on the time column to correctly graph time series data.

   • Optional: Toggle filter to generate WHERE clause statements.

     • WHERE: Configure condition expressions to include in the WHERE clause.

   • Optional: Toggle group to generate GROUP BY clause statements.

     • GROUP BY: Select columns to group by. If you include an aggregation function in the SELECT list, you must group by one or more of the queried columns. SQL returns the aggregation for each group.

   • Recommended: Toggle order to generate ORDER BY clause statements.

     • ORDER BY: Select columns to sort by. You can sort by time and multiple fields or tags. To sort in descending order, select DESC.

4. Recommended: Change format to Time series.

   • Use the Format dropdown to change the format of the query results. For example, to visualize the query results as a time series, select Time series.

5. Click Run query to execute the query.

1. Click Explore.
2. In the dropdown, select the InfluxDB data source that you want to query.
3. Use the InfluxQL query form to build your query:
   • FROM: Select the measurement that you want to query.
   • WHERE: To filter the query results, enter a conditional expression.
   • SELECT: Select fields to query and an aggregate function to apply to each. The aggregate function is applied to each time interval defined in the GROUP BY clause.
   • GROUP BY: By default, Grafana groups data by time to downsample results and improve query performance. You can also add other tags to group by.
4. Click Run query to execute the query.