Package version:

Interface AzureSqlReferenceInputDataSource

Describes an Azure SQL database reference input data source.

interface AzureSqlReferenceInputDataSource {
    authenticationMode?: string;
    database?: string;
    deltaSnapshotQuery?: string;
    fullSnapshotQuery?: string;
    password?: string;
    refreshRate?: string;
    refreshType?: string;
    server?: string;
    type: "Microsoft.Sql/Server/Database";
    user?: string;
}

Hierarchy (view full)

Properties

authenticationMode? database? deltaSnapshotQuery? fullSnapshotQuery? password? refreshRate? refreshType? server? type user?

Properties

Optional authenticationMode

authenticationMode?: string

Authentication Mode.

Optional database

database?: string

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

Optional deltaSnapshotQuery

deltaSnapshotQuery?: string

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.

Optional fullSnapshotQuery

fullSnapshotQuery?: string

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

Optional password

password?: string

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

Optional refreshRate

refreshRate?: string

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.

Optional refreshType

refreshType?: string

Indicates the type of data refresh option.

Optional server

server?: string

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

type

type: "Microsoft.Sql/Server/Database"

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

Optional user

user?: string

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

Settings

Member Visibility

Theme

Generated using TypeDoc