Documentation

influx transpile

influx CLI 2.0.0 – 2.0.5

Removed in InfluxDB OSS 2.0.5

The influx transpile command was removed in InfluxDB 2.0.5. Use InfluxQL to query InfluxDB. For information about manually converting InfluxQL queries to Flux, see:

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

FlagDescription
-h--helpHelp for the transpile command
--nowRFC3339Nano 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 the active influx CLI configuration. If you do not have a CLI configuration set up, use the appropriate flags to provide these required credentials.

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'

Set your InfluxDB URL

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.