Package version:

Interface SqlMISource

A copy activity Azure SQL Managed Instance source.

interface SqlMISource {
    additionalColumns?: any;
    disableMetricsCollection?: any;
    isolationLevel?: any;
    maxConcurrentConnections?: any;
    partitionOption?: any;
    partitionSettings?: SqlPartitionSettings;
    produceAdditionalTypes?: any;
    queryTimeout?: any;
    sourceRetryCount?: any;
    sourceRetryWait?: any;
    sqlReaderQuery?: any;
    sqlReaderStoredProcedureName?: any;
    storedProcedureParameters?: any;
    type: "SqlMISource";
}

Hierarchy (view full)

Properties

additionalColumns? disableMetricsCollection? isolationLevel? maxConcurrentConnections? partitionOption? partitionSettings? produceAdditionalTypes? queryTimeout? sourceRetryCount? sourceRetryWait? sqlReaderQuery? sqlReaderStoredProcedureName? storedProcedureParameters? type

Properties

OptionaladditionalColumns

additionalColumns?: any

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

OptionaldisableMetricsCollection

disableMetricsCollection?: any

If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).

OptionalisolationLevel

isolationLevel?: any

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

OptionalmaxConcurrentConnections

maxConcurrentConnections?: any

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

OptionalpartitionOption

partitionOption?: any

The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange". Type: string (or Expression with resultType string).

OptionalpartitionSettings

partitionSettings?: SqlPartitionSettings

The settings that will be leveraged for Sql source partitioning.

OptionalproduceAdditionalTypes

produceAdditionalTypes?: any

Which additional types to produce.

OptionalqueryTimeout

queryTimeout?: any

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

OptionalsourceRetryCount

sourceRetryCount?: any

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

OptionalsourceRetryWait

sourceRetryWait?: any

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

OptionalsqlReaderQuery

sqlReaderQuery?: any

SQL reader query. Type: string (or Expression with resultType string).

OptionalsqlReaderStoredProcedureName

sqlReaderStoredProcedureName?: any

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

OptionalstoredProcedureParameters

storedProcedureParameters?: any

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

type

type

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

Settings

Member Visibility