pulumi-azure-native-kotlin/com.pulumi.azurenative.streamanalytics.kotlin.outputs/AzureSqlReferenceInputDataSourceResponse

AzureSqlReferenceInputDataSourceResponse

data class AzureSqlReferenceInputDataSourceResponse(val database: String? = null, val deltaSnapshotQuery: String? = null, val fullSnapshotQuery: String? = null, val password: String? = null, val refreshRate: String? = null, val refreshType: String? = null, val server: String? = null, val table: String? = null, val type: String, val user: String? = null)

Describes an Azure SQL database reference input data source.

Constructors

Link copied to clipboard
constructor(database: String? = null, deltaSnapshotQuery: String? = null, fullSnapshotQuery: String? = null, password: String? = null, refreshRate: String? = null, refreshType: String? = null, server: String? = null, table: String? = null, type: String, user: String? = null)

Types

Link copied to clipboard
object Companion

Properties

Link copied to clipboard
val database: String? = null

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

Link copied to clipboard
val deltaSnapshotQuery: String? = null

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.

Link copied to clipboard
val fullSnapshotQuery: String? = null

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

Link copied to clipboard
val password: String? = null

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

Link copied to clipboard
val refreshRate: String? = null

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.

Link copied to clipboard
val refreshType: String? = null

Indicates the type of data refresh option.

Link copied to clipboard
val server: String? = null

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

Link copied to clipboard
val table: String? = null

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

Link copied to clipboard
val type: String

Indicates the type of input data source containing reference data. Required on PUT (CreateOrReplace) requests. Expected value is 'Microsoft.Sql/Server/Database'.

Link copied to clipboard
val user: String? = null

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