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(file: "/path/to/data-file.csv")
// OR
csv.from(csv: csvData)
Parameters
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 influxd
process.
The CSV file must exist in the same file system running the influxd
process.
InfluxDB Cloud does not support the file
parameter.
Data type: String
csv
Raw CSV-formatted text.
CSV data must use Annotated CSV syntax and include all annotation rows. For more information, see Annotated CSV.
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)
Bug Reports and Feedback
Thank you for being willing to help test InfluxDB v2.0 alpha! Feedback and bug reports are welcome and encouraged both for InfluxDB and this documentation. Submit feedback using one of the following methods:
- Post in the InfluxData Community
- In the InfluxDB UI, click Feedback in the left navigation bar.
- Submit documentation issues to the InfluxDB 2.0 documentation repository.
- Submit InfluxDB issues to the InfluxDB repository.