influx write dryrun

influx CLI 2.0.0+
InfluxDB 2.0.0+

This page documents an earlier version of InfluxDB. InfluxDB v2.7 is the latest stable version. View this page in the v2.7 documentation.

The influx write dryrun command prints write output to stdout instead of writing to InfluxDB. Use this command to test writing data.

Supports line protocol, annotated CSV, and extended annotated CSV. Output is always line protocol.

Usage

influx write dryrun [flags]

Flags

Flag		Description	Input type	Maps to ?
`-c`	`—active-config`	CLI configuration to use for command	string
`-b`	`—bucket`	Bucket name (mutually exclusive with `—bucket-id`)	string	`INFLUX_BUCKET_NAME`
	`—bucket-id`	Bucket ID (mutually exclusive with `—bucket`)	string	`INFLUX_BUCKET_ID`
	`—configs-path`	Path to `influx` CLI configurations (default `~/.influxdbv2/configs`)	string	`INFLUX_CONFIGS_PATH`
	`—debug`	Output errors to stderr
	`—encoding`	Character encoding of input (default `UTF-8`)	string
	`—error-file`	Path to a file used for recording rejected row errors	string
`-f`	`—file`	File to import	stringArray
	`—format`	Input format (`lp` or `csv`, default `lp`)	string
	`—header`	Prepend header line to CSV input data	string
`-h`	`—help`	Help for the `dryrun` command
	`—host`	HTTP address of InfluxDB (default `http://localhost:9999`)	string	`INFLUX_HOST`
	`—max-line-length`	Maximum number of bytes that can be read for a single line (default `16000000`)	integer
`-o`	`—org`	Organization name (mutually exclusive with `—org-id`)	string	`INFLUX_ORG`
	`—org-id`	Organization ID (mutually exclusive with `—org`)	string	`INFLUX_ORG_ID`
`-p`	`—precision`	Precision of the timestamps (default `ns`)	string	`INFLUX_PRECISION`
	`—rate-limit`	Throttle write rate (examples: `5MB/5min` or `1MB/s`).	string
	`—skip-verify`	Skip TLS certificate verification		`INFLUX_SKIP_VERIFY`
	`—skipHeader`	Skip first n rows of input data	integer
	`—skipRowOnError`	Output CSV errors to stderr, but continue processing
`-t`	`—token`	API token	string	`INFLUX_TOKEN`
`-u`	`—url`	URL to import data from	stringArray

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, --org or --org-id: InfluxDB organization name or ID
-t, --token: InfluxDB API token
Dry run writing line protocol
Dry run writing CSV data

Line protocol

Dry run writing line protocol via stdin

influx write --bucket example-bucket "
m,host=host1 field1=1.2
m,host=host2 field1=2.4
m,host=host1 field2=5i
m,host=host2 field2=3i
"

Dry run writing line protocol from a file

influx write dryrun \
  --bucket example-bucket \
  --file path/to/line-protocol.txt

Dry run writing line protocol from multiple files

influx write dryrun \
  --bucket example-bucket \
  --file path/to/line-protocol-1.txt \
  --file path/to/line-protocol-2.txt

Dry run writing line protocol from a URL

influx write dryrun \
  --bucket example-bucket \
  --url https://example.com/line-protocol.txt

Dry run writing line protocol from multiple URLs

influx write dryrun \
  --bucket example-bucket \
  --url https://example.com/line-protocol-1.txt \
  --url https://example.com/line-protocol-2.txt

Dry run writing line protocol from multiple sources

influx write dryrun \
  --bucket example-bucket \
  --file path/to/line-protocol-1.txt \
  --url https://example.com/line-protocol-2.txt

CSV

Dry run writing annotated CSV data via stdin

influx write dryrun \
  --bucket example-bucket \
  --format csv \
  "#datatype measurement,tag,tag,field,field,ignored,time
m,cpu,host,time_steal,usage_user,nothing,time
cpu,cpu1,host1,0,2.7,a,1482669077000000000
cpu,cpu1,host2,0,2.2,b,1482669087000000000
"

Dry run writing annotated CSV data from a file

influx write dryrun \
  --bucket example-bucket \
  --file path/to/data.csv

Dry run writing annotated CSV data from multiple files

influx write dryrun \
  --bucket example-bucket \
  --file path/to/data-1.csv \
  --file path/to/data-2.csv

Dry run writing annotated CSV data from a URL

influx write dryrun \
  --bucket example-bucket \
  --url https://example.com/data.csv

Dry run writing annotated CSV data from multiple URLs

influx write dryrun \
  --bucket example-bucket \
  --url https://example.com/data-1.csv \
  --url https://example.com/data-2.csv

Dry run writing annotated CSV data from multiple sources

influx write dryrun \
  --bucket example-bucket \
  --file path/to/data-1.csv \
  --url https://example.com/data-2.csv

Dry run prepending CSV data with annotation headers

influx write dryrun \
  --bucket example-bucket \
  --header "#constant measurement,birds" \
  --header "#datatype dataTime:2006-01-02,long,tag" \
  --file path/to/data.csv

write

influx write dryrun

influx write dryrun

Usage

Flags

Examples

Authentication credentials

Line protocol

Dry run writing line protocol via stdin

Dry run writing line protocol from a file

Dry run writing line protocol from multiple files

Dry run writing line protocol from a URL

Dry run writing line protocol from multiple URLs

Dry run writing line protocol from multiple sources

CSV

Dry run writing annotated CSV data via stdin

Dry run writing annotated CSV data from a file

Dry run writing annotated CSV data from multiple files

Dry run writing annotated CSV data from a URL

Dry run writing annotated CSV data from multiple URLs

Dry run writing annotated CSV data from multiple sources

Dry run prepending CSV data with annotation headers

Related