AzureSqlReferenceInputDataSource Class

Definition

Namespace:

Microsoft.Azure.Management.StreamAnalytics.Models

Assembly:

Microsoft.Azure.Management.StreamAnalytics.dll

Package:

Microsoft.Azure.Management.StreamAnalytics v4.0.0

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

Object

ReferenceInputDataSource

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.