Adf Dataflow Inline Excel Source Element

API Type:

Varigence.Languages.Biml.DataFactory.AstAdfDataflowInlineExcelSourceNode

X-Ref:

• Ast Adf Dataflow Inline Excel Source Node
• Ast Adf Dataflow Inline Document Source Base Node
• Ast Adf Dataflow Dataset Source Base Node
• Ast Adf Dataflow Dataset Base Node
• Ast Adf Dataflow Component Base Node
• Ast Scope Boundary Node

Attributes

Attribute	API Type	Default	Description
LinkedServiceName	AstAdfLinkedServiceBaseNode		Specifies a reference to the linked service that will be used for this inline dataset. This is a required reference to an existing definiton.
Name	String		Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property
Sheet	String		Name of the Excel Sheet. This is a required property
AllowSchemaDrift	String		Select true if your source columns are likely to change during the dataflow. If marked true, all columns pass through the dataflow to the sink.
CompressionLevel	AdfFileCompressionLevel	None	Specifies the compression level (fastest or optimal).
CompressionType	AdfExcelCompressionCodec	None	Specifies the type of compression used.
Container	String		Specifies the target blob container name.
File	String		Specifies the target file name.
FirstRowAsHeader	String		Specifies whether or not the first row in the file should be treated as a list of header labels. The default value is false.
Folder	String		Specifies the target folder name.
Index	String		Specifies the sheet's index.
InferDriftedColumnTypes	String		Allow the auto-detection of the data type of drifted columns
NullValue	String		Specifies the character(s) used to indicate a null value in a column.
PartitionOption	AdfDataflowPartitionOption	CurrentPartitioning	Specifies how the user would like to handle partitioning inside of dataflow components.
Range	String		One sheet's partial data.
RowsLimit	String	"-1"	Limit of number of rows to be imported.
ValidateSchema	String		Dataflow will fail if any column in the dataflow is not found in the source.

Singleton Children

Child	API Type	Description
<RoundRobin />	AstAdfRoundRobinPartitionSettingsNode	Settings node for Round Robin partitioning in dataflow components.
<Hash />	AstAdfHashPartitionSettingsNode	Settings node for Hash partitioning in dataflow components.
<DynamicRange />	AstAdfDynamicRangePartitionSettingsNode	Settings node for Dynamic Range partitioning in dataflow components.
<FixedRange />	AstAdfFixedRangePartitionSettingsNode	Settings node for Fixed Range partitioning in dataflow components.
<Key />	AstAdfKeyPartitionSettingsNode	Settings node for Key partitioning in dataflow components.
<SourceSettings />	AstAdfDataflowDocumentSourceSettingsNode	AstAdfDataflowDocumentSourceSettingsNode objects correspond directly to source settings for avro, excel, orc, and parquet file formats in dataflows.

Collection Children

Child	API Type	Description
<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.
<Columns>     <Column /> </Columns>	AstAdfDataflowDatasetColumnNode	Specifies an optional list of columns to be used as an output from a source or input for a sink.
<Parameters>     <Parameter /> </Parameters>	AstAdfDatasetReferenceParameterNode	Specifies an optional list of parameters to be passed in with the dataset.