csv

CSV file plugin

Plugin to query CSV file as a data source.

SQL doesn't allow to query missing columns, like Elasticsearch does. An error field X does not exist will be received. That means you must be very careful with designing a data source and creating a YAML config file to be able to combine it with data source types other than SQL.

The easiest solution is to exclude data source from the global namespace and query it independently, to make sure all columns exist.

curl to test:

curl 'https://localhost:443/api?uuid=auth-key&sql=FROM+csvfile+WHERE+ip=%278.8.8.8%27'

Compile with:

go build -buildmode=plugin -ldflags="-w" -o file-csv.so ./*.go

Access details

Source YAML definition's access fields:

• path: CSV file to use, for example - /data/test.csv