AzureSqlSink interface

Package:

@azure/synapse-artifacts

A copy activity Azure SQL sink.

Extends

CopySink

Properties

preCopyScript	SQL pre-copy script. Type: string (or Expression with resultType string).
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).
type	Polymorphic discriminator, which specifies the different types this object can be

Inherited Properties

maxConcurrentConnections	The maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer).
sinkRetryCount	Sink retry count. Type: integer (or Expression with resultType integer).
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])).
writeBatchSize	Write batch size. Type: integer (or Expression with resultType integer), minimum: 0.
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])).

Property Details

preCopyScript

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

preCopyScript?: any

Property Value

any

sqlWriterStoredProcedureName

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

sqlWriterStoredProcedureName?: any

Property Value

any

sqlWriterTableType

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

sqlWriterTableType?: any

Property Value

any

storedProcedureParameters

SQL stored procedure parameters.

storedProcedureParameters?: any

Property Value

any

storedProcedureTableTypeParameterName

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

storedProcedureTableTypeParameterName?: any

Property Value

any

tableOption

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

tableOption?: any

Property Value

any

type

Polymorphic discriminator, which specifies the different types this object can be

type: "AzureSqlSink"

Property Value

"AzureSqlSink"

Inherited Property Details

maxConcurrentConnections

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

maxConcurrentConnections?: any

Property Value

any

Inherited From CopySink.maxConcurrentConnections

sinkRetryCount

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

sinkRetryCount?: any

Property Value

any

Inherited From CopySink.sinkRetryCount

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])).

sinkRetryWait?: any

Property Value

any

Inherited From CopySink.sinkRetryWait

writeBatchSize

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

writeBatchSize?: any

Property Value

any

Inherited From CopySink.writeBatchSize

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])).

writeBatchTimeout?: any

Property Value

any

Inherited From CopySink.writeBatchTimeout