Documentation

influxdb3 write

The influxdb3 write command writes data to your InfluxDB 3 Core server.

Usage

influxdb3 write [OPTIONS] --database <DATABASE_NAME> [LINE_PROTOCOL]...
Aliases

write, w

Arguments

  • LINE_PROTOCOL: The line protocol to write to InfluxDB 3 Core. Provide the line protocol in one of the following ways:

    • a string
    • a path to a file that contains the line protocol using the --file option
    • from stdin

Options

OptionDescription
-H--hostHost URL of the running InfluxDB 3 Core server (default is http://127.0.0.1:8181)
-d--database(Required) Name of the database to operate on
--token(Required) Authentication token
-f--fileA file that contains line protocol to write
--accept-partialAccept partial writes
--no-syncDo not wait for WAL sync before acknowledging the write request
--precisionPrecision of data timestamps (ns, us, ms, or s)
--tls-caPath to a custom TLS certificate authority (for testing or self-signed certificates)
-h--helpPrint help information
--help-allPrint detailed help information

Option environment variables

You can use the following environment variables to set command options:

Environment VariableOption
INFLUXDB3_HOST_URL--host
INFLUXDB3_DATABASE_NAME--database
INFLUXDB3_AUTH_TOKEN--token

Examples

In the examples below, replace the following:

  • DATABASE_NAME: the name of the database to query
  • AUTH_TOKEN: Authentication token

Write line protocol to your InfluxDB 3 server

influxdb3 write \
  --database 
DATABASE_NAME
\
--token
AUTH_TOKEN
\
'home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000'
influxdb3 write \
  --database 
DATABASE_NAME
\
--token
AUTH_TOKEN
\
--file ./data.lp
cat ./data.lp | influxdb3 write \
  --database 
DATABASE_NAME
\
--token
AUTH_TOKEN

Write line protocol and accept partial writes

influxdb3 write \
  --accept-partial \
  --database 
DATABASE_NAME
\
--token
AUTH_TOKEN
\
'home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000'
influxdb3 write \
  --accept-partial \
  --database 
DATABASE_NAME
\
--token
AUTH_TOKEN
\
--file ./data.lp
cat ./data.lp | influxdb3 write \
  --accept-partial \
  --database 
DATABASE_NAME
\
--token
AUTH_TOKEN

Write line protocol with specific timestamp precision

By default, in CLI and HTTP API write requests, InfluxDB 3 Core uses the timestamp magnitude to auto-detect the precision. To avoid any ambiguity, specify the --precision {ns|us|ms|s} option:

influxdb3 write \
  --database 
DATABASE_NAME
\
--token
AUTH_TOKEN
\
--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 '

Write line protocol and immediately return a response

By default, InfluxDB 3 Core waits to respond to write requests until the written data is flushed from the Write-Ahead Log (WAL) to object storage (every 1s by default). Use the --no-sync option to immediately return a response without waiting for the WAL to flush. This improves perceived write response times, but may hide certain types of write errors–for example: malformed line protocol or type conflicts.

Only use --no-sync when low write latency is more important than guaranteed data durability. Avoid using this option for critical or irreplaceable data, as it increases the risk of silent data loss.

influxdb3 write \
  --database 
DATABASE_NAME
\
--token
AUTH_TOKEN
\
--no-sync \ 'home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000'

Was this page helpful?

Thank you for your feedback!


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

New in InfluxDB 3.4

Key enhancements in InfluxDB 3.4 and the InfluxDB 3 Explorer 1.2.

See the Blog Post

InfluxDB 3.4 is now available for both Core and Enterprise, which introduces offline token generation for use in automated deployments and configurable license type selection that lets you bypass the interactive license prompt. InfluxDB 3 Explorer 1.2 is also available, which includes InfluxDB cache management and other new features.

For more information, check out: