Documentation

InfluxDB Clustered

influxctl write

  • influxctl 2.4.0+

The influxctl write command writes line protocol to InfluxDB Clustered.

Provide line protocol in one of the following ways:

  • a string on the command line
  • a path to a file that contains line protocol
  • a single dash (-) to read line protocol from stdin

Important to note

  • This command supports only one write request per execution, but does support multiple lines of line protocol and will batch data based on the --batch-size.
  • This command is not meant to be a full, feature-rich write tool. It’s meant for debug, triage, and initial exploration.

InfluxDB connection configuration

Your InfluxDB cluster host and port are configured in your in your influxctl connection profile. Default uses TLS and port 443. You can set a default database and token to use for the query and write commands in your connection profile or pass them with the command using the --database and --token flags. Command line flags override settings in the connection profile.

Usage

influxctl write [flags] <LINE_PROTOCOL>

Arguments

Argument Description
LINE_PROTOCOL Line protocol to write (command line string, path to file, or - to read from stdin)

Flags

Flag Description
--batch-size Number of metrics to write per batch (default is 10000)
--database Database to write to
--precision Precision of data timestamps (ns (default), us, ms, or s)
--timeout Client timeout in seconds (default is 10)
--token Database token with write permissions on the target database
-h --help Output command help

Also see influxctl global flags.

Examples

In the examples below, replace the following:

  • DATABASE_TOKEN: Database token with write access to the target database
  • DATABASE_NAME: Name of the database to write to

Write line protocol to InfluxDB v3

string file stdin

influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  "home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000000000000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000000000000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600000000000
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600000000000
"

influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  /path/to/metrics.lp

cat ./metrics.lp | influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  -

Write line protocol to InfluxDB v3 with non-default timestamp precision

string file stdin

influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  --precision s \
  "home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600
"

influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  --precision s \
  /path/to/metrics.lp

cat ./metrics.lp | influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  --precision s \
  -

Write line protocol to InfluxDB v3 with a custom batch size

string file stdin

influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  --batch-size 5000 \
  "home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600
"

influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  --batch-size 5000 \
  /path/to/metrics.lp

cat ./metrics.lp | influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  --batch-size 5000 \
  -

Write line protocol to InfluxDB v3 with a custom client timeout

string file stdin

influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  --timeout 20 \
  "home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600
"

influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  --timeout 20 \
  /path/to/metrics.lp

cat ./metrics.lp | influxctl write \
  --token 
DATABASE_TOKEN
 \
  --database 
DATABASE_NAME
 \
  --timeout 20 \
  -

Write line protocol to InfluxDB v3 using credentials from the connection profile

The following example uses the database and token defined in the default connection profile.

influxctl write "home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000000000000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000000000000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600000000000
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600000000000
"

View command updates

Was this page helpful?

Thank you for your feedback!

© 2024 InfluxData, Inc.

What is your InfluxDB cluster URL?

Enter your InfluxDB cluster URL and we’ll update code examples for you.

Enter cluster URL

Thank you for your feedback!

Let us know what we can do better:

Thank you!

No thanks

Select a new date

Select a date in your bucket's retention period.

Update

The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

InfluxDB v3 enhancements and InfluxDB Clustered is now generally available

New capabilities, including faster query performance and management tooling advance the InfluxDB v3 product line. InfluxDB Clustered is now generally available.

InfluxDB v3 performance and features

The InfluxDB v3 product line has seen significant enhancements in query performance and has made new management tooling available. These enhancements include an operational dashboard to monitor the health of your InfluxDB cluster, single sign-on (SSO) support in InfluxDB Cloud Dedicated, and new management APIs for tokens and databases.

Learn about the new v3 enhancements

InfluxDB Clustered general availability

InfluxDB Clustered is now generally available and gives you the power of InfluxDB v3 in your self-managed stack.

Talk to us about InfluxDB Clustered