SqlReferenceInputDataSource Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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
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. |