OutputMssql

class OutputMssql : KotlinCustomResource

Manages a Stream Analytics Output to Microsoft SQL Server Database.

Example Usage

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.sql.SqlServer;
import com.pulumi.azure.sql.SqlServerArgs;
import com.pulumi.azure.sql.Database;
import com.pulumi.azure.sql.DatabaseArgs;
import com.pulumi.azure.streamanalytics.OutputMssql;
import com.pulumi.azure.streamanalytics.OutputMssqlArgs;
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("rg-example")
.location("West Europe")
.build());
final var example = StreamanalyticsFunctions.getJob(GetJobArgs.builder()
.name("example-job")
.resourceGroupName(exampleResourceGroup.name())
.build());
var exampleSqlServer = new SqlServer("exampleSqlServer", SqlServerArgs.builder()
.name("example-server")
.resourceGroupName(exampleResourceGroup.name())
.location(exampleResourceGroup.location())
.version("12.0")
.administratorLogin("dbadmin")
.administratorLoginPassword("example-password")
.build());
var exampleDatabase = new Database("exampleDatabase", DatabaseArgs.builder()
.name("exampledb")
.resourceGroupName(exampleResourceGroup.name())
.location(exampleResourceGroup.location())
.serverName(exampleSqlServer.name())
.requestedServiceObjectiveName("S0")
.collation("SQL_LATIN1_GENERAL_CP1_CI_AS")
.maxSizeBytes("268435456000")
.createMode("Default")
.build());
var exampleOutputMssql = new OutputMssql("exampleOutputMssql", OutputMssqlArgs.builder()
.name("example-output-sql")
.streamAnalyticsJobName(example.applyValue(getJobResult -> getJobResult).applyValue(example -> example.applyValue(getJobResult -> getJobResult.name())))
.resourceGroupName(example.applyValue(getJobResult -> getJobResult).applyValue(example -> example.applyValue(getJobResult -> getJobResult.resourceGroupName())))
.server(exampleSqlServer.fullyQualifiedDomainName())
.user(exampleSqlServer.administratorLogin())
.password(exampleSqlServer.administratorLoginPassword())
.database(exampleDatabase.name())
.table("ExampleTable")
.build());
}
}

Import

Stream Analytics Outputs to Microsoft SQL Server Database can be imported using the resource id, e.g.

$ pulumi import azure:streamanalytics/outputMssql:OutputMssql example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/group1/providers/Microsoft.StreamAnalytics/streamingJobs/job1/outputs/output1

Properties

Link copied to clipboard

The authentication mode for the Stream Output. Possible values are Msi and ConnectionString. Defaults to ConnectionString.

Link copied to clipboard
val database: Output<String>

The MS SQL database name where the reference table exists. Changing this forces a new resource to be created.

Link copied to clipboard
val id: Output<String>
Link copied to clipboard
val maxBatchCount: Output<Double>?

The max batch count to write to the SQL Database. Defaults to 10000. Possible values are between 1 and 1073741824.

Link copied to clipboard
val maxWriterCount: Output<Double>?

The max writer count for the SQL Database. Defaults to 1. Possible values are 0 which bases the writer count on the query partition and 1 which corresponds to a single writer.

Link copied to clipboard
val name: Output<String>

The name of the Stream Output. Changing this forces a new resource to be created.

Link copied to clipboard
val password: Output<String>?

Password used together with username, to login to the Microsoft SQL Server. Required if authentication_mode is ConnectionString.

Link copied to clipboard
val pulumiChildResources: Set<KotlinResource>
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard

The name of the Resource Group where the Stream Analytics Job exists. Changing this forces a new resource to be created.

Link copied to clipboard
val server: Output<String>

The SQL server url. Changing this forces a new resource to be created.

Link copied to clipboard

The name of the Stream Analytics Job. Changing this forces a new resource to be created.

Link copied to clipboard
val table: Output<String>

Table in the database that the output points to. Changing this forces a new resource to be created.

Link copied to clipboard
val urn: Output<String>
Link copied to clipboard
val user: Output<String>?

Username used to login to the Microsoft SQL Server. Changing this forces a new resource to be created. Required if authentication_mode is ConnectionString.