WarehouseSink interface
A copy activity Microsoft Fabric Warehouse sink.
- Extends
Properties
allow |
Indicates to use Copy Command to copy data into SQL Data Warehouse. Type: boolean (or Expression with resultType boolean). |
copy |
Specifies Copy Command related settings when allowCopyCommand is true. |
pre |
SQL pre-copy script. Type: string (or Expression with resultType string). |
table |
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 |
write |
Write behavior when copying data into azure Microsoft Fabric Data Warehouse. Type: DWWriteBehaviorEnum (or Expression with resultType DWWriteBehaviorEnum) |
Inherited Properties
disable |
If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean). |
max |
The maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer). |
sink |
Sink retry count. Type: integer (or Expression with resultType integer). |
sink |
Sink retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])). |
write |
Write batch size. Type: integer (or Expression with resultType integer), minimum: 0. |
write |
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
allowCopyCommand
Indicates to use Copy Command to copy data into SQL Data Warehouse. Type: boolean (or Expression with resultType boolean).
allowCopyCommand?: any
Property Value
any
copyCommandSettings
Specifies Copy Command related settings when allowCopyCommand is true.
copyCommandSettings?: DWCopyCommandSettings
Property Value
preCopyScript
SQL pre-copy script. Type: string (or Expression with resultType string).
preCopyScript?: 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: "WarehouseSink"
Property Value
"WarehouseSink"
writeBehavior
Write behavior when copying data into azure Microsoft Fabric Data Warehouse. Type: DWWriteBehaviorEnum (or Expression with resultType DWWriteBehaviorEnum)
writeBehavior?: any
Property Value
any
Inherited Property Details
disableMetricsCollection
If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).
disableMetricsCollection?: any
Property Value
any
Inherited From CopySink.disableMetricsCollection
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