Adf Dataflow Inline Azure My Sql Sink Element
X-Ref:
- Ast Adf Dataflow Inline Azure My Sql 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
Attribute | API Type | Default | Description |
---|---|---|---|
InputStreamName | AstAdfDataflowOutputStreamNode | A reference to a previous component's output stream. This is a required reference to an existing definiton. | |
LinkedServiceName | AstAdfAzureMySqlLinkedServiceNode | 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 | |
SkipDuplicateInputColumns | String | 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 | |
SkipDuplicateOutputColumns | String | 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 | |
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. | |
PartitionOption | AdfDataflowPartitionOption | CurrentPartitioning | Specifies how the user would like to handle partitioning inside of dataflow components. |
Table | String | Specifies the name of the source table. | |
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. |
<SinkSettings /> | AstAdfDataflowSqlScriptSinkSettingsNode | AstAdfDataflowSqlScriptSinkSettingsNode objects correspond directly to the abstract base class for all pre-SQL and post-SQL script related sink settings in Azure Data Factory 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. |
<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. |