3.8 KiB
Use tools like the influxctl
CLI, Telegraf, and InfluxDB client libraries to
to write time series data to {{< product-name >}}. Line protocol
is the text-based format used to write data to InfluxDB. There are tools
available to covert other formats (for example—CSV)
to line protocol.
- Line protocol
- Write data to InfluxDB {{< children type="anchored-list" >}}
{{% show-in "core,enterprise" %}}
[!Note]
Choose the write endpoint for your workload
When creating new write workloads, use the HTTP API
/api/v3/write_lp
endpoint with client libraries.When bringing existing v1 write workloads, use the {{% product-name %}} HTTP API
/write
endpoint.When bringing existing v2 write workloads, use the {{% product-name %}} HTTP API
/api/v2/write
endpoint. {{% /show-in %}}
{{% hide-in "core,enterprise" %}}
[!Note]
Choose the write endpoint for your workload
When bringing existing v1 write workloads, use the {{% product-name %}} HTTP API
/write
endpoint. When creating new write workloads, use the HTTP API/api/v2/write
endpoint. {{% /hide-in %}}
Line protocol
All data written to InfluxDB is written using line protocol, a text-based format that lets you provide the necessary information to write a data point to InfluxDB.
Line protocol elements
In InfluxDB, a point contains a table name, one or more fields, a timestamp, and optional tags that provide metadata about the observation.
Each line of line protocol contains the following elements:
{{< req type="key" >}}
- {{< req "*" >}} table: A string that identifies the table to store the data in.
- tag set: Comma-delimited list of key value pairs, each representing a tag. Tag keys and values are unquoted strings. Spaces, commas, and equal characters must be escaped.
- {{< req "*" >}} field set: Comma-delimited list of key value pairs, each representing a field. Field keys are unquoted strings. Spaces and commas must be escaped. Field values can be strings (quoted), floats, integers, unsigned integers, or booleans.
- timestamp: Unix timestamp associated with the data. InfluxDB supports up to nanosecond precision. If the precision of the timestamp is not in nanoseconds, you must specify the precision when writing the data to InfluxDB.
Line protocol element parsing
- table: Everything before the first unescaped comma before the first whitespace.
- tag set: Key-value pairs between the first unescaped comma and the first unescaped whitespace.
- field set: Key-value pairs between the first and second unescaped whitespaces.
- timestamp: Integer value after the second unescaped whitespace.
- Lines are separated by the newline character (
\n
). Line protocol is whitespace sensitive.
{{< influxdb/line-protocol version="v3" >}}
For schema design recommendations, see InfluxDB schema design.
Write data to InfluxDB
{{< children >}}