Share via

AzureSqlReferenceInputDataSource interface

  • Reference
Package:
@azure/arm-streamanalytics

Describes an Azure SQL database reference input data source.

Extends
ReferenceInputDataSource

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

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.
table

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

Polymorphic discriminator, which specifies the different types this object can be
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.

Property Details

database

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

database?: string

Property Value

string

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.

deltaSnapshotQuery?: string

Property Value

string

fullSnapshotQuery

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

fullSnapshotQuery?: string

Property Value

string

password

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

password?: string

Property Value

string

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.

refreshRate?: string

Property Value

string

refreshType

Indicates the type of data refresh option.

refreshType?: string

Property Value

string

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.

server?: string

Property Value

string

table

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

table?: string

Property Value

string

type

Polymorphic discriminator, which specifies the different types this object can be

type: "Microsoft.Sql/Server/Database"

Property Value

"Microsoft.Sql/Server/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.

user?: string

Property Value

string