Condividi tramite


SqlSink Class

Definition

A copy activity SQL sink.

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

Constructors

SqlSink()

Initializes a new instance of SqlSink.

Properties

AdditionalProperties

Additional Properties.

(Inherited from CopySink)
MaxConcurrentConnections

The maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer).

(Inherited from CopySink)
PreCopyScript

SQL pre-copy script. Type: string (or Expression with resultType string).

SinkRetryCount

Sink retry count. Type: integer (or Expression with resultType integer).

(Inherited from CopySink)
SinkRetryWait

Sink 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 CopySink)
SqlWriterStoredProcedureName

SQL writer stored procedure name. Type: string (or Expression with resultType string).

SqlWriterTableType

SQL writer table type. Type: string (or Expression with resultType string).

StoredProcedureParameters

SQL stored procedure parameters.

StoredProcedureTableTypeParameterName

The stored procedure parameter name of the table type. Type: string (or Expression with resultType string).

TableOption

The option to handle sink table, such as autoCreate. For now only 'autoCreate' value is supported. Type: string (or Expression with resultType string).

WriteBatchSize

Write batch size. Type: integer (or Expression with resultType integer), minimum: 0.

(Inherited from CopySink)
WriteBatchTimeout

Write batch timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

(Inherited from CopySink)

Applies to