SqlMISource Class
A copy activity Azure SQL Managed Instance source.
Constructor
SqlMISource(*args: Any, **kwargs: Any)Variables
| Name | Description |
|---|---|
|
source_retry_count
|
Source retry count. Type: integer (or Expression with resultType integer). |
|
source_retry_wait
|
Source retry wait. Type: string (or Expression with resultType string), pattern: ((d+).)?(dd):(60|([0-5][0-9])):(60|([0-5][0-9])). |
|
max_concurrent_connections
|
The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer). |
|
disable_metrics_collection
|
If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean). |
|
query_timeout
|
Query timeout. Type: string (or Expression with resultType string), pattern: ((d+).)?(dd):(60|([0-5][0-9])):(60|([0-5][0-9])). |
|
additional_columns
|
Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects). |
|
sql_reader_query
|
SQL reader query. Type: string (or Expression with resultType string). |
|
sql_reader_stored_procedure_name
|
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). |
|
stored_procedure_parameters
|
Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}". |
|
isolation_level
|
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). |
|
produce_additional_types
|
Which additional types to produce. |
|
partition_option
|
The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange". Type: string (or Expression with resultType string). |
|
partition_settings
|
The settings that will be leveraged for Sql source partitioning. |
|
type
|
Copy source type. Required. Default value is "SqlMISource". |
Attributes
isolation_level
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).
isolation_level: Any | Nonepartition_option
The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange". Type: string (or Expression with resultType string).
partition_option: Any | Nonepartition_settings
The settings that will be leveraged for Sql source partitioning.
partition_settings: _models.SqlPartitionSettings | Noneproduce_additional_types
Which additional types to produce.
produce_additional_types: Any | Nonesql_reader_query
string (or Expression with resultType string).
sql_reader_query: Any | Nonesql_reader_stored_procedure_name
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).
sql_reader_stored_procedure_name: Any | Nonestored_procedure_parameters
{value: "1", type: "int"}}".
stored_procedure_parameters: Any | Nonetype
Copy source type. Required. Default value is "SqlMISource".
type: Literal['SqlMISource']