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

Documentation

Support Forums
What can we help you with?
Topics

Adf Dataflow Inline Delta Sink Element

API Type:
Varigence.Languages.Biml.DataFactory.AstAdfDataflowInlineDeltaSinkNode
X-Ref:
  • Ast Adf Dataflow Inline Delta Sink Node
  • Ast Adf Dataflow Dataset Sink Base Node
  • Ast Adf Dataflow Dataset Base Node
  • Ast Adf Dataflow Component Base Node
  • Ast Scope Boundary Node

Attributes

AttributeAPI TypeDefaultDescription
InputStreamNameAstAdfDataflowOutputStreamNode 
A reference to a previous component's output stream. This is a required reference to an existing definiton.
LinkedServiceNameAstAdfLinkedServiceBaseNode 
Specifies a reference to the linked service that will be used for this inline dataset. This is a required reference to an existing definiton.
NameString 
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
SkipDuplicateInputColumnsString 
If the same input column is used in more than one mapping, then any instance after the first will be skipped. This is a required property
SkipDuplicateOutputColumnsString 
If a mapping will produce an output column that matches another column, then each instance after the first will be skipped. This is a required property
AllowSchemaDriftString 
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.
AutoCompactString 
After an individual write, checks if files can further be compacted, and runs a quick OPTIMIZE job (with 128 MB file sizes instead of 1GB) to further compact files for partitions that have the most number of small files.
CompressionLevelAdfFileCompressionLevelNone
Specifies the compression level (fastest or optimal).
CompressionTypeAdfDelimitedTextCompressionCodecNone
Specifies the type of compression used.
ContainerString 
Specifies the target blob container name.
FileSystemString 
Specifies the target FileSystem for ADLS linked services.
FolderString 
Specifies the target folder name.
MergeSchemaString 
All columns that are present in the previous stream but not in the Delta table are added to the end of the schema
OptimizeWriteString 
Dynamically optimize partition sizes based on the actual data by attempting to write out 128 MB files for each table partition. This is an approximate size and can vary depending on dataset characteristics.
PartitionOptionAdfDataflowPartitionOptionCurrentPartitioning
Specifies how the user would like to handle partitioning inside of dataflow components.
VacuumString 
Remove files no longer referenced by a Delta table and are older than this retention threshold in hours. Retention threshold will be 30 days if leaving this value as empty or 0.
ValidateSchemaString 
Dataflow will fail if any column in the dataflow is not found in the source.

Singleton Children

ChildAPI TypeDescription
<DatabaseSinkSettings />AstAdfDataflowSnowflakeSinkSettingsNodeAstAdfDataflowSnowflakeSinkSettingsNode objects correspond directly to the class for all Snowflake related sink settings in Azure Data Factory Dataflows.
<RoundRobin />AstAdfRoundRobinPartitionSettingsNodeSettings node for Round Robin partitioning in dataflow components.
<Hash />AstAdfHashPartitionSettingsNodeSettings node for Hash partitioning in dataflow components.
<DynamicRange />AstAdfDynamicRangePartitionSettingsNodeSettings node for Dynamic Range partitioning in dataflow components.
<FixedRange />AstAdfFixedRangePartitionSettingsNodeSettings node for Fixed Range partitioning in dataflow components.
<Key />AstAdfKeyPartitionSettingsNodeSettings node for Key partitioning in dataflow components.

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.
<ColumnMappings>
    Multiple Choices...
</ColumnMappings>
AstAdfDataflowComponentColumnBaseNode
This is a collection of column mappings that are used to map the columns to the sink.
<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.

© Varigence