csv.from() function
The csv.from() function retrieves data from a comma-separated value (CSV) data source.
It returns a stream of tables.
Each unique series is contained within its own table.
Each record in the table represents a single point in the series.
Function type: Input
import "csv"
csv.from(csv: csvData)
// OR
csv.from(file: "/path/to/data-file.csv")
Parameters
csv
Annotated CSV text.
CSV data must use Annotated CSV syntax and include all annotation rows. For more information, see Annotated CSV.
Data type: String
file
The file path of the CSV file to query.
The path can be absolute or relative.
If relative, it is relative to the working directory of the fluxd process.
The CSV file must exist in the same file system running the fluxd process.
InfluxDB OSS and InfluxDB Cloud user interfaces do not support the file parameter.
Neither allow access to the underlying filesystem.
However, the Flux REPL does support the file parameter.
Data type: String
Examples
Query CSV data from a file
import "csv"
csv.from(file: "/path/to/data-file.csv")
Query raw CSV-formatted text
import "csv"
csvData = "
#datatype,string,long,dateTime:RFC3339,dateTime:RFC3339,dateTime:RFC3339,string,string,double
#group,false,false,false,false,false,false,false,false
#default,,,,,,,,
,result,table,_start,_stop,_time,region,host,_value
,mean,0,2018-05-08T20:50:00Z,2018-05-08T20:51:00Z,2018-05-08T20:50:00Z,east,A,15.43
,mean,0,2018-05-08T20:50:00Z,2018-05-08T20:51:00Z,2018-05-08T20:50:20Z,east,B,59.25
,mean,0,2018-05-08T20:50:00Z,2018-05-08T20:51:00Z,2018-05-08T20:50:40Z,east,C,52.62
"
csv.from(csv: csvData)
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.