Share via


IAzureSqlReferenceInputDataSourceProperties Interface

Definition

[System.ComponentModel.TypeConverter(typeof(Microsoft.Azure.PowerShell.Cmdlets.StreamAnalytics.Models.Api20170401Preview.AzureSqlReferenceInputDataSourcePropertiesTypeConverter))]
public interface IAzureSqlReferenceInputDataSourceProperties : Microsoft.Azure.PowerShell.Cmdlets.StreamAnalytics.Runtime.IJsonSerializable
[<System.ComponentModel.TypeConverter(typeof(Microsoft.Azure.PowerShell.Cmdlets.StreamAnalytics.Models.Api20170401Preview.AzureSqlReferenceInputDataSourcePropertiesTypeConverter))>]
type IAzureSqlReferenceInputDataSourceProperties = interface
    interface IJsonSerializable
Public Interface IAzureSqlReferenceInputDataSourceProperties
Implements IJsonSerializable
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..

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