SqlSource Class

A copy activity SQL source.

All required parameters must be populated in order to send to server.

Inheritance

azure.mgmt.datafactory.models._models_py3.TabularSource

SqlSource

Constructor

SqlSource(*, additional_properties: Dict[str, MutableMapping[str, Any]] | None = None, source_retry_count: MutableMapping[str, Any] | None = None, source_retry_wait: MutableMapping[str, Any] | None = None, max_concurrent_connections: MutableMapping[str, Any] | None = None, disable_metrics_collection: MutableMapping[str, Any] | None = None, query_timeout: MutableMapping[str, Any] | None = None, additional_columns: MutableMapping[str, Any] | None = None, sql_reader_query: MutableMapping[str, Any] | None = None, sql_reader_stored_procedure_name: MutableMapping[str, Any] | None = None, stored_procedure_parameters: MutableMapping[str, Any] | None = None, isolation_level: MutableMapping[str, Any] | None = None, partition_option: MutableMapping[str, Any] | None = None, partition_settings: _models.SqlPartitionSettings | None = None, **kwargs: Any)

Keyword-Only Parameters

Name	Description
additional_properties	dict[str, <xref:JSON>] Unmatched properties from the message are deserialized to this collection.
source_retry_count	<xref:JSON> Source retry count. Type: integer (or Expression with resultType integer).
source_retry_wait	<xref:JSON> 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	<xref:JSON> The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer).
disable_metrics_collection	<xref:JSON> If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).
query_timeout	<xref:JSON> Query timeout. Type: string (or Expression with resultType string), pattern: ((d+).)?(dd):(60|([0-5][0-9])):(60|([0-5][0-9])).
additional_columns	<xref:JSON> 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	<xref:JSON> SQL reader query. Type: string (or Expression with resultType string).
sql_reader_stored_procedure_name	<xref:JSON> 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	<xref:JSON> Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".
isolation_level	<xref:JSON> 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	<xref:JSON> 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.

Variables

Name	Description
additional_properties	dict[str, <xref:JSON>] Unmatched properties from the message are deserialized to this collection.
type	str Copy source type. Required.
source_retry_count	<xref:JSON> Source retry count. Type: integer (or Expression with resultType integer).
source_retry_wait	<xref:JSON> 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	<xref:JSON> The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer).
disable_metrics_collection	<xref:JSON> If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).
query_timeout	<xref:JSON> Query timeout. Type: string (or Expression with resultType string), pattern: ((d+).)?(dd):(60|([0-5][0-9])):(60|([0-5][0-9])).
additional_columns	<xref:JSON> 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	<xref:JSON> SQL reader query. Type: string (or Expression with resultType string).
sql_reader_stored_procedure_name	<xref:JSON> 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	<xref:JSON> Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".
isolation_level	<xref:JSON> 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	<xref:JSON> 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.