The CSV extension provides formatter capabilities for reading from and writing to CSV files.
Note: This is a File Format extension that is only used in combination with Binary Storage extensions.
Note: When specifying the CSV extension as the Source or Sink property in configuration, utilize the names listed below.
Supported storage sinks:
- File - Csv
- Azure Blob Storage - Csv-AzureBlob
- AWS S3 - Csv-AwsS3
Supported storage sources:
- File - Csv
See storage extension documentation for any storage specific settings needed (ex. File Storage).
Source supports an optional Delimiter
parameter (,
by default) and an optional HasHeader
parameter (true
by default). For files without a header, column names will be generated based on the ColumnNameFormat
setting, which uses a default value of column_{0}
to produce columns column_0
, column_1
, etc.
{
"Delimiter": ",",
"HasHeader": true
}
Sink supports an optional Delimiter
parameter (,
by default) and an optional IncludeHeader
parameter (true
by default) to add a leading row of column names.
{
"Delimiter": ",",
"IncludeHeader": true
}