--- title: Use the influxdb3 CLI to write data description: Use the influxdb3 CLI to write line protocol data to InfluxDB 3 Core. url: https://docs.influxdata.com/influxdb3/core/write-data/influxdb3-cli/ estimated_tokens: 3500 product: InfluxDB 3 Core version: core --- # Use the influxdb3 CLI to write data Use the [`influxdb3` CLI](/influxdb3/core/reference/cli/influxdb3/) to write line protocol data to InfluxDB 3 Core. - [Construct line protocol](#construct-line-protocol) - [Write the line protocol to InfluxDB](#write-the-line-protocol-to-influxdb) #### Use the API for batching and higher-volume writes The `influxdb3` CLI lets you quickly get started writing data to InfluxDB 3 Core. For batching and higher-volume write workloads, use the [InfluxDB HTTP API](/influxdb3/core/write-data/http-api), [API client libraries](/influxdb3/core/write-data/client-libraries/) or [Telegraf](/influxdb3/core/write-data/use-telegraf/). ## Construct line protocol With a [basic understanding of line protocol](/influxdb3/core/write-data/#line-protocol), you can construct data in line protocol format and write it 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 represents the schema described above: ```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 ``` For this tutorial, you can either pass this line protocol directly to the `influxdb3 write` command as a string, via `stdin`, or you can save it to and read it from a file. ## Write the line protocol to InfluxDB Use the [`influxdb3 write` command](/influxdb3/core/reference/cli/influxdb3/write/) to write the home sensor sample data to InfluxDB 3 Core. Provide the following: - The [database](/influxdb3/core/admin/databases/) name using the `--database` option - Your InfluxDB 3 Core [token](/influxdb3/core/admin/tokens/) using the `-t`, `--token` option - [Line protocol](#construct-line-protocol). 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 By default, InfluxDB 3 Core uses the timestamp magnitude to auto-detect the precision. To specify the precision of timestamps in your data, use the [`--precision {ns|us|ms|s}` option](/influxdb3/core/reference/cli/influxdb3/write/#options). **string:** ```sh influxdb3 write \ --database DATABASE_NAME \ --token AUTH_TOKEN \ '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' ``` **file:** 1. In your terminal, enter the following command to create the sample data file: ```sh echo '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.lp ``` 2. Enter the following CLI command to write the data from the sample file: ```sh influxdb3 write \ --database DATABASE_NAME \ --token AUTH_TOKEN \ --file ./home.lp ``` **stdin:** 1. In your terminal, enter the following command to create the sample data file: ```sh echo '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.lp ``` 2. Enter the following CLI command to write the data from the sample file: ```sh cat ./home.lp | influxdb3 write \ --database DATABASE_NAME \ --token AUTH_TOKEN ``` Replace the following: - `DATABASE_NAME`: the name of the database to write to - `AUTH_TOKEN`: your InfluxDB 3 Core [token](/influxdb3/core/admin/tokens/) #### Related - [influxdb3 write](/influxdb3/core/reference/cli/influxdb3/write/) - [Write data to InfluxDB 3 Core](/influxdb3/core/get-started/write/)