pulumi-azure-kotlin/com.pulumi.azure.synapse.kotlin/SqlPoolWorkloadClassifierArgs

SqlPoolWorkloadClassifierArgs

data class SqlPoolWorkloadClassifierArgs(val context: Output<String>? = null, val endTime: Output<String>? = null, val importance: Output<String>? = null, val label: Output<String>? = null, val memberName: Output<String>? = null, val name: Output<String>? = null, val startTime: Output<String>? = null, val workloadGroupId: Output<String>? = null) : ConvertibleToJava<SqlPoolWorkloadClassifierArgs>

Manages a Synapse SQL Pool Workload Classifier.

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.storage.Account;
import com.pulumi.azure.storage.AccountArgs;
import com.pulumi.azure.storage.DataLakeGen2Filesystem;
import com.pulumi.azure.storage.DataLakeGen2FilesystemArgs;
import com.pulumi.azure.synapse.Workspace;
import com.pulumi.azure.synapse.WorkspaceArgs;
import com.pulumi.azure.synapse.inputs.WorkspaceIdentityArgs;
import com.pulumi.azure.synapse.SqlPool;
import com.pulumi.azure.synapse.SqlPoolArgs;
import com.pulumi.azure.synapse.SqlPoolWorkloadGroup;
import com.pulumi.azure.synapse.SqlPoolWorkloadGroupArgs;
import com.pulumi.azure.synapse.SqlPoolWorkloadClassifier;
import com.pulumi.azure.synapse.SqlPoolWorkloadClassifierArgs;
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()
            .location("West Europe")
            .build());
        var exampleAccount = new Account("exampleAccount", AccountArgs.builder()
            .resourceGroupName(exampleResourceGroup.name())
            .location(exampleResourceGroup.location())
            .accountKind("BlobStorage")
            .accountTier("Standard")
            .accountReplicationType("LRS")
            .build());
        var exampleDataLakeGen2Filesystem = new DataLakeGen2Filesystem("exampleDataLakeGen2Filesystem", DataLakeGen2FilesystemArgs.builder()
            .storageAccountId(exampleAccount.id())
            .build());
        var exampleWorkspace = new Workspace("exampleWorkspace", WorkspaceArgs.builder()
            .resourceGroupName(exampleResourceGroup.name())
            .location(exampleResourceGroup.location())
            .storageDataLakeGen2FilesystemId(exampleDataLakeGen2Filesystem.id())
            .sqlAdministratorLogin("sqladminuser")
            .sqlAdministratorLoginPassword("H@Sh1CoR3!")
            .identity(WorkspaceIdentityArgs.builder()
                .type("SystemAssigned")
                .build())
            .build());
        var exampleSqlPool = new SqlPool("exampleSqlPool", SqlPoolArgs.builder()
            .synapseWorkspaceId(exampleWorkspace.id())
            .skuName("DW100c")
            .createMode("Default")
            .build());
        var exampleSqlPoolWorkloadGroup = new SqlPoolWorkloadGroup("exampleSqlPoolWorkloadGroup", SqlPoolWorkloadGroupArgs.builder()
            .sqlPoolId(exampleSqlPool.id())
            .importance("normal")
            .maxResourcePercent(100)
            .minResourcePercent(0)
            .maxResourcePercentPerRequest(3)
            .minResourcePercentPerRequest(3)
            .queryExecutionTimeoutInSeconds(0)
            .build());
        var exampleSqlPoolWorkloadClassifier = new SqlPoolWorkloadClassifier("exampleSqlPoolWorkloadClassifier", SqlPoolWorkloadClassifierArgs.builder()
            .workloadGroupId(exampleSqlPoolWorkloadGroup.id())
            .context("example_context")
            .endTime("14:00")
            .importance("high")
            .label("example_label")
            .memberName("dbo")
            .startTime("12:00")
            .build());
    }
}

Import

Synapse SQL Pool Workload Classifiers can be imported using the resource id, e.g.

$ pulumi import azure:synapse/sqlPoolWorkloadClassifier:SqlPoolWorkloadClassifier example /subscriptions/12345678-1234-9876-4563-123456789012/resourceGroups/resGroup1/providers/Microsoft.Synapse/workspaces/workspace1/sqlPools/sqlPool1/workloadGroups/workloadGroup1/workloadClassifiers/workloadClassifier1

Constructors

SqlPoolWorkloadClassifierArgs

fun SqlPoolWorkloadClassifierArgs(context: Output<String>? = null, endTime: Output<String>? = null, importance: Output<String>? = null, label: Output<String>? = null, memberName: Output<String>? = null, name: Output<String>? = null, startTime: Output<String>? = null, workloadGroupId: Output<String>? = null)

Functions

toJava

open override fun toJava(): SqlPoolWorkloadClassifierArgs

Properties

context

val context: Output<String>? = null

Specifies the session context value that a request can be classified against.

endTime

val endTime: Output<String>? = null

The workload classifier end time for classification. It's of the HH:MM format in UTC time zone.

importance

val importance: Output<String>? = null

The workload classifier importance. The allowed values are low, below_normal, normal, above_normal and high.

label

val label: Output<String>? = null

Specifies the label value that a request can be classified against.

memberName

val memberName: Output<String>? = null

The workload classifier member name used to classified against.

name

val name: Output<String>? = null

The name which should be used for this Synapse SQL Pool Workload Classifier. Changing this forces a new Synapse SQL Pool Workload Classifier to be created.

startTime

val startTime: Output<String>? = null

The workload classifier start time for classification. It's of the HH:MM format in UTC time zone.

workloadGroupId

val workloadGroupId: Output<String>? = null

The ID of the Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Classifier to be created.