--- title: Use Grafana to query and visualize data description: Install and run Grafana to query and visualize data stored in InfluxDB. url: https://docs.influxdata.com/influxdb3/cloud-dedicated/process-data/visualize/grafana/ estimated_tokens: 4254 product: InfluxDB Cloud Dedicated version: cloud-dedicated --- # Use Grafana to query and visualize data Use [Grafana](https://grafana.com/) or [Grafana Cloud](https://grafana.com/products/cloud/) to query and visualize data from InfluxDB Cloud Dedicated. #### Identify your InfluxDB version If you are unsure which InfluxDB product you are using, use our interactive version detector to help identify it: [Detect my InfluxDB version](#) > \[Grafana\] enables you to query, visualize, alert on, and explore your metrics, logs, and traces wherever they are stored. \[Grafana\] provides you with tools to turn your time-series database (TSDB) data into insightful graphs and visualizations. > > – [Grafana documentation](https://grafana.com/docs/grafana/latest/introduction/) - [Install Grafana or log in to Grafana Cloud](#install-grafana-or-log-in-to-grafana-cloud) - [InfluxDB data source](#influxdb-data-source) - [Before you begin](#before-you-begin) - [Create an InfluxDB data source](#create-an-influxdb-data-source) - [Query and visualize data](#query-and-visualize-data) ## Install Grafana or log in to Grafana Cloud 1. [Sign up for Grafana Cloud](https://grafana.com/products/cloud/) or follow the [Grafana installation instructions](https://grafana.com/docs/grafana/latest/setup-grafana/installation/) to install Grafana for your operating system. 2. If running Grafana locally, enable the `newInfluxDSConfigPageDesign` feature flag to use the latest InfluxDB data source plugin. [](#option-1-configuration-file-recommended) Option 1: Configuration file (recommended) Add the following to your `grafana.ini` configuration file: ```ini [feature_toggles] enable = newInfluxDSConfigPageDesign ``` Configuration file locations: - **Linux**: `/etc/grafana/grafana.ini` - **macOS (Homebrew)**: `/opt/homebrew/etc/grafana/grafana.ini` - **Windows**: `\conf\grafana.ini` [](#option-2-command-line) Option 2: Command line Enable the feature flag when starting Grafana: **Linux:** ```sh grafana-server --config /etc/grafana/grafana.ini \ cfg:default.feature_toggles.enable=newInfluxDSConfigPageDesign ``` **macOS (Homebrew):** ```sh /opt/homebrew/opt/grafana/bin/grafana server \ --config /opt/homebrew/etc/grafana/grafana.ini \ --homepath /opt/homebrew/opt/grafana/share/grafana \ --packaging=brew \ cfg:default.paths.logs=/opt/homebrew/var/log/grafana \ cfg:default.paths.data=/opt/homebrew/var/lib/grafana \ cfg:default.paths.plugins=/opt/homebrew/var/lib/grafana/plugins \ cfg:default.feature_toggles.enable=newInfluxDSConfigPageDesign ``` **Windows:** ```powershell grafana-server.exe --config \conf\grafana.ini ` cfg:default.feature_toggles.enable=newInfluxDSConfigPageDesign ``` For more information, see [Configure feature toggles](https://grafana.com/docs/grafana/latest/setup-grafana/configure-grafana/feature-toggles/) in the Grafana documentation. 3. Visit your **Grafana Cloud user interface** (UI) or, if running Grafana locally, [start Grafana](https://grafana.com/docs/grafana/latest/installation/) and visit [http://localhost:3000](http://localhost:3000) in your browser. ## InfluxDB data source The InfluxDB data source plugin is included in the Grafana core distribution. Use the plugin to query and visualize data from InfluxDB Cloud Dedicated with both SQL and InfluxQL. #### Grafana 12.2+ The instructions below are for **Grafana 12.2+** with the `newInfluxDSConfigPageDesign` feature flag enabled. This introduces the newest version of the InfluxDB core plugin. The updated plugin includes **SQL support** for InfluxDB 3-based products such as InfluxDB Cloud Dedicated, and the interface dynamically adapts based on your product and query language selection in [URL and authentication](#configure-url-and-authentication). ## Before you begin **Prerequisites:** - Grafana 12.2 or later - Administrator role in Grafana A [database token](/influxdb3/cloud-dedicated/admin/tokens/#database-tokens) with read access to the database ### Quick reference: InfluxDB Cloud Dedicated configuration | Configuration | Value | | --- | --- | | Product selection | InfluxDB Cloud Dedicated | | | **URL** | Cluster URL –for example, `https://cluster-id.a.influxdb.io` | | **Query languages** | SQL (requires HTTP/2), InfluxQL | | **Authentication** | Required (database token) | | **Database/Bucket** | Database name | ## Create an InfluxDB data source 1. In your Grafana interface, click **Connections** in the left sidebar. 2. Click **Data sources**. 3. Click **Add new data source**. 4. Search for and select **InfluxDB**. The InfluxDB data source configuration page displays. 5. In the **Settings** tab, enter a **Name** for your data source. ### Configure URL and authentication In the **URL and authentication** section, configure the following: - **URL**: Your InfluxDB Cloud Dedicated cluster URL –for example, `https://cluster-id.a.influxdb.io` - **Product**: From the dropdown, select **InfluxDB Cloud Dedicated** - **Query Language**: Select **SQL** or **InfluxQL** - *(Optional)* **Advanced HTTP Settings**, **Auth**, and **TLS/SSL Settings** as needed for your environment ### Configure database settings The fields in this section change based on your query language selection in [URL and authentication](#configure-url-and-authentication). **SQL:** #### SQL configuration When you select **SQL** as the query language, configure the following fields: - **Database**: Your [database](/influxdb3/cloud-dedicated/admin/databases/) name. - **Token**: A [database token](/influxdb3/cloud-dedicated/admin/tokens/#database-tokens) with read access to the database ![SQL configuration for {{% product-name %}}](/img/grafana/influxdb3-cloud-dedicated-grafana-sql.png) #### Grafana queries through a proxy require HTTP/2 For SQL queries, Grafana uses the Flight SQL protocol (gRPC) to query InfluxDB Cloud Dedicated, which requires **HTTP/2**. If you query InfluxDB Cloud Dedicated through a proxy (such as HAProxy, nginx, or a load balancer), verify that your proxy is configured to support HTTP/2. Without HTTP/2 support, SQL queries through Grafana will fail to connect. InfluxQL queries use HTTP/1.1 and are not affected by this requirement. Click **Save & test**. Grafana attempts to connect to InfluxDB Cloud Dedicated and returns the result of the test. **InfluxQL:** #### InfluxQL configuration When you select **InfluxQL** as the query language, configure the following fields: - **Database**: Your [database](/influxdb3/cloud-dedicated/admin/databases/) name. - **User**: A username (can be any non-empty value). - **Password**: Your [database token](/influxdb3/cloud-dedicated/admin/tokens/#database-tokens) with read access to the database. - **HTTP Method**: Select **POST** (recommended) or **GET** ![InfluxQL configuration for {{% product-name %}} with DBRP warning](/img/grafana/influxdb3-cloud-dedicated-grafana-influxql.png) Click **Save & test**. Grafana attempts to connect to InfluxDB Cloud Dedicated and returns the result of the test. ## Query and visualize data With your InfluxDB connection configured, use Grafana to query and visualize time series data. ### Query InfluxDB with Grafana After you [configure and save an InfluxDB datasource](#create-an-influxdb-data-source), use Grafana to build, run, and inspect queries against InfluxDB Cloud Dedicated . **SQL:** When working with the InfluxDB Cloud Dedicated SQL implementation a **measurement** is equivalent to a **table**, and **time**, **fields**, and **tags** are structured as **columns**. > To learn more, see [Query Data](/influxdb3/cloud-dedicated/query-data/sql/). 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 table (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. **InfluxQL:** 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. With your InfluxDB connection configured, use Grafana to query and visualize time series data. ### Build visualizations with Grafana For a comprehensive walk-through of creating visualizations with Grafana, see the [Grafana documentation](https://grafana.com/docs/grafana/latest/). ### Query inspection in Grafana To learn more about query management and inspection in Grafana, see the [Grafana Explore documentation](https://grafana.com/docs/grafana/latest/explore/).