Influxdata
/
docs-v2
mirror of https://github.com/influxdata/docs-v2.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity
docs-v2/content/influxdb3/cloud-serverless/query-data/execute-queries/data-explorer.md

3.1 KiB
Raw Permalink Blame History

title description weight menu influxdb3/cloud-serverless/tags aliases related metadata
Use the InfluxDB Data Explorer to query data Query your data in the InfluxDB user interface (UI) Data Explorer. 201
influxdb3_cloud_serverless
name parent
Use the Data Explorer Execute queries
query
/influxdb3/cloud-serverless/query-data/execute-queries/sql/data-explorer/
/influxdb3/cloud-serverless/query-data/sql/
/influxdb3/cloud-serverless/query-data/flux-sql/
SQL

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.

    {{< nav-icon "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.

{{% note %}}

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, {{% caps %}}Save{{% /caps %}} your query as a script.

{{% /note %}}

View SQL query results

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

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