Write data to InfluxDB

Use Chronograf to write data to InfluxDB. Choose from the following methods:

• Upload line protocol through the Chronograf UI
• Use the InfluxQL INTO clause in a query
• Use the Flux to() function in a query

Upload line protocol through the Chronograf UI

1. Select Explore in the left navigation bar.

2. Click Write Data in the top right corner of the Data Explorer.

   

3. Select the database (if an InfluxQL data source is selected) or database and retention policy (if a Flux data source is selected) to write to.

   

4. Select one of the following methods for uploading line protocol:

   • Upload File: Upload a file containing line protocol to write to InfluxDB. Either drag and drop a file into the file uploader or click to use your operating systems file selector and choose a file to upload.
   • Manual Entry: Manually enter line protocol to write to InfluxDB.

5. Select the timestamp precision of your line protocol. Chronograf supports the following units:

   • s (seconds)
   • ms (milliseconds)
   • u (microseconds)
   • ns (nanoseconds)
   

6. Click Write.

Use the InfluxQL INTO clause in a query

To write data back to InfluxDB with an InfluxQL query, include the INTO clause in your query:

1. Select Explore in the left navigation bar.

2. Select InfluxQL as your data source type.

3. Write an InfluxQL query that includes the INTO clause. Specify the database, retention policy, and measurement to write to. For example:

   SELECT *
   INTO "mydb"."autogen"."example-measurement"
   FROM "example-db"."example-rp"."example-measurement"
   GROUP BY *
   

4. Click Submit Query.

Use the Flux to() function in a query

To write data back to InfluxDB with an InfluxQL query, include the INTO clause in your query:

1. Select Explore in the left navigation bar.

2. Select Flux as your data source type.

   To query InfluxDB with Flux, enable Flux in your InfluxDB configuration.

3. Write an Flux query that includes the to() function. Provide the database and retention policy to write to. Use the db-name/rp-name syntax:

   from(bucket: "example-db/example-rp")
     |> range(start: -30d)
     |> filter(fn: (r) => r._measurement == "example-measurement")
     |> to(bucket: "mydb/autogen")
   

4. Click Run Script.