What log types can be ingested by Watch Directory?

We’re trying to ingest data generated by SQL queries on a regular basis that can be exported into a local directory in CSV, JSON, XML, etc. Is Watch Directory the best way to do this? Does anyone know what might be the best format to accomplish this?

This is actually a good question that I don’t think I’ve attempted before. Traditionally it pulls .txt and .log files just fine.

JSON should work just fine and would probably your best bet as long as in the JSON file each new entry is it’s own JSON object. Having it in JSON ensures that it will be parsed automatically.

{"foo":"bar1","herp":"derp1"}
{"foo":"bar2","herp":"derp2"}