SqlReferenceInputDataSource Class

Definition

Describes an Azure SQL database reference input data source.

public class SqlReferenceInputDataSource : Azure.ResourceManager.StreamAnalytics.Models.ReferenceInputDataSource
type SqlReferenceInputDataSource = class
    inherit ReferenceInputDataSource
Public Class SqlReferenceInputDataSource
Inherits ReferenceInputDataSource
Inheritance
SqlReferenceInputDataSource

Constructors

SqlReferenceInputDataSource()

Initializes a new instance of SqlReferenceInputDataSource.

Properties

AuthenticationMode

Authentication Mode.

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.

RefreshInterval

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

Indicates the type of data refresh option.

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.

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.

Applies to