Feeding flat json from a kafka topic to CrateDB using telegraf

Turns out, we had to configure some more fields on telegraf agent that is responsible for ingesting data to CrateDB as suggested.

We had to specify the fields with the following addition to telegraf.conf file:

       data_format = "json"
       json_string_fields = ["SOURCE","PROGRAM","PRIORITY","MESSAGE","LEGACY_MSGHDR","HOST_FROM","HOST","FACILITY"]
       json_time_key = "DATE"
       json_time_format = "2006-01-02T15:04:05Z07:00"
2 Likes