Adf Dataflow Sql Script Sink Settings Element

API Type:

Varigence.Languages.Biml.DataFactory.AstAdfDataflowSqlScriptSinkSettingsNode

X-Ref:

• Ast Adf Dataflow Sql Script Sink Settings Node
• Ast Adf Dataflow Database Sink Settings Base Node
• Ast Adf Dataflow Sink Settings Base Node

Attributes

Attribute	API Type	Default	Description
AllowDelete	String		Allow rows to be deleted in the sink.
AllowInsert	String		Allow rows to be inserted in the sink.
AllowUpdate	String		Allow rows to be updated in the sink.
AllowUpsert	String		Allow rows to be upserted in the sink.
BatchSize	String	"-1"	Size of batches for columnar caching.
TableAction	AdfDataflowSinkTableAction	None	Select the table action: None, Truncate, Recreate.

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.
<KeyColumns>     Multiple Choices... </KeyColumns>	AstAdfDataflowKeyColumnBaseNode	Choose which column(s) is used to determine if a row from the source matches a row from the sink.
<PostSqlScripts>     <Script /> </PostSqlScripts>	String	This is a collection of scripts to run after the sink action.
<PreSqlScripts>     <Script /> </PreSqlScripts>	String	This is a collection of scripts to run before the sink action.