Dela via


AzureSqlSource Class

Definition

A copy activity Azure SQL source.

[System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.AzureSqlSource+AzureSqlSourceConverter))]
public class AzureSqlSource : Azure.Analytics.Synapse.Artifacts.Models.TabularSource
[<System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.AzureSqlSource+AzureSqlSourceConverter))>]
type AzureSqlSource = class
    inherit TabularSource
Public Class AzureSqlSource
Inherits TabularSource
Inheritance
Attributes

Constructors

AzureSqlSource()

Initializes a new instance of AzureSqlSource.

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

Applies to