共用方式為


AzureSqlReferenceInputDataSource Class

Definition

Describes an Azure SQL database reference input data source.

[Microsoft.Rest.Serialization.JsonTransformation]
[Newtonsoft.Json.JsonObject("Microsoft.Sql/Server/Database")]
public class AzureSqlReferenceInputDataSource : Microsoft.Azure.Management.StreamAnalytics.Models.ReferenceInputDataSource
[<Microsoft.Rest.Serialization.JsonTransformation>]
[<Newtonsoft.Json.JsonObject("Microsoft.Sql/Server/Database")>]
type AzureSqlReferenceInputDataSource = class
    inherit ReferenceInputDataSource
Public Class AzureSqlReferenceInputDataSource
Inherits ReferenceInputDataSource
Inheritance
AzureSqlReferenceInputDataSource
Attributes
JsonTransformationAttribute Newtonsoft.Json.JsonObjectAttribute

Constructors

AzureSqlReferenceInputDataSource()

Initializes a new instance of the AzureSqlReferenceInputDataSource class.

AzureSqlReferenceInputDataSource(String, String, String, String, String, String, String, String, String)

Initializes a new instance of the AzureSqlReferenceInputDataSource class.

Properties

Database

Gets or sets this element is associated with the datasource element. This is the name of the database that output will be written to.

DeltaSnapshotQuery

Gets or sets this element is associated with the datasource element. This query is used to fetch incremental changes from the SQL database. To use this option, we recommend using temporal tables in Azure SQL Database.

FullSnapshotQuery

Gets or sets this element is associated with the datasource element. This query is used to fetch data from the sql database.

Password

Gets or sets this element is associated with the datasource element. This is the password that will be used to connect to the SQL Database instance.

RefreshRate

Gets or sets this element is associated with the datasource element. This indicates how frequently the data will be fetched from the database. It is of DateTime format.

RefreshType

Gets or sets indicates the type of data refresh option. Possible values include: 'Static', 'RefreshPeriodicallyWithFull', 'RefreshPeriodicallyWithDelta'

Server

Gets or sets this element is associated with the datasource element. This is the name of the server that contains the database that will be written to.

Table

Gets or sets this element is associated with the datasource element. The name of the table in the Azure SQL database..

User

Gets or sets this element is associated with the datasource element. This is the user name that will be used to connect to the SQL Database instance.

Applies to