AzureSqlReferenceInputDataSource Constructors

Definition

Namespace:

Microsoft.Azure.Management.StreamAnalytics.Models

Assembly:

Microsoft.Azure.Management.StreamAnalytics.dll

Package:

Microsoft.Azure.Management.StreamAnalytics v4.0.0

Overloads

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.

AzureSqlReferenceInputDataSource()

Initializes a new instance of the AzureSqlReferenceInputDataSource class.

public AzureSqlReferenceInputDataSource ();

Public Sub New ()

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

Initializes a new instance of the AzureSqlReferenceInputDataSource class.

public AzureSqlReferenceInputDataSource (string server = default, string database = default, string user = default, string password = default, string table = default, string refreshType = default, string refreshRate = default, string fullSnapshotQuery = default, string deltaSnapshotQuery = default);

new Microsoft.Azure.Management.StreamAnalytics.Models.AzureSqlReferenceInputDataSource : string * string * string * string * string * string * string * string * string -> Microsoft.Azure.Management.StreamAnalytics.Models.AzureSqlReferenceInputDataSource

Public Sub New (Optional server As String = Nothing, Optional database As String = Nothing, Optional user As String = Nothing, Optional password As String = Nothing, Optional table As String = Nothing, Optional refreshType As String = Nothing, Optional refreshRate As String = Nothing, Optional fullSnapshotQuery As String = Nothing, Optional deltaSnapshotQuery As String = Nothing)

Parameters

server

String

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

database

String

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

user

String

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

password

String

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

table

String

This element is associated with the datasource element. The name of the table in the Azure SQL database..

refreshType

String

Indicates the type of data refresh option. Possible values include: 'Static', 'RefreshPeriodicallyWithFull', 'RefreshPeriodicallyWithDelta'

refreshRate

String

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.

fullSnapshotQuery

String

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

deltaSnapshotQuery

String

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.