influxdb3 query
The influxdb3 query command executes a query against a running
InfluxDB 3 Enterprise server.
Usage
influxdb3 query [OPTIONS] --database <DATABASE_NAME> [QUERY]...Aliases
query, q
Arguments
QUERY: The query to execute. Provide the query in one of the following ways:
- a string
- a path to a file that contains the query using the
--fileoption - from stdin
Options
| Option | Description | |
|---|---|---|
-H | --host | Host URL of the running InfluxDB 3 Enterprise server (default is http://127.0.0.1:8181) |
-d | --database | (Required) Name of the database to operate on |
--token | (Required) Authentication token | |
-l | --language | Query language of the query string (sql (default) or influxql) |
--format | Output format (pretty (default), json, jsonl, csv, parquet) | |
-o | --output | Output query results to the specified file |
-f | --file | A file that contains the query to execute |
--tls-ca | Path to a custom TLS certificate authority (for testing or self-signed certificates) | |
-h | --help | Print help information |
--help-all | Print detailed help information |
Option environment variables
You can use the following environment variables to set command options:
| Environment Variable | Option |
|---|---|
INFLUXDB3_HOST_URL | --host |
INFLUXDB3_DATABASE_NAME | --database |
INFLUXDB3_AUTH_TOKEN | --token |
Examples
- Query data using SQL
- Query data using InfluxQL
- Query data and return JSON-formatted results
- Query data and write results to a file
In the examples below, replace
DATABASE_NAME:
with the name of the database to query.
Query data using SQL
influxdb3 query \
--database DATABASE_NAME \
--token AUTH_TOKEN \
'SELECT * FROM home'influxdb3 query \
--database DATABASE_NAME \
--token AUTH_TOKEN \
--file ./query.sqlcat ./query.sql | influxdb3 query \
--database DATABASE_NAME \
--token AUTH_TOKEN \Query data using InfluxQL
influxdb3 query \
--language influxql \
--database DATABASE_NAME \
--token AUTH_TOKEN \
'SELECT * FROM home'influxdb3 query \
--language influxql \
--database DATABASE_NAME \
--token AUTH_TOKEN \
--file ./query.influxqlcat ./query.influxql | influxdb3 query \
--language influxql \
--database DATABASE_NAME \
--token AUTH_TOKENQuery data and return JSON-formatted results
influxdb3 query \
--format json \
--database DATABASE_NAME \
--token AUTH_TOKEN \
'SELECT * FROM home'influxdb3 query \
--format json \
--database DATABASE_NAME \
--token AUTH_TOKEN \
--file ./query.sqlcat ./query.sql | influxdb3 query \
--format json \
--database DATABASE_NAME \
--token AUTH_TOKEN \Query data and write results to a file
influxdb3 query \
--output /path/to/results.txt \
--database DATABASE_NAME \
--token AUTH_TOKEN \
'SELECT * FROM home'influxdb3 query \
--output /path/to/results.txt \
--database DATABASE_NAME \
--token AUTH_TOKEN \
--file ./query.sqlcat ./query.sql | influxdb3 query \
--output /path/to/results.txt \
--database DATABASE_NAME \
--token AUTH_TOKENWas this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB 3 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.