Options
All
  • Public
  • Public/Protected
  • All
Menu

Interface AzureSqlSource

Package version

A copy activity Azure SQL source.

Hierarchy

Indexable

[property: string]: any

Describes unknown properties. The value of an unknown property can be of "any" type.

Index

Properties

Optional additionalColumns

additionalColumns: any

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

Optional maxConcurrentConnections

maxConcurrentConnections: any

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

Optional partitionOption

partitionOption: any

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

Optional partitionSettings

partitionSettings: SqlPartitionSettings

The settings that will be leveraged for Sql source partitioning.

Optional produceAdditionalTypes

produceAdditionalTypes: any

Which additional types to produce.

Optional queryTimeout

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

Optional sourceRetryCount

sourceRetryCount: any

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

Optional sourceRetryWait

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

Optional sqlReaderQuery

sqlReaderQuery: any

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

Optional sqlReaderStoredProcedureName

sqlReaderStoredProcedureName: any

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

Optional storedProcedureParameters

storedProcedureParameters: undefined | {}

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

type

type: "AzureSqlSource"

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

Generated using TypeDoc