SqlMISink Class

Package:
com.azure.analytics.synapse.artifacts.models
Maven Artifact:
com.azure:azure-analytics-synapse-artifacts:1.0.0-beta.17

public final class SqlMISink
extends CopySink

A copy activity Azure SQL Managed Instance sink.

Constructor Summary

Constructor Description
SqlMISink()

Creates an instance of SqlMISink class.

Method Summary

Modifier and Type Method and Description
static SqlMISink fromJson(JsonReader jsonReader)

Reads an instance of SqlMISink from the JsonReader.
Object getPreCopyScript()

Get the preCopyScript property: SQL pre-copy script.
Object getSqlWriterStoredProcedureName()

Get the sqlWriterStoredProcedureName property: SQL writer stored procedure name.
Object getSqlWriterTableType()

Get the sqlWriterTableType property: SQL writer table type.
Object getStoredProcedureParameters()

Get the storedProcedureParameters property: SQL stored procedure parameters.
Object getStoredProcedureTableTypeParameterName()

Get the storedProcedureTableTypeParameterName property: The stored procedure parameter name of the table type.
Object getTableOption()

Get the tableOption property: The option to handle sink table, such as autoCreate.
String getType()

Get the type property: Copy sink type.
SqlMISink setMaxConcurrentConnections(Object maxConcurrentConnections)

Set the maxConcurrentConnections property: The maximum concurrent connection count for the sink data store.
SqlMISink setPreCopyScript(Object preCopyScript)

Set the preCopyScript property: SQL pre-copy script.
SqlMISink setSinkRetryCount(Object sinkRetryCount)

Set the sinkRetryCount property: Sink retry count.
SqlMISink setSinkRetryWait(Object sinkRetryWait)

Set the sinkRetryWait property: Sink retry wait.
SqlMISink setSqlWriterStoredProcedureName(Object sqlWriterStoredProcedureName)

Set the sqlWriterStoredProcedureName property: SQL writer stored procedure name.
SqlMISink setSqlWriterTableType(Object sqlWriterTableType)

Set the sqlWriterTableType property: SQL writer table type.
SqlMISink setStoredProcedureParameters(Object storedProcedureParameters)

Set the storedProcedureParameters property: SQL stored procedure parameters.
SqlMISink setStoredProcedureTableTypeParameterName(Object storedProcedureTableTypeParameterName)

Set the storedProcedureTableTypeParameterName property: The stored procedure parameter name of the table type.
SqlMISink setTableOption(Object tableOption)

Set the tableOption property: The option to handle sink table, such as autoCreate.
SqlMISink setWriteBatchSize(Object writeBatchSize)

Set the writeBatchSize property: Write batch size.
SqlMISink setWriteBatchTimeout(Object writeBatchTimeout)

Set the writeBatchTimeout property: Write batch timeout.
JsonWriter toJson(JsonWriter jsonWriter)

Methods inherited from CopySink

fromJson getAdditionalProperties getMaxConcurrentConnections getSinkRetryCount getSinkRetryWait getType getWriteBatchSize getWriteBatchTimeout setAdditionalProperties setMaxConcurrentConnections setSinkRetryCount setSinkRetryWait setWriteBatchSize setWriteBatchTimeout toJson

Methods inherited from java.lang.Object

clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Constructor Details

SqlMISink

public SqlMISink()

Creates an instance of SqlMISink class.

Method Details

fromJson

public static SqlMISink fromJson(JsonReader jsonReader)

Reads an instance of SqlMISink from the JsonReader.

Parameters:

jsonReader - The JsonReader being read.

Returns:

An instance of SqlMISink if the JsonReader was pointing to an instance of it, or null if it was pointing to JSON null.

Throws:

IOException

 - If an error occurs while reading the SqlMISink.

getPreCopyScript

public Object getPreCopyScript()

Get the preCopyScript property: SQL pre-copy script. Type: string (or Expression with resultType string).

Returns:

the preCopyScript value.

getSqlWriterStoredProcedureName

public Object getSqlWriterStoredProcedureName()

Get the sqlWriterStoredProcedureName property: SQL writer stored procedure name. Type: string (or Expression with resultType string).

Returns:

the sqlWriterStoredProcedureName value.

getSqlWriterTableType

public Object getSqlWriterTableType()

Get the sqlWriterTableType property: SQL writer table type. Type: string (or Expression with resultType string).

Returns:

the sqlWriterTableType value.

getStoredProcedureParameters

public Object getStoredProcedureParameters()

Get the storedProcedureParameters property: SQL stored procedure parameters.

Returns:

the storedProcedureParameters value.

getStoredProcedureTableTypeParameterName

public Object getStoredProcedureTableTypeParameterName()

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

Returns:

the storedProcedureTableTypeParameterName value.

getTableOption

public Object getTableOption()

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

Returns:

the tableOption value.

getType

public String getType()

Get the type property: Copy sink type.

Overrides:

SqlMISink.getType()

Returns:

the type value.

setMaxConcurrentConnections

public SqlMISink setMaxConcurrentConnections(Object maxConcurrentConnections)

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

Overrides:

SqlMISink.setMaxConcurrentConnections(Object maxConcurrentConnections)

Parameters:

maxConcurrentConnections

setPreCopyScript

public SqlMISink setPreCopyScript(Object preCopyScript)

Set the preCopyScript property: SQL pre-copy script. Type: string (or Expression with resultType string).

Parameters:

preCopyScript - the preCopyScript value to set.

Returns:

the SqlMISink object itself.

setSinkRetryCount

public SqlMISink setSinkRetryCount(Object sinkRetryCount)

Set the sinkRetryCount property: Sink retry count. Type: integer (or Expression with resultType integer).

Overrides:

SqlMISink.setSinkRetryCount(Object sinkRetryCount)

Parameters:

sinkRetryCount

setSinkRetryWait

public SqlMISink setSinkRetryWait(Object sinkRetryWait)

Set the sinkRetryWait property: Sink retry wait. Type: string (or Expression with resultType string), pattern: ((\d+)\.)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

Overrides:

SqlMISink.setSinkRetryWait(Object sinkRetryWait)

Parameters:

sinkRetryWait

setSqlWriterStoredProcedureName

public SqlMISink setSqlWriterStoredProcedureName(Object sqlWriterStoredProcedureName)

Set the sqlWriterStoredProcedureName property: SQL writer stored procedure name. Type: string (or Expression with resultType string).

Parameters:

sqlWriterStoredProcedureName - the sqlWriterStoredProcedureName value to set.

Returns:

the SqlMISink object itself.

setSqlWriterTableType

public SqlMISink setSqlWriterTableType(Object sqlWriterTableType)

Set the sqlWriterTableType property: SQL writer table type. Type: string (or Expression with resultType string).

Parameters:

sqlWriterTableType - the sqlWriterTableType value to set.

Returns:

the SqlMISink object itself.

setStoredProcedureParameters

public SqlMISink setStoredProcedureParameters(Object storedProcedureParameters)

Set the storedProcedureParameters property: SQL stored procedure parameters.

Parameters:

storedProcedureParameters - the storedProcedureParameters value to set.

Returns:

the SqlMISink object itself.

setStoredProcedureTableTypeParameterName

public SqlMISink setStoredProcedureTableTypeParameterName(Object storedProcedureTableTypeParameterName)

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

Parameters:

storedProcedureTableTypeParameterName - the storedProcedureTableTypeParameterName value to set.

Returns:

the SqlMISink object itself.

setTableOption

public SqlMISink setTableOption(Object tableOption)

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

Parameters:

tableOption - the tableOption value to set.

Returns:

the SqlMISink object itself.

setWriteBatchSize

public SqlMISink setWriteBatchSize(Object writeBatchSize)

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

Overrides:

SqlMISink.setWriteBatchSize(Object writeBatchSize)

Parameters:

writeBatchSize

setWriteBatchTimeout

public SqlMISink setWriteBatchTimeout(Object writeBatchTimeout)

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

Overrides:

SqlMISink.setWriteBatchTimeout(Object writeBatchTimeout)

Parameters:

writeBatchTimeout

toJson

public JsonWriter toJson(JsonWriter jsonWriter)

Overrides:

SqlMISink.toJson(JsonWriter jsonWriter)

Parameters:

jsonWriter

Throws:

Applies to