SqlDWSource Class

Reference

Definition

Namespace:: Azure.ResourceManager.DataFactory.Models

Assembly:: Azure.ResourceManager.DataFactory.dll

Package:: Azure.ResourceManager.DataFactory v1.6.0

Package:: Azure.ResourceManager.DataFactory v1.0.0-beta.6

Source:: SqlDWSource.cs

Source:: SqlDWSource.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

A copy activity SQL Data Warehouse source.

public class SqlDWSource : Azure.ResourceManager.DataFactory.Models.TabularSource, System.ClientModel.Primitives.IJsonModel<Azure.ResourceManager.DataFactory.Models.SqlDWSource>, System.ClientModel.Primitives.IPersistableModel<Azure.ResourceManager.DataFactory.Models.SqlDWSource>

public class SqlDWSource : Azure.ResourceManager.DataFactory.Models.TabularSource

type SqlDWSource = class
    inherit TabularSource
    interface IJsonModel<SqlDWSource>
    interface IPersistableModel<SqlDWSource>

type SqlDWSource = class
    inherit TabularSource

Public Class SqlDWSource
Inherits TabularSource
Implements IJsonModel(Of SqlDWSource), IPersistableModel(Of SqlDWSource)

Public Class SqlDWSource
Inherits TabularSource

Inheritance: Object

CopyActivitySource

TabularSource
SqlDWSource

Implements: IJsonModel<SqlDWSource> IPersistableModel<SqlDWSource> IPersistableModel<T>

Constructors

SqlDWSource()

Initializes a new instance of SqlDWSource.

Properties

AdditionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects). To assign an object to this property use FromObjectAsJson<T>(T, JsonSerializerOptions). To assign an already formatted json string to this property use FromString(String). Examples: BinaryData.FromObjectAsJson("foo"): Creates a payload of "foo". BinaryData.FromString("\"foo\""): Creates a payload of "foo". BinaryData.FromObjectAsJson(new { key = "value" }): Creates a payload of { "key": "value" }. BinaryData.FromString("{\"key\": \"value\"}"): Creates a payload of { "key": "value" }. (Inherited from TabularSource)
AdditionalProperties	Additional Properties To assign an object to the value of this property use FromObjectAsJson<T>(T, JsonSerializerOptions). To assign an already formatted json string to this property use FromString(String). Examples: BinaryData.FromObjectAsJson("foo"): Creates a payload of "foo". BinaryData.FromString("\"foo\""): Creates a payload of "foo". BinaryData.FromObjectAsJson(new { key = "value" }): Creates a payload of { "key": "value" }. BinaryData.FromString("{\"key\": \"value\"}"): Creates a payload of { "key": "value" }. (Inherited from CopyActivitySource)
DisableMetricsCollection	If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean). (Inherited from CopyActivitySource)
IsolationLevel	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).
MaxConcurrentConnections	The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer). (Inherited from CopyActivitySource)
PartitionOption	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).
PartitionSettings	The settings that will be leveraged for Sql source partitioning.
QueryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60\|([0-5][0-9])):(60\|([0-5][0-9])). (Inherited from TabularSource)
SourceRetryCount	Source retry count. Type: integer (or Expression with resultType integer). (Inherited from CopyActivitySource)
SourceRetryWait	Source retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60\|([0-5][0-9])):(60\|([0-5][0-9])). (Inherited from CopyActivitySource)
SqlReaderQuery	SQL Data Warehouse reader query. Type: string (or Expression with resultType string).
SqlReaderStoredProcedureName	Name of the stored procedure for a SQL Data Warehouse source. This cannot be used at the same time as SqlReaderQuery. Type: string (or Expression with resultType string).
StoredProcedureParameters	Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}". Type: object (or Expression with resultType object), itemType: StoredProcedureParameter. To assign an object to this property use FromObjectAsJson<T>(T, JsonSerializerOptions). To assign an already formatted json string to this property use FromString(String). Examples: BinaryData.FromObjectAsJson("foo"): Creates a payload of "foo". BinaryData.FromString("\"foo\""): Creates a payload of "foo". BinaryData.FromObjectAsJson(new { key = "value" }): Creates a payload of { "key": "value" }. BinaryData.FromString("{\"key\": \"value\"}"): Creates a payload of { "key": "value" }.

Methods

JsonModelWriteCore(Utf8JsonWriter, ModelReaderWriterOptions)
JsonModelWriteCore(Utf8JsonWriter, ModelReaderWriterOptions)	(Inherited from TabularSource)

Explicit Interface Implementations

IJsonModel<CopyActivitySource>.Create(Utf8JsonReader, ModelReaderWriterOptions)	Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model. (Inherited from CopyActivitySource)
IJsonModel<CopyActivitySource>.Write(Utf8JsonWriter, ModelReaderWriterOptions)	Writes the model to the provided Utf8JsonWriter. (Inherited from CopyActivitySource)
IJsonModel<SqlDWSource>.Create(Utf8JsonReader, ModelReaderWriterOptions)	Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model.
IJsonModel<SqlDWSource>.Write(Utf8JsonWriter, ModelReaderWriterOptions)	Writes the model to the provided Utf8JsonWriter.
IJsonModel<TabularSource>.Create(Utf8JsonReader, ModelReaderWriterOptions)	Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model. (Inherited from TabularSource)
IJsonModel<TabularSource>.Write(Utf8JsonWriter, ModelReaderWriterOptions)	Writes the model to the provided Utf8JsonWriter. (Inherited from TabularSource)
IPersistableModel<CopyActivitySource>.Create(BinaryData, ModelReaderWriterOptions)	Converts the provided BinaryData into a model. (Inherited from CopyActivitySource)
IPersistableModel<CopyActivitySource>.GetFormatFromOptions(ModelReaderWriterOptions)	Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service. (Inherited from CopyActivitySource)
IPersistableModel<CopyActivitySource>.Write(ModelReaderWriterOptions)	Writes the model into a BinaryData. (Inherited from CopyActivitySource)
IPersistableModel<SqlDWSource>.Create(BinaryData, ModelReaderWriterOptions)	Converts the provided BinaryData into a model.
IPersistableModel<SqlDWSource>.GetFormatFromOptions(ModelReaderWriterOptions)	Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service.
IPersistableModel<SqlDWSource>.Write(ModelReaderWriterOptions)	Writes the model into a BinaryData.
IPersistableModel<TabularSource>.Create(BinaryData, ModelReaderWriterOptions)	Converts the provided BinaryData into a model. (Inherited from TabularSource)
IPersistableModel<TabularSource>.GetFormatFromOptions(ModelReaderWriterOptions)	Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service. (Inherited from TabularSource)
IPersistableModel<TabularSource>.Write(ModelReaderWriterOptions)	Writes the model into a BinaryData. (Inherited from TabularSource)

Applies to

Partager via