Documentation

Use the InfluxDB Data Explorer to query data

Build, execute, and visualize SQL queries in the InfluxDB UI Data Explorer.

Query using saved scripts, the SQL builder, or by manually editing the query. Choose between visualization types for your query.

Query data with SQL and the Data Explorer

  1. In the navigation menu on the left, click Data Explorer.

  2. Activate the SQL Sync toggle in the Schema Browser pane to build your SQL query as you select fields and tag values.

    • Typing within the script editor disables SQL Sync.
    • If you reenable SQL Sync, any selection changes you made in the Schema Browser are copied to the script editor.
  3. Select a Bucket to define your data source.

  4. Select a Measurement from the bucket. Data Explorer inserts a SELECT statement to retrieve all columns in the selected measurement:

    SELECT *
    FROM home
    
  5. To add filter conditions to your query, select from the Fields and Tag Keys lists.

    • Fields: filters for rows that have a non-null value for at least one of the selected field columns.
    • Tag Keys: filters for rows that have all the selected tag values. To learn more, see Query specific fields and tags.
  6. Use the time range dropdown to edit the time range for your query.

  7. Use the script editor to customize your query–for example, to specify what tags and fields to retrieve:

    SELECT temp, time
    FROM home
    
  8. Click the Run button (or press Control+Enter) to run your query and view the results.

See Query data to learn more about building SQL queries.

Save your work

Data Explorer keeps your last change–for example, if you navigate to Buckets or signout and then come back, you’ll see your SQL query and selections in Data Explorer.

To store a query that you can retrieve and reuse, Save your query as a script.

View SQL query results

After you Run your query, Data Explorer displays the results.

  • Click Table for a paginated tabular view of all rows and columns.
  • Click Graph to select a visualization type and options.
  • Click CSV to download query results in a comma-delimited file.

Was this page helpful?

Thank you for your feedback!


Introducing InfluxDB Clustered

A highly available InfluxDB 3.0 cluster on your own infrastructure.

InfluxDB Clustered is a highly available InfluxDB 3.0 cluster built for high write and query workloads on your own infrastructure.

InfluxDB Clustered is currently in limited availability and is only available to a limited group of InfluxData customers. If interested in being part of the limited access group, please contact the InfluxData Sales team.

Learn more
Contact InfluxData Sales

The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Flux is going into maintenance mode and will not be supported in InfluxDB 3.0. This was a decision based on the broad demand for SQL and the continued growth and adoption of InfluxQL. We are continuing to support Flux for users in 1.x and 2.x so you can continue using it with no changes to your code. If you are interested in transitioning to InfluxDB 3.0 and want to future-proof your code, we suggest using InfluxQL.

For information about the future of Flux, see the following:

InfluxDB Cloud Serverless