Skip to content

Latest commit

 

History

History
43 lines (30 loc) · 1.34 KB

File metadata and controls

43 lines (30 loc) · 1.34 KB

CSV Extension

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
  • Azure Blob Storage - Csv-AzureBlob
  • AWS S3 - Csv-AwsS3

Settings

See storage extension documentation for any storage specific settings needed (ex. File Storage).

Source

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

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
}