--- title: Write data to InfluxDB 3 Core description: Learn how to write time series data to InfluxDB 3 Core using the influxdb3 CLI and line protocol, an efficient, human-readable write syntax. url: https://docs.influxdata.com/influxdb3/core/get-started/write/ estimated_tokens: 4367 product: InfluxDB 3 Core version: core --- # Write data to InfluxDB 3 Core InfluxDB 3 Core is designed for high write-throughput and uses an efficient, human-readable write syntax called *[line protocol](#line-protocol)*. InfluxDB is a schema-on-write database, meaning you can start writing data and InfluxDB creates the logical database, tables, and their schemas automatically, without any required intervention. Once InfluxDB creates the schema, it validates future write requests against the schema before accepting new data. Both new tags and fields can be added later as your schema changes. #### InfluxDB 3 Core is optimized for recent data InfluxDB 3 Core is optimized for recent data but accepts writes from any time period. The system persists data to Parquet files for historical analysis with [InfluxDB 3 Enterprise](/influxdb3/enterprise/get-started/) or third-party tools. For extended historical queries and optimized data organization, consider using [InfluxDB 3 Enterprise](/influxdb3/enterprise/get-started/). - [Line protocol](#line-protocol) - [Construct line protocol](#construct-line-protocol) - [Write data using the CLI](#write-data-using-the-cli) - [Other tools for writing data](#other-tools-for-writing-data) ## Line protocol InfluxDB 3 Core accepts data in [line protocol](/influxdb3/core/reference/syntax/line-protocol/) syntax. Line protocol consists of the following elements: \* Required - \* **table**: A string that identifies the [table](/influxdb3/core/reference/glossary/#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.* - \* **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 one of the following types: - [strings](/influxdb3/clustered/reference/syntax/line-protocol/#string) (quoted) - [floats](/influxdb3/clustered/reference/syntax/line-protocol/#float) - [integers](/influxdb3/clustered/reference/syntax/line-protocol/#integer) - [unsigned integers](/influxdb3/clustered/reference/syntax/line-protocol/#uinteger) - [booleans](/influxdb3/clustered/reference/syntax/line-protocol/#boolean) - **timestamp**: [Unix timestamp](/influxdb3/clustered/reference/syntax/line-protocol/#unix-timestamp) associated with the data. InfluxDB supports up to nanosecond precision. [](#how-are-influxdb-line-protocol-elements-parsed) How are InfluxDB line protocol elements parsed? - **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. *For schema design recommendations, see [InfluxDB schema design recomendations](/influxdb3/core/write-data/best-practices/schema-design/).* myTable,tag1=val1,tag2=val2 field1="v1",field2=1i 0000000000000000000 ## Construct line protocol With a basic understanding of line protocol, you can now construct line protocol and write data to InfluxDB 3 Core. Consider a use case where you collect data from sensors in your home. Each sensor collects temperature, humidity, and carbon monoxide readings. To collect this data, use the following schema: - **table**: `home` - **tags** - `room`: Living Room or Kitchen - **fields** - `temp`: temperature in °C (float) - `hum`: percent humidity (float) - `co`: carbon monoxide in parts per million (integer) - **timestamp**: Unix timestamp in *second* precision The following line protocol sample represents data collected hourly beginning at **2022-01-01T08:00:00Z (UTC)** until **2022-01-01T20:00:00Z (UTC)**. *These timestamps are dynamic and can be updated by clicking the icon in the bottom right corner.* ##### Home sensor data line protocol ```text 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 home,room=Living\ Room temp=21.8,hum=36.0,co=0i 1641031200 home,room=Kitchen temp=22.7,hum=36.1,co=0i 1641031200 home,room=Living\ Room temp=22.2,hum=36.0,co=0i 1641034800 home,room=Kitchen temp=22.4,hum=36.0,co=0i 1641034800 home,room=Living\ Room temp=22.2,hum=35.9,co=0i 1641038400 home,room=Kitchen temp=22.5,hum=36.0,co=0i 1641038400 home,room=Living\ Room temp=22.4,hum=36.0,co=0i 1641042000 home,room=Kitchen temp=22.8,hum=36.5,co=1i 1641042000 home,room=Living\ Room temp=22.3,hum=36.1,co=0i 1641045600 home,room=Kitchen temp=22.8,hum=36.3,co=1i 1641045600 home,room=Living\ Room temp=22.3,hum=36.1,co=1i 1641049200 home,room=Kitchen temp=22.7,hum=36.2,co=3i 1641049200 home,room=Living\ Room temp=22.4,hum=36.0,co=4i 1641052800 home,room=Kitchen temp=22.4,hum=36.0,co=7i 1641052800 home,room=Living\ Room temp=22.6,hum=35.9,co=5i 1641056400 home,room=Kitchen temp=22.7,hum=36.0,co=9i 1641056400 home,room=Living\ Room temp=22.8,hum=36.2,co=9i 1641060000 home,room=Kitchen temp=23.3,hum=36.9,co=18i 1641060000 home,room=Living\ Room temp=22.5,hum=36.3,co=14i 1641063600 home,room=Kitchen temp=23.1,hum=36.6,co=22i 1641063600 home,room=Living\ Room temp=22.2,hum=36.4,co=17i 1641067200 home,room=Kitchen temp=22.7,hum=36.5,co=26i 1641067200 ``` ## Write data using the CLI To quickly get started writing data, use the [`influxdb3 write` command](/influxdb3/core/reference/cli/influxdb3/write/). Include the following: - `--database` option that identifies the target database - `--token` option that specifies the token to use *(unless the `INFLUXDB3_AUTH_TOKEN` environment variable is already set)* - Quoted line protocol data via standard input (stdin) ```bash 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 home,room=Living\ Room temp=21.8,hum=36.0,co=0i 1641031200 home,room=Kitchen temp=22.7,hum=36.1,co=0i 1641031200 home,room=Living\ Room temp=22.2,hum=36.0,co=0i 1641034800 home,room=Kitchen temp=22.4,hum=36.0,co=0i 1641034800 home,room=Living\ Room temp=22.2,hum=35.9,co=0i 1641038400 home,room=Kitchen temp=22.5,hum=36.0,co=0i 1641038400 home,room=Living\ Room temp=22.4,hum=36.0,co=0i 1641042000 home,room=Kitchen temp=22.8,hum=36.5,co=1i 1641042000 home,room=Living\ Room temp=22.3,hum=36.1,co=0i 1641045600 home,room=Kitchen temp=22.8,hum=36.3,co=1i 1641045600 home,room=Living\ Room temp=22.3,hum=36.1,co=1i 1641049200 home,room=Kitchen temp=22.7,hum=36.2,co=3i 1641049200 home,room=Living\ Room temp=22.4,hum=36.0,co=4i 1641052800 home,room=Kitchen temp=22.4,hum=36.0,co=7i 1641052800 home,room=Living\ Room temp=22.6,hum=35.9,co=5i 1641056400 home,room=Kitchen temp=22.7,hum=36.0,co=9i 1641056400 home,room=Living\ Room temp=22.8,hum=36.2,co=9i 1641060000 home,room=Kitchen temp=23.3,hum=36.9,co=18i 1641060000 home,room=Living\ Room temp=22.5,hum=36.3,co=14i 1641063600 home,room=Kitchen temp=23.1,hum=36.6,co=22i 1641063600 home,room=Living\ Room temp=22.2,hum=36.4,co=17i 1641067200 home,room=Kitchen temp=22.7,hum=36.5,co=26i 1641067200' ``` In the code samples, replace the following placeholders with your values: - `DATABASE_NAME`: the name of the [database](/influxdb3/core/admin/databases/) to write to - `AUTH_TOKEN`: your [token](/influxdb3/core/admin/tokens/) ### Write data from a file To write line protocol you have saved to a file, pass the `--file` option–for example, save the [sample line protocol](#home-sensor-data-line-protocol) to a file named `sensor_data` and then enter the following command: ```bash influxdb3 write \ --database DATABASE_NAME \ --token AUTH_TOKEN \ --precision s \ --accept-partial \ --file path/to/sensor_data ``` Replace the following placeholders with your values: - `DATABASE_NAME`: the name of the [database](/influxdb3/core/admin/databases/) to write to. - `AUTH_TOKEN`: your [token](/influxdb3/core/admin/tokens/) ## Other tools for writing data There are many ways to write data to your InfluxDB 3 Core database, including: - [InfluxDB HTTP API](/influxdb3/core/write-data/http-api/): Recommended for batching and higher-volume write workloads. - [InfluxDB client libraries](/influxdb3/core/write-data/client-libraries/): Client libraries that integrate with your code to construct data as time series points and write the data as line protocol to your InfluxDB 3 Core database. - [Telegraf](/telegraf/v1/): A data collection agent with over 300 plugins for collecting, processing, and writing data. For more information, see [Write data to InfluxDB 3 Core](/influxdb3/core/write-data/). [Set up InfluxDB](/influxdb3/core/get-started/setup/) [Query data](/influxdb3/core/get-started/query/) #### Related - [Write data to InfluxDB 3 Core](/influxdb3/core/write-data/) - [Line protocol reference](/influxdb3/core/reference/line-protocol/)