com.pulumi.azure.streamanalytics.kotlin.ReferenceInputMssqlArgs.kt Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of pulumi-azure-kotlin Show documentation
Show all versions of pulumi-azure-kotlin Show documentation
Build cloud applications and infrastructure by combining the safety and reliability of infrastructure as code with the power of the Kotlin programming language.
@file:Suppress("NAME_SHADOWING", "DEPRECATION")
package com.pulumi.azure.streamanalytics.kotlin
import com.pulumi.azure.streamanalytics.ReferenceInputMssqlArgs.builder
import com.pulumi.core.Output
import com.pulumi.core.Output.of
import com.pulumi.kotlin.ConvertibleToJava
import com.pulumi.kotlin.PulumiTagMarker
import kotlin.String
import kotlin.Suppress
import kotlin.jvm.JvmName
/**
* Manages a Stream Analytics Reference Input from MS SQL. Reference data (also known as a lookup table) is a finite data set that is static or slowly changing in nature, used to perform a lookup or to correlate with your data stream. Learn more [here](https://docs.microsoft.com/azure/stream-analytics/stream-analytics-use-reference-data#azure-sql-database).
* ## Example Usage
*
* ```typescript
* import * as pulumi from "@pulumi/pulumi";
* import * as azure from "@pulumi/azure";
* const exampleResourceGroup = new azure.core.ResourceGroup("example", {
* name: "example-resources",
* location: "West Europe",
* });
* const example = azure.streamanalytics.getJobOutput({
* name: "example-job",
* resourceGroupName: exampleResourceGroup.name,
* });
* const exampleServer = new azure.mssql.Server("example", {
* name: "example-sqlserver",
* resourceGroupName: exampleResourceGroup.name,
* location: exampleResourceGroup.location,
* version: "12.0",
* administratorLogin: "admin",
* administratorLoginPassword: "password",
* });
* const exampleDatabase = new azure.mssql.Database("example", {
* name: "example-db",
* serverId: exampleServer.id,
* });
* const exampleReferenceInputMssql = new azure.streamanalytics.ReferenceInputMssql("example", {
* name: "example-reference-input",
* resourceGroupName: example.apply(example => example.resourceGroupName),
* streamAnalyticsJobName: example.apply(example => example.name),
* server: exampleServer.fullyQualifiedDomainName,
* database: exampleDatabase.name,
* username: "exampleuser",
* password: "examplepassword",
* refreshType: "RefreshPeriodicallyWithFull",
* refreshIntervalDuration: "00:20:00",
* fullSnapshotQuery: ` SELECT *
* INTO [YourOutputAlias]
* FROM [YourInputAlias]
* `,
* });
* ```
* ```python
* import pulumi
* import pulumi_azure as azure
* example_resource_group = azure.core.ResourceGroup("example",
* name="example-resources",
* location="West Europe")
* example = azure.streamanalytics.get_job_output(name="example-job",
* resource_group_name=example_resource_group.name)
* example_server = azure.mssql.Server("example",
* name="example-sqlserver",
* resource_group_name=example_resource_group.name,
* location=example_resource_group.location,
* version="12.0",
* administrator_login="admin",
* administrator_login_password="password")
* example_database = azure.mssql.Database("example",
* name="example-db",
* server_id=example_server.id)
* example_reference_input_mssql = azure.streamanalytics.ReferenceInputMssql("example",
* name="example-reference-input",
* resource_group_name=example.resource_group_name,
* stream_analytics_job_name=example.name,
* server=example_server.fully_qualified_domain_name,
* database=example_database.name,
* username="exampleuser",
* password="examplepassword",
* refresh_type="RefreshPeriodicallyWithFull",
* refresh_interval_duration="00:20:00",
* full_snapshot_query=""" SELECT *
* INTO [YourOutputAlias]
* FROM [YourInputAlias]
* """)
* ```
* ```csharp
* using System.Collections.Generic;
* using System.Linq;
* using Pulumi;
* using Azure = Pulumi.Azure;
* return await Deployment.RunAsync(() =>
* {
* var exampleResourceGroup = new Azure.Core.ResourceGroup("example", new()
* {
* Name = "example-resources",
* Location = "West Europe",
* });
* var example = Azure.StreamAnalytics.GetJob.Invoke(new()
* {
* Name = "example-job",
* ResourceGroupName = exampleResourceGroup.Name,
* });
* var exampleServer = new Azure.MSSql.Server("example", new()
* {
* Name = "example-sqlserver",
* ResourceGroupName = exampleResourceGroup.Name,
* Location = exampleResourceGroup.Location,
* Version = "12.0",
* AdministratorLogin = "admin",
* AdministratorLoginPassword = "password",
* });
* var exampleDatabase = new Azure.MSSql.Database("example", new()
* {
* Name = "example-db",
* ServerId = exampleServer.Id,
* });
* var exampleReferenceInputMssql = new Azure.StreamAnalytics.ReferenceInputMssql("example", new()
* {
* Name = "example-reference-input",
* ResourceGroupName = example.Apply(getJobResult => getJobResult.ResourceGroupName),
* StreamAnalyticsJobName = example.Apply(getJobResult => getJobResult.Name),
* Server = exampleServer.FullyQualifiedDomainName,
* Database = exampleDatabase.Name,
* Username = "exampleuser",
* Password = "examplepassword",
* RefreshType = "RefreshPeriodicallyWithFull",
* RefreshIntervalDuration = "00:20:00",
* FullSnapshotQuery = @" SELECT *
* INTO [YourOutputAlias]
* FROM [YourInputAlias]
* ",
* });
* });
* ```
* ```go
* package main
* import (
* "github.com/pulumi/pulumi-azure/sdk/v5/go/azure/core"
* "github.com/pulumi/pulumi-azure/sdk/v5/go/azure/mssql"
* "github.com/pulumi/pulumi-azure/sdk/v5/go/azure/streamanalytics"
* "github.com/pulumi/pulumi/sdk/v3/go/pulumi"
* )
* func main() {
* pulumi.Run(func(ctx *pulumi.Context) error {
* exampleResourceGroup, err := core.NewResourceGroup(ctx, "example", &core.ResourceGroupArgs{
* Name: pulumi.String("example-resources"),
* Location: pulumi.String("West Europe"),
* })
* if err != nil {
* return err
* }
* example := streamanalytics.LookupJobOutput(ctx, streamanalytics.GetJobOutputArgs{
* Name: pulumi.String("example-job"),
* ResourceGroupName: exampleResourceGroup.Name,
* }, nil)
* exampleServer, err := mssql.NewServer(ctx, "example", &mssql.ServerArgs{
* Name: pulumi.String("example-sqlserver"),
* ResourceGroupName: exampleResourceGroup.Name,
* Location: exampleResourceGroup.Location,
* Version: pulumi.String("12.0"),
* AdministratorLogin: pulumi.String("admin"),
* AdministratorLoginPassword: pulumi.String("password"),
* })
* if err != nil {
* return err
* }
* exampleDatabase, err := mssql.NewDatabase(ctx, "example", &mssql.DatabaseArgs{
* Name: pulumi.String("example-db"),
* ServerId: exampleServer.ID(),
* })
* if err != nil {
* return err
* }
* _, err = streamanalytics.NewReferenceInputMssql(ctx, "example", &streamanalytics.ReferenceInputMssqlArgs{
* Name: pulumi.String("example-reference-input"),
* ResourceGroupName: example.ApplyT(func(example streamanalytics.GetJobResult) (*string, error) {
* return &example.ResourceGroupName, nil
* }).(pulumi.StringPtrOutput),
* StreamAnalyticsJobName: example.ApplyT(func(example streamanalytics.GetJobResult) (*string, error) {
* return &example.Name, nil
* }).(pulumi.StringPtrOutput),
* Server: exampleServer.FullyQualifiedDomainName,
* Database: exampleDatabase.Name,
* Username: pulumi.String("exampleuser"),
* Password: pulumi.String("examplepassword"),
* RefreshType: pulumi.String("RefreshPeriodicallyWithFull"),
* RefreshIntervalDuration: pulumi.String("00:20:00"),
* FullSnapshotQuery: pulumi.String(" SELECT *\n INTO [YourOutputAlias]\n FROM [YourInputAlias]\n"),
* })
* if err != nil {
* return err
* }
* return nil
* })
* }
* ```
* ```java
* package generated_program;
* import com.pulumi.Context;
* import com.pulumi.Pulumi;
* import com.pulumi.core.Output;
* import com.pulumi.azure.core.ResourceGroup;
* import com.pulumi.azure.core.ResourceGroupArgs;
* import com.pulumi.azure.streamanalytics.StreamanalyticsFunctions;
* import com.pulumi.azure.streamanalytics.inputs.GetJobArgs;
* import com.pulumi.azure.mssql.Server;
* import com.pulumi.azure.mssql.ServerArgs;
* import com.pulumi.azure.mssql.Database;
* import com.pulumi.azure.mssql.DatabaseArgs;
* import com.pulumi.azure.streamanalytics.ReferenceInputMssql;
* import com.pulumi.azure.streamanalytics.ReferenceInputMssqlArgs;
* import java.util.List;
* import java.util.ArrayList;
* import java.util.Map;
* import java.io.File;
* import java.nio.file.Files;
* import java.nio.file.Paths;
* public class App {
* public static void main(String[] args) {
* Pulumi.run(App::stack);
* }
* public static void stack(Context ctx) {
* var exampleResourceGroup = new ResourceGroup("exampleResourceGroup", ResourceGroupArgs.builder()
* .name("example-resources")
* .location("West Europe")
* .build());
* final var example = StreamanalyticsFunctions.getJob(GetJobArgs.builder()
* .name("example-job")
* .resourceGroupName(exampleResourceGroup.name())
* .build());
* var exampleServer = new Server("exampleServer", ServerArgs.builder()
* .name("example-sqlserver")
* .resourceGroupName(exampleResourceGroup.name())
* .location(exampleResourceGroup.location())
* .version("12.0")
* .administratorLogin("admin")
* .administratorLoginPassword("password")
* .build());
* var exampleDatabase = new Database("exampleDatabase", DatabaseArgs.builder()
* .name("example-db")
* .serverId(exampleServer.id())
* .build());
* var exampleReferenceInputMssql = new ReferenceInputMssql("exampleReferenceInputMssql", ReferenceInputMssqlArgs.builder()
* .name("example-reference-input")
* .resourceGroupName(example.applyValue(getJobResult -> getJobResult).applyValue(example -> example.applyValue(getJobResult -> getJobResult.resourceGroupName())))
* .streamAnalyticsJobName(example.applyValue(getJobResult -> getJobResult).applyValue(example -> example.applyValue(getJobResult -> getJobResult.name())))
* .server(exampleServer.fullyQualifiedDomainName())
* .database(exampleDatabase.name())
* .username("exampleuser")
* .password("examplepassword")
* .refreshType("RefreshPeriodicallyWithFull")
* .refreshIntervalDuration("00:20:00")
* .fullSnapshotQuery("""
* SELECT *
* INTO [YourOutputAlias]
* FROM [YourInputAlias]
* """)
* .build());
* }
* }
* ```
* ```yaml
* resources:
* exampleResourceGroup:
* type: azure:core:ResourceGroup
* name: example
* properties:
* name: example-resources
* location: West Europe
* exampleServer:
* type: azure:mssql:Server
* name: example
* properties:
* name: example-sqlserver
* resourceGroupName: ${exampleResourceGroup.name}
* location: ${exampleResourceGroup.location}
* version: '12.0'
* administratorLogin: admin
* administratorLoginPassword: password
* exampleDatabase:
* type: azure:mssql:Database
* name: example
* properties:
* name: example-db
* serverId: ${exampleServer.id}
* exampleReferenceInputMssql:
* type: azure:streamanalytics:ReferenceInputMssql
* name: example
* properties:
* name: example-reference-input
* resourceGroupName: ${example.resourceGroupName}
* streamAnalyticsJobName: ${example.name}
* server: ${exampleServer.fullyQualifiedDomainName}
* database: ${exampleDatabase.name}
* username: exampleuser
* password: examplepassword
* refreshType: RefreshPeriodicallyWithFull
* refreshIntervalDuration: 00:20:00
* fullSnapshotQuery: |2
* SELECT *
* INTO [YourOutputAlias]
* FROM [YourInputAlias]
* variables:
* example:
* fn::invoke:
* Function: azure:streamanalytics:getJob
* Arguments:
* name: example-job
* resourceGroupName: ${exampleResourceGroup.name}
* ```
*
* ## Import
* Stream Analytics can be imported using the `resource id`, e.g.
* ```sh
* $ pulumi import azure:streamanalytics/referenceInputMssql:ReferenceInputMssql example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/group1/providers/Microsoft.StreamAnalytics/streamingJobs/job1/inputs/input1
* ```
* @property database The MS SQL database name where the reference data exists.
* @property deltaSnapshotQuery The query used to retrieve incremental changes in the reference data from the MS SQL database. Cannot be set when `refresh_type` is `Static`.
* @property fullSnapshotQuery The query used to retrieve the reference data from the MS SQL database.
* @property name The name of the Reference Input MS SQL data. Changing this forces a new resource to be created.
* @property password The password to connect to the MS SQL database.
* @property refreshIntervalDuration The frequency in `hh:mm:ss` with which the reference data should be retrieved from the MS SQL database e.g. `00:20:00` for every 20 minutes. Must be set when `refresh_type` is `RefreshPeriodicallyWithFull` or `RefreshPeriodicallyWithDelta`.
* @property refreshType Defines whether and how the reference data should be refreshed. Accepted values are `Static`, `RefreshPeriodicallyWithFull` and `RefreshPeriodicallyWithDelta`.
* @property resourceGroupName The name of the Resource Group where the Stream Analytics Job should exist. Changing this forces a new resource to be created.
* @property server The fully qualified domain name of the MS SQL server.
* @property streamAnalyticsJobName The name of the Stream Analytics Job. Changing this forces a new resource to be created.
* @property table The name of the table in the Azure SQL database.
* @property username The username to connect to the MS SQL database.
*/
public data class ReferenceInputMssqlArgs(
public val database: Output? = null,
public val deltaSnapshotQuery: Output? = null,
public val fullSnapshotQuery: Output? = null,
public val name: Output? = null,
public val password: Output? = null,
public val refreshIntervalDuration: Output? = null,
public val refreshType: Output? = null,
public val resourceGroupName: Output? = null,
public val server: Output? = null,
public val streamAnalyticsJobName: Output? = null,
public val table: Output? = null,
public val username: Output? = null,
) : ConvertibleToJava {
override fun toJava(): com.pulumi.azure.streamanalytics.ReferenceInputMssqlArgs =
com.pulumi.azure.streamanalytics.ReferenceInputMssqlArgs.builder()
.database(database?.applyValue({ args0 -> args0 }))
.deltaSnapshotQuery(deltaSnapshotQuery?.applyValue({ args0 -> args0 }))
.fullSnapshotQuery(fullSnapshotQuery?.applyValue({ args0 -> args0 }))
.name(name?.applyValue({ args0 -> args0 }))
.password(password?.applyValue({ args0 -> args0 }))
.refreshIntervalDuration(refreshIntervalDuration?.applyValue({ args0 -> args0 }))
.refreshType(refreshType?.applyValue({ args0 -> args0 }))
.resourceGroupName(resourceGroupName?.applyValue({ args0 -> args0 }))
.server(server?.applyValue({ args0 -> args0 }))
.streamAnalyticsJobName(streamAnalyticsJobName?.applyValue({ args0 -> args0 }))
.table(table?.applyValue({ args0 -> args0 }))
.username(username?.applyValue({ args0 -> args0 })).build()
}
/**
* Builder for [ReferenceInputMssqlArgs].
*/
@PulumiTagMarker
public class ReferenceInputMssqlArgsBuilder internal constructor() {
private var database: Output? = null
private var deltaSnapshotQuery: Output? = null
private var fullSnapshotQuery: Output? = null
private var name: Output? = null
private var password: Output? = null
private var refreshIntervalDuration: Output? = null
private var refreshType: Output? = null
private var resourceGroupName: Output? = null
private var server: Output? = null
private var streamAnalyticsJobName: Output? = null
private var table: Output? = null
private var username: Output? = null
/**
* @param value The MS SQL database name where the reference data exists.
*/
@JvmName("nxsbiiboyrsvdeqo")
public suspend fun database(`value`: Output) {
this.database = value
}
/**
* @param value The query used to retrieve incremental changes in the reference data from the MS SQL database. Cannot be set when `refresh_type` is `Static`.
*/
@JvmName("rfgahewfarvkabcf")
public suspend fun deltaSnapshotQuery(`value`: Output) {
this.deltaSnapshotQuery = value
}
/**
* @param value The query used to retrieve the reference data from the MS SQL database.
*/
@JvmName("flmedwdpbasnxsts")
public suspend fun fullSnapshotQuery(`value`: Output) {
this.fullSnapshotQuery = value
}
/**
* @param value The name of the Reference Input MS SQL data. Changing this forces a new resource to be created.
*/
@JvmName("rapqjlwcwvklkptq")
public suspend fun name(`value`: Output) {
this.name = value
}
/**
* @param value The password to connect to the MS SQL database.
*/
@JvmName("mtaueoykblltrmsm")
public suspend fun password(`value`: Output) {
this.password = value
}
/**
* @param value The frequency in `hh:mm:ss` with which the reference data should be retrieved from the MS SQL database e.g. `00:20:00` for every 20 minutes. Must be set when `refresh_type` is `RefreshPeriodicallyWithFull` or `RefreshPeriodicallyWithDelta`.
*/
@JvmName("pliwicbhqiamftje")
public suspend fun refreshIntervalDuration(`value`: Output) {
this.refreshIntervalDuration = value
}
/**
* @param value Defines whether and how the reference data should be refreshed. Accepted values are `Static`, `RefreshPeriodicallyWithFull` and `RefreshPeriodicallyWithDelta`.
*/
@JvmName("vghpfmxelvqbgkpi")
public suspend fun refreshType(`value`: Output) {
this.refreshType = value
}
/**
* @param value The name of the Resource Group where the Stream Analytics Job should exist. Changing this forces a new resource to be created.
*/
@JvmName("ajmvlagfvyovopax")
public suspend fun resourceGroupName(`value`: Output) {
this.resourceGroupName = value
}
/**
* @param value The fully qualified domain name of the MS SQL server.
*/
@JvmName("gcasrjdtxmkmhgeo")
public suspend fun server(`value`: Output) {
this.server = value
}
/**
* @param value The name of the Stream Analytics Job. Changing this forces a new resource to be created.
*/
@JvmName("kwiphjguefjfowpy")
public suspend fun streamAnalyticsJobName(`value`: Output) {
this.streamAnalyticsJobName = value
}
/**
* @param value The name of the table in the Azure SQL database.
*/
@JvmName("ixtguwpacjrsqakc")
public suspend fun table(`value`: Output) {
this.table = value
}
/**
* @param value The username to connect to the MS SQL database.
*/
@JvmName("buknhcdaqpcowego")
public suspend fun username(`value`: Output) {
this.username = value
}
/**
* @param value The MS SQL database name where the reference data exists.
*/
@JvmName("ttdieaexrppxhedx")
public suspend fun database(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.database = mapped
}
/**
* @param value The query used to retrieve incremental changes in the reference data from the MS SQL database. Cannot be set when `refresh_type` is `Static`.
*/
@JvmName("amijvyyydqscavat")
public suspend fun deltaSnapshotQuery(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.deltaSnapshotQuery = mapped
}
/**
* @param value The query used to retrieve the reference data from the MS SQL database.
*/
@JvmName("nxrwqkjqonttwlsg")
public suspend fun fullSnapshotQuery(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.fullSnapshotQuery = mapped
}
/**
* @param value The name of the Reference Input MS SQL data. Changing this forces a new resource to be created.
*/
@JvmName("bbqleconcofiirtx")
public suspend fun name(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.name = mapped
}
/**
* @param value The password to connect to the MS SQL database.
*/
@JvmName("lrrfhevnpqcmcpev")
public suspend fun password(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.password = mapped
}
/**
* @param value The frequency in `hh:mm:ss` with which the reference data should be retrieved from the MS SQL database e.g. `00:20:00` for every 20 minutes. Must be set when `refresh_type` is `RefreshPeriodicallyWithFull` or `RefreshPeriodicallyWithDelta`.
*/
@JvmName("oyuneyrpffbhaeep")
public suspend fun refreshIntervalDuration(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.refreshIntervalDuration = mapped
}
/**
* @param value Defines whether and how the reference data should be refreshed. Accepted values are `Static`, `RefreshPeriodicallyWithFull` and `RefreshPeriodicallyWithDelta`.
*/
@JvmName("yeisrfttmflqadtd")
public suspend fun refreshType(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.refreshType = mapped
}
/**
* @param value The name of the Resource Group where the Stream Analytics Job should exist. Changing this forces a new resource to be created.
*/
@JvmName("vauykceqwqkbhqum")
public suspend fun resourceGroupName(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.resourceGroupName = mapped
}
/**
* @param value The fully qualified domain name of the MS SQL server.
*/
@JvmName("yrrvtnnppacbxean")
public suspend fun server(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.server = mapped
}
/**
* @param value The name of the Stream Analytics Job. Changing this forces a new resource to be created.
*/
@JvmName("niahbmrtdsmybhyr")
public suspend fun streamAnalyticsJobName(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.streamAnalyticsJobName = mapped
}
/**
* @param value The name of the table in the Azure SQL database.
*/
@JvmName("oldbaayqaggfbfct")
public suspend fun table(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.table = mapped
}
/**
* @param value The username to connect to the MS SQL database.
*/
@JvmName("blengsjabnkgaguo")
public suspend fun username(`value`: String?) {
val toBeMapped = value
val mapped = toBeMapped?.let({ args0 -> of(args0) })
this.username = mapped
}
internal fun build(): ReferenceInputMssqlArgs = ReferenceInputMssqlArgs(
database = database,
deltaSnapshotQuery = deltaSnapshotQuery,
fullSnapshotQuery = fullSnapshotQuery,
name = name,
password = password,
refreshIntervalDuration = refreshIntervalDuration,
refreshType = refreshType,
resourceGroupName = resourceGroupName,
server = server,
streamAnalyticsJobName = streamAnalyticsJobName,
table = table,
username = username,
)
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy