SqlServerSource Class

A copy activity SQL server source.

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

Inheritance

azure.mgmt.datafactory.models._models_py3.TabularSource

SqlServerSource

Constructor

SqlServerSource(*, additional_properties: Optional[Dict[str, Any]] = None, source_retry_count: Optional[Any] = None, source_retry_wait: Optional[Any] = None, max_concurrent_connections: Optional[Any] = None, disable_metrics_collection: Optional[Any] = None, query_timeout: Optional[Any] = None, additional_columns: Optional[Any] = None, sql_reader_query: Optional[Any] = None, sql_reader_stored_procedure_name: Optional[Any] = None, stored_procedure_parameters: Optional[Dict[str, _models.StoredProcedureParameter]] = None, produce_additional_types: Optional[Any] = None, partition_option: Optional[Any] = None, partition_settings: Optional[_models.SqlPartitionSettings] = None, **kwargs)

Variables

additional_properties

dict[str, any]

Unmatched properties from the message are deserialized to this collection.

type

str

Required. Copy source type.Constant filled by server.

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

dict[<xref:str,azure.mgmt.datafactory.models.StoredProcedureParameter>]

Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".

produce_additional_types

any

Which additional types to produce.

partition_option

any

The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange".

partition_settings

SqlPartitionSettings

The settings that will be leveraged for Sql source partitioning.