Use Grafana with InfluxDB OSS
- Configure Grafana to use Flux
- Configure Grafana to use InfluxQL
Query and visualize data
- Related

Use Grafana with InfluxDB OSS

Use Grafana or Grafana Cloud to visualize data from your InfluxDB 2.7 instance.

The instructions in this guide require Grafana Cloud or Grafana 10.3+.

Start InfluxDB.
Sign up for Grafana Cloud or download and install Grafana.
Visit your Grafana Cloud user interface (UI) or, if running Grafana locally, start Grafana and visit http://localhost:3000 in your browser.
In the left navigation of the Grafana UI, open the Connections section and select Add new connection.
Select InfluxDB from the list of available data sources and click Add new data source.
On the Data Source configuration page, enter a name for your InfluxDB data source.
In the Query Language drop-down menu, select one of the query languages supported by InfluxDB 2.7 (Flux or InfluxQL):

SQL is only supported in InfluxDB v3.

Flux
InfluxQL

Configure Grafana to use Flux

With Flux selected as the query language in your InfluxDB data source, configure your InfluxDB connection:

Under HTTP, enter the following:
- URL: Your InfluxDB URL.
```
http://localhost:8086/
```
Under InfluxDB Details, enter the following:
- Organization: Your InfluxDB organization name or ID.
- Token: Your InfluxDB API token.
- Default Bucket: The default bucket to use in Flux queries.
- Min time interval: The Grafana minimum time interval. Default is 10s
- Max series: The maximum number of series or tables Grafana will process. Default is 1000.
Click Save & Test. Grafana attempts to connect to the InfluxDB 2.7 datasource and returns the results of the test.

Configure Grafana to use InfluxQL

To query InfluxDB 2.7 with InfluxQL, find your use case below, and then complete the instructions to configure Grafana:

Installed a new InfluxDB 2.7 instance
Upgraded from InfluxDB 1.x to 2.7 (following the official upgrade)
Manually migrated from InfluxDB 1.x to 2.7

Installed a new InfluxDB instance

To configure Grafana to use InfluxQL with a new install of InfluxDB 2.7, do the following:

Upgraded from InfluxDB 1.x to 2.x

To configure Grafana to use InfluxQL when you’ve upgraded from InfluxDB 1.x to InfluxDB 2.7 (following an official upgrade guide):

Authenticate using the non-admin v1 compatible authentication credentials created during the upgrade process.
Use the DBRP mappings InfluxDB automatically created in the upgrade process (no action necessary).

Manually migrated from InfluxDB 1.x to 2.x

To configure Grafana to use InfluxQL when you’ve manually migrated from InfluxDB 1.x to InfluxDB 2.7, do the following:

If your InfluxDB 1.x instance required authentication, create v1 compatible authentication credentials to match your previous 1.x username and password. Otherwise, use InfluxDB v2 token authentication.
Manually create DBRP mappings.

View and create InfluxDB v1 authorizations

InfluxDB 2.7 provides a 1.x compatible authentication API that lets you authenticate with a username and password like InfluxDB 1.x (separate from the credentials used to log into the InfluxDB user interface).

View existing v1 authorizations

Use the influx v1 auth list to list existing InfluxDB v1 compatible authorizations.

influx v1 auth list

Create a v1 authorization

Use the influx v1 auth create command to grant read/write permissions to specific buckets. Provide the following:

bucket IDs to grant read or write permissions to
new username
new password (when prompted)

influx v1 auth create \
  --read-bucket 00xX00o0X001 \
  --write-bucket 00xX00o0X001 \
  --username example-user

View and create InfluxDB DBRP mappings

When using InfluxQL to query InfluxDB, the query must specify a database and a retention policy. InfluxDB DBRP mappings associate database and retention policy combinations with InfluxDB 2.7 buckets.

DBRP mappings do not affect the retention period of the target bucket. These mappings allow queries following InfluxDB 1.x conventions to successfully query InfluxDB 2.7 buckets.

View existing DBRP mappings

Use the influx v1 dbrp list to list existing DBRP mappings.

influx v1 dbrp list

Create a DBRP mapping

Use the influx v1 dbrp create command command to create a DBRP mapping. Provide the following:

database name
retention policy name (not retention period)
bucket ID
(optional) --default flag if you want the retention policy to be the default retention policy for the specified database

influx v1 dbrp create \
  --db example-db \
  --rp example-rp \
  --bucket-id 00xX00o0X001 \
  --default

Repeat for each DBRP combination

Each unique database and retention policy combination used by Grafana must be mapped to an InfluxDB 2.7 bucket. If you have multiple retention policies for a single bucket, set one of the the retention polices as the default using the --default flag.

For more information about DBRP mapping, see Database and retention policy mapping.

Configure your InfluxDB connection

With InfluxQL selected as the query language in your InfluxDB data source settings:

Under HTTP, enter the following:
- URL: Your InfluxDB URL.
```
http://localhost:8086/
```
Configure InfluxDB authentication:
- Token authentication
  - Under Custom HTTP Headers, select Add Header. Provide your InfluxDB API token:
    - Header: Enter Authorization
    - Value: Use the Token schema and provide your InfluxDB API token. For example:
```
Token y0uR5uP3rSecr3tT0k3n
```
  - Under InfluxDB Details, do the following:
    - Database: Enter the database name mapped to your InfluxDB 2.7 bucket
    - HTTP Method: Select GET
- Authenticate with username and password
  Under InfluxDB Details, do the following:
  - Database: Enter the database name mapped to your InfluxDB 2.7 bucket
  - User: Enter the username associated with your InfluxDB 1.x compatibility authorization
  - Password: Enter the password associated with your InfluxDB 1.x compatibility authorization
  - HTTP Method: Select GET
Click Save & Test. Grafana attempts to connect to the InfluxDB 2.7 data source and returns the results of the test.