Share via


IAzureSqlReferenceInputDataSource Interface

Definition

[System.ComponentModel.TypeConverter(typeof(Microsoft.Azure.PowerShell.Cmdlets.StreamAnalytics.Models.Api20170401Preview.AzureSqlReferenceInputDataSourceTypeConverter))]
public interface IAzureSqlReferenceInputDataSource : Microsoft.Azure.PowerShell.Cmdlets.StreamAnalytics.Models.Api20170401Preview.IReferenceInputDataSource
[<System.ComponentModel.TypeConverter(typeof(Microsoft.Azure.PowerShell.Cmdlets.StreamAnalytics.Models.Api20170401Preview.AzureSqlReferenceInputDataSourceTypeConverter))>]
type IAzureSqlReferenceInputDataSource = interface
    interface IJsonSerializable
    interface IReferenceInputDataSource
Public Interface IAzureSqlReferenceInputDataSource
Implements IReferenceInputDataSource
Derived
Attributes
Implements

Properties

Database

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

DeltaSnapshotQuery

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

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

Password

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

RefreshRate

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

This element is associated with the datasource element. This element is of enum type. It indicates what kind of data refresh option do we want to use:Static/RefreshPeriodicallyWithFull/RefreshPeriodicallyWithDelta

Server

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

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

Type

Indicates the type of input data source containing reference data. Required on PUT (CreateOrReplace) requests.

(Inherited from IReferenceInputDataSource)
User

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

Methods

ToJson(JsonObject, SerializationMode) (Inherited from IJsonSerializable)

Applies to