SqlServerSource Class

Definition

Namespace:

Azure.Analytics.Synapse.Artifacts.Models

Assembly:

Azure.Analytics.Synapse.Artifacts.dll

Package:

Azure.Analytics.Synapse.Artifacts v1.0.0-preview.20

Source:

SqlServerSource.cs

A copy activity SQL server source.

[System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.SqlServerSource+SqlServerSourceConverter))]
public class SqlServerSource : Azure.Analytics.Synapse.Artifacts.Models.TabularSource

[<System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.SqlServerSource+SqlServerSourceConverter))>]
type SqlServerSource = class
    inherit TabularSource

Public Class SqlServerSource
Inherits TabularSource

Inheritance

Object

CopySource

TabularSource

SqlServerSource

Attributes

JsonConverterAttribute

Constructors

SqlServerSource()

Initializes a new instance of SqlServerSource.

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 SQL Database 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"}}".