Use the influxdb3 CLI to write data
InfluxDB 3 Enterprise is in Public Beta
InfluxDB 3 Enterprise is in public beta and available for testing and feedback, but is not meant for production use yet. Both the product and this documentation are works in progress. We welcome and encourage your input about your experience with the beta and invite you to join our public channels for updates and to share feedback.
Use the influxdb3 CLI
to write line protocol data to InfluxDB 3 Enterprise.
Construct line protocol
With a basic understanding of line protocol, you can now construct line protocol and write data to InfluxDB 3 Enterprise. 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
- tags
The following line protocol represent the schema described above:
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
to write the home sensor sample data to InfluxDB 3 Enterprise.
Provide the following:
The database name using the
--databaseoptionYour InfluxDB 3 Enterprise authorization token using the
-t,--tokenoptionLine 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
--fileoption - from stdin
InfluxDB 3 Enterprise auto-detects the timestamp precision by identifying which precision results in timestamps relatively close to “now.”
In your terminal, enter the following command to create the sample data file:
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.lpEnter the following CLI command to write the data from the sample file:
influxdb3 write \ --databaseDATABASE_NAME\ --tokenAUTH_TOKEN\ ./home.lp
In your terminal, enter the following command to create the sample data file:
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.lpEnter the following CLI command to write the data from the sample file:
cat ./home.lp | influxdb3 write \ --databaseDATABASE_NAME\ --tokenAUTH_TOKEN
Replace the following:
DATABASE_NAME: the name of the database to write toAUTH_TOKEN: your InfluxDB 3 Enterprise authorization tokenWhile in beta, InfluxDB 3 Enterprise does not require an authorization token.
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB 3 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.