SqlMISource Class

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

public final class SqlMISource
extends TabularSource

A copy activity Azure SQL Managed Instance source.

Constructor Summary

Constructor Description
SqlMISource()

Creates an instance of SqlMISource class.

Method Summary

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

Reads an instance of SqlMISource from the JsonReader.
Object getIsolationLevel()

Get the isolationLevel property: Specifies the transaction locking behavior for the SQL source.
Object getPartitionOption()

Get the partitionOption property: The partition mechanism that will be used for Sql read in parallel.
SqlPartitionSettings getPartitionSettings()

Get the partitionSettings property: The settings that will be leveraged for Sql source partitioning.
Object getProduceAdditionalTypes()

Get the produceAdditionalTypes property: Which additional types to produce.
Object getSqlReaderQuery()

Get the sqlReaderQuery property: SQL reader query.
Object getSqlReaderStoredProcedureName()

Get the sqlReaderStoredProcedureName property: Name of the stored procedure for a Azure SQL Managed Instance source.
Object getStoredProcedureParameters()

Get the storedProcedureParameters property: Value and type setting for stored procedure parameters.
String getType()

Get the type property: Copy source type.
SqlMISource setAdditionalColumns(Object additionalColumns)

Set the additionalColumns property: Specifies the additional columns to be added to source data.
SqlMISource setIsolationLevel(Object isolationLevel)

Set the isolationLevel property: Specifies the transaction locking behavior for the SQL source.
SqlMISource setMaxConcurrentConnections(Object maxConcurrentConnections)

Set the maxConcurrentConnections property: The maximum concurrent connection count for the source data store.
SqlMISource setPartitionOption(Object partitionOption)

Set the partitionOption property: The partition mechanism that will be used for Sql read in parallel.
SqlMISource setPartitionSettings(SqlPartitionSettings partitionSettings)

Set the partitionSettings property: The settings that will be leveraged for Sql source partitioning.
SqlMISource setProduceAdditionalTypes(Object produceAdditionalTypes)

Set the produceAdditionalTypes property: Which additional types to produce.
SqlMISource setQueryTimeout(Object queryTimeout)

Set the queryTimeout property: Query timeout.
SqlMISource setSourceRetryCount(Object sourceRetryCount)

Set the sourceRetryCount property: Source retry count.
SqlMISource setSourceRetryWait(Object sourceRetryWait)

Set the sourceRetryWait property: Source retry wait.
SqlMISource setSqlReaderQuery(Object sqlReaderQuery)

Set the sqlReaderQuery property: SQL reader query.
SqlMISource setSqlReaderStoredProcedureName(Object sqlReaderStoredProcedureName)

Set the sqlReaderStoredProcedureName property: Name of the stored procedure for a Azure SQL Managed Instance source.
SqlMISource setStoredProcedureParameters(Object storedProcedureParameters)

Set the storedProcedureParameters property: Value and type setting for stored procedure parameters.
JsonWriter toJson(JsonWriter jsonWriter)

Methods inherited from CopySource

getAdditionalProperties getMaxConcurrentConnections getSourceRetryCount getSourceRetryWait setAdditionalProperties

Methods inherited from TabularSource

fromJson getAdditionalColumns getQueryTimeout getType setAdditionalColumns setMaxConcurrentConnections setQueryTimeout setSourceRetryCount setSourceRetryWait toJson

Methods inherited from java.lang.Object

clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Constructor Details

SqlMISource

public SqlMISource()

Creates an instance of SqlMISource class.

Method Details

fromJson

public static SqlMISource fromJson(JsonReader jsonReader)

Reads an instance of SqlMISource from the JsonReader.

Parameters:

jsonReader - The JsonReader being read.

Returns:

An instance of SqlMISource 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 SqlMISource.

getIsolationLevel

public Object getIsolationLevel()

Get the isolationLevel property: 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).

Returns:

the isolationLevel value.

getPartitionOption

public Object getPartitionOption()

Get the partitionOption property: The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange".

Returns:

the partitionOption value.

getPartitionSettings

public SqlPartitionSettings getPartitionSettings()

Get the partitionSettings property: The settings that will be leveraged for Sql source partitioning.

Returns:

the partitionSettings value.

getProduceAdditionalTypes

public Object getProduceAdditionalTypes()

Get the produceAdditionalTypes property: Which additional types to produce.

Returns:

the produceAdditionalTypes value.

getSqlReaderQuery

public Object getSqlReaderQuery()

Get the sqlReaderQuery property: SQL reader query. Type: string (or Expression with resultType string).

Returns:

the sqlReaderQuery value.

getSqlReaderStoredProcedureName

public Object getSqlReaderStoredProcedureName()

Get the sqlReaderStoredProcedureName property: Name of the stored procedure for a Azure SQL Managed Instance source. This cannot be used at the same time as SqlReaderQuery. Type: string (or Expression with resultType string).

Returns:

the sqlReaderStoredProcedureName value.

getStoredProcedureParameters

public Object getStoredProcedureParameters()

Get the storedProcedureParameters property: Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".

Returns:

the storedProcedureParameters value.

getType

public String getType()

Get the type property: Copy source type.

Overrides:

SqlMISource.getType()

Returns:

the type value.

setAdditionalColumns

public SqlMISource setAdditionalColumns(Object additionalColumns)

Set the additionalColumns property: Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).

Overrides:

SqlMISource.setAdditionalColumns(Object additionalColumns)

Parameters:

additionalColumns

setIsolationLevel

public SqlMISource setIsolationLevel(Object isolationLevel)

Set the isolationLevel property: 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).

Parameters:

isolationLevel - the isolationLevel value to set.

Returns:

the SqlMISource object itself.

setMaxConcurrentConnections

public SqlMISource setMaxConcurrentConnections(Object maxConcurrentConnections)

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

Overrides:

SqlMISource.setMaxConcurrentConnections(Object maxConcurrentConnections)

Parameters:

maxConcurrentConnections

setPartitionOption

public SqlMISource setPartitionOption(Object partitionOption)

Set the partitionOption property: The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange".

Parameters:

partitionOption - the partitionOption value to set.

Returns:

the SqlMISource object itself.

setPartitionSettings

public SqlMISource setPartitionSettings(SqlPartitionSettings partitionSettings)

Set the partitionSettings property: The settings that will be leveraged for Sql source partitioning.

Parameters:

partitionSettings - the partitionSettings value to set.

Returns:

the SqlMISource object itself.

setProduceAdditionalTypes

public SqlMISource setProduceAdditionalTypes(Object produceAdditionalTypes)

Set the produceAdditionalTypes property: Which additional types to produce.

Parameters:

produceAdditionalTypes - the produceAdditionalTypes value to set.

Returns:

the SqlMISource object itself.

setQueryTimeout

public SqlMISource setQueryTimeout(Object queryTimeout)

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

Overrides:

SqlMISource.setQueryTimeout(Object queryTimeout)

Parameters:

queryTimeout

setSourceRetryCount

public SqlMISource setSourceRetryCount(Object sourceRetryCount)

Set the sourceRetryCount property: Source retry count. Type: integer (or Expression with resultType integer).

Overrides:

SqlMISource.setSourceRetryCount(Object sourceRetryCount)

Parameters:

sourceRetryCount

setSourceRetryWait

public SqlMISource setSourceRetryWait(Object sourceRetryWait)

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

Overrides:

SqlMISource.setSourceRetryWait(Object sourceRetryWait)

Parameters:

sourceRetryWait

setSqlReaderQuery

public SqlMISource setSqlReaderQuery(Object sqlReaderQuery)

Set the sqlReaderQuery property: SQL reader query. Type: string (or Expression with resultType string).

Parameters:

sqlReaderQuery - the sqlReaderQuery value to set.

Returns:

the SqlMISource object itself.

setSqlReaderStoredProcedureName

public SqlMISource setSqlReaderStoredProcedureName(Object sqlReaderStoredProcedureName)

Set the sqlReaderStoredProcedureName property: Name of the stored procedure for a Azure SQL Managed Instance source. This cannot be used at the same time as SqlReaderQuery. Type: string (or Expression with resultType string).

Parameters:

sqlReaderStoredProcedureName - the sqlReaderStoredProcedureName value to set.

Returns:

the SqlMISource object itself.

setStoredProcedureParameters

public SqlMISource setStoredProcedureParameters(Object storedProcedureParameters)

Set the storedProcedureParameters property: Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".

Parameters:

storedProcedureParameters - the storedProcedureParameters value to set.

Returns:

the SqlMISource object itself.

toJson

public JsonWriter toJson(JsonWriter jsonWriter)

Overrides:

SqlMISource.toJson(JsonWriter jsonWriter)

Parameters:

jsonWriter

Throws:

Applies to