SqlMISource Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
A copy activity Azure SQL Managed Instance source.
[System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.SqlMISource+SqlMISourceConverter))]
public class SqlMISource : Azure.Analytics.Synapse.Artifacts.Models.TabularSource[<System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.SqlMISource+SqlMISourceConverter))>]
type SqlMISource = class
inherit TabularSourcePublic Class SqlMISource
Inherits TabularSource- Inheritance
- Attributes
Constructors
| SqlMISource() |
Initializes a new instance of SqlMISource. |
Properties
| AdditionalColumns |
Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects). (Inherited from TabularSource) |
| AdditionalProperties |
Additional Properties. (Inherited from CopySource) |
| IsolationLevel |
Specifies the transaction locking behavior for the SQL source. Allowed values: ReadCommitted/ReadUncommitted/RepeatableRead/Serializable/Snapshot. The default value is ReadCommitted. Type: string (or Expression with resultType string). |
| MaxConcurrentConnections |
The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer). (Inherited from CopySource) |
| PartitionOption |
The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange". |
| PartitionSettings |
The settings that will be leveraged for Sql source partitioning. |
| ProduceAdditionalTypes |
Which additional types to produce. |
| QueryTimeout |
Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])). (Inherited from TabularSource) |
| SourceRetryCount |
Source retry count. Type: integer (or Expression with resultType integer). (Inherited from CopySource) |
| SourceRetryWait |
Source retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])). (Inherited from CopySource) |
| SqlReaderQuery |
SQL reader query. Type: string (or Expression with resultType string). |
| SqlReaderStoredProcedureName |
Name of the stored procedure for a Azure SQL Managed Instance source. This cannot be used at the same time as SqlReaderQuery. Type: string (or Expression with resultType string). |
| StoredProcedureParameters |
Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}". |
