azure.mgmt.datafactory.models.SqlSource class

Constructor

SqlSource(*args: Any, **kwargs: Any)

Variables

Name	Description
source_retry_count	any Source retry count. Type: integer (or Expression with resultType integer).
source_retry_wait	any 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	any The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer).
disable_metrics_collection	any If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).
query_timeout	any Query timeout. Type: string (or Expression with resultType string), pattern: ((d+).)?(dd):(60\|([0-5][0-9])):(60\|([0-5][0-9])).
additional_columns	any 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	any SQL reader query. Type: string (or Expression with resultType string).
sql_reader_stored_procedure_name	any Name of the stored procedure for a SQL Database source. This cannot be used at the same time as SqlReaderQuery. Type: string (or Expression with resultType string).
stored_procedure_parameters	any Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".
isolation_level	any 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).
partition_option	any 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	SqlPartitionSettings The settings that will be leveraged for Sql source partitioning.
type	str Copy source type. Required. Default value is "SqlSource".

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 | None

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_option: Any | None

partition_settings

The settings that will be leveraged for Sql source partitioning.

partition_settings: _models.SqlPartitionSettings | None

sql_reader_query

string (or Expression with resultType string).

sql_reader_query: Any | None

sql_reader_stored_procedure_name

Name of the stored procedure for a SQL Database source. This cannot be used at the same time as SqlReaderQuery. Type: string (or Expression with resultType string).

sql_reader_stored_procedure_name: Any | None

stored_procedure_parameters

{value: "1", type: "int"}}".

stored_procedure_parameters: Any | None

type

Copy source type. Required. Default value is "SqlSource".

type: Literal['SqlSource']