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!


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.

Read more

InfluxDB v3 enhancements and InfluxDB Clustered is now generally available

New capabilities, including faster query performance and management tooling advance the InfluxDB v3 product line. InfluxDB Clustered is now generally available.

InfluxDB v3 performance and features

The InfluxDB v3 product line has seen significant enhancements in query performance and has made new management tooling available. These enhancements include an operational dashboard to monitor the health of your InfluxDB cluster, single sign-on (SSO) support in InfluxDB Cloud Dedicated, and new management APIs for tokens and databases.

Learn about the new v3 enhancements


InfluxDB Clustered general availability

InfluxDB Clustered is now generally available and gives you the power of InfluxDB v3 in your self-managed stack.

Talk to us about InfluxDB Clustered

InfluxDB Cloud Serverless