• PRODUCTS
  • SUPPORT
  • DOCS
  • PARTNERS
  • COMPANY
  • QUOTE
  • ACCOUNT
  • STORE
QUOTE

Documentation

Support Forums
What can we help you with?
Topics

Dataflow Cloud Component File Format Element

API Type:
Varigence.Languages.Biml.Transformation.AstDataflowCloudComponentFileFormatNode
X-Ref:
  • Ast Dataflow Cloud Component File Format Node

Attributes

AttributeAPI TypeDefaultDescription
ColumnDelimiterString","
Specifies the character used to separate colums in a file.
CompressionCodecCloudFileCompressionCodecGzip
Specifies the compression codec of the file.
CompressionLevelInt320
Specifies the compression level of the file.
EncodingString"UTF-8"
Specifies the name of the encoding used in the file.
EscapeCharString""
Specifies the character used to escape appearances of the ColumnDelimiter within column text data. This property should only be specified if QuoteChar is not provided.
FileTypeCloudFileTypeText
Specifies the type of file format. (e.g. Text, Avro, ORC, etc)
FirstRowAsHeaderBooleanFalse
Specifies whether or not the first row in the file should be treated as a list of header labels. The default value is false.
NullValueString"\\N"
Specifies the character(s) used to indicate a null value in a column.
QuoteCharString 
Specifies the character used to quote a column value when the ColumnDelimiter appears within the text data for a column. This property should only be specified if EscapeChar is not provided.
RowDelimiterString"\\r\\n"
Specifies the character used to separate rows in a file.
SkipLineCountInt320
Specifies the number of lines that should be skipped in the input file before reading data. If FirstRowAsHeader is set to true, the lines will be skipped prior to reading the header row.
TreatEmptyAsNullBooleanTrue
Specifies whether or not empty string values in a column should be treated as null values in the resulting dataset. The default value is false.
UseCompressionBooleanFalse
This value specifies whether to use compression on the file.

Collection Children

ChildAPI TypeDescription
<Annotations>
    <Annotation />
</Annotations>
AstAnnotationNode
This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code.

© Varigence