influx transpile
Removed in influx CLI v2.0.5
The influx transpile command was removed in v2.0.5 of the influx CLI.
Use SQL or InfluxQL tools to query a InfluxDB Cloud Serverless bucket.
The influx transpile command transpiles an InfluxQL query to Flux source code.
The transpiled query assumes the bucket name is <database>/<retention policy>
and includes absolute time ranges using the provided --now time.
Usage
influx transpile [InfluxQL query] [flags]
The InfluxQL query must be valid and contain both a database and measurement. See the InfluxQL documentation for more information.
Flags
| Flag | Description | |
|---|---|---|
-h | --help | Help for the transpile command |
--now | RFC3339Nano timestamp to use as now() time (default is current UTC time) |
Examples
Authentication credentials
The examples below assume your InfluxDB host, organization, and token are
provided by either the active influx CLI configuration or by environment variables (INFLUX_HOST, INFLUX_ORG, and INFLUX_TOKEN).
If you do not have a CLI configuration set up or the environment variables set, include these required credentials for each command with the following flags:
--host: InfluxDB host-o, --orgor--org-id: InfluxDB organization name or ID-t, --token: InfluxDB API token
Transpile InfluxQL queries to Flux
## Transpile an InfluxQL query that specifies the database,
## retention policy, and measurement.
influx transpile 'SELECT example-field FROM db.rp.measurement'
## Transpile InfluxQL query using default retention policy
influx transpile 'SELECT example-field FROM db..measurement'
Was 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 and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.