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

SqlPoolWorkloadGroupArgs

data class SqlPoolWorkloadGroupArgs(val importance: Output<String>? = null, val maxResourcePercent: Output<Int>? = null, val maxResourcePercentPerRequest: Output<Double>? = null, val minResourcePercent: Output<Int>? = null, val minResourcePercentPerRequest: Output<Double>? = null, val name: Output<String>? = null, val queryExecutionTimeoutInSeconds: Output<Int>? = null, val sqlPoolId: Output<String>? = null) : ConvertibleToJava<SqlPoolWorkloadGroupArgs>

Manages a Synapse SQL Pool Workload Group.

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 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 example = new ResourceGroup("example", ResourceGroupArgs.builder()
            .name("example")
            .location("west europe")
            .build());
        var exampleAccount = new Account("exampleAccount", AccountArgs.builder()
            .name("example")
            .resourceGroupName(example.name())
            .location(example.location())
            .accountKind("BlobStorage")
            .accountTier("Standard")
            .accountReplicationType("LRS")
            .build());
        var exampleDataLakeGen2Filesystem = new DataLakeGen2Filesystem("exampleDataLakeGen2Filesystem", DataLakeGen2FilesystemArgs.builder()
            .name("example")
            .storageAccountId(exampleAccount.id())
            .build());
        var exampleWorkspace = new Workspace("exampleWorkspace", WorkspaceArgs.builder()
            .name("example")
            .resourceGroupName(example.name())
            .location(example.location())
            .storageDataLakeGen2FilesystemId(exampleDataLakeGen2Filesystem.id())
            .sqlAdministratorLogin("sqladminuser")
            .sqlAdministratorLoginPassword("H@Sh1CoR3!")
            .identity(WorkspaceIdentityArgs.builder()
                .type("SystemAssigned")
                .build())
            .build());
        var exampleSqlPool = new SqlPool("exampleSqlPool", SqlPoolArgs.builder()
            .name("example")
            .synapseWorkspaceId(exampleWorkspace.id())
            .skuName("DW100c")
            .createMode("Default")
            .build());
        var exampleSqlPoolWorkloadGroup = new SqlPoolWorkloadGroup("exampleSqlPoolWorkloadGroup", SqlPoolWorkloadGroupArgs.builder()
            .name("example")
            .sqlPoolId(exampleSqlPool.id())
            .importance("normal")
            .maxResourcePercent(100)
            .minResourcePercent(0)
            .maxResourcePercentPerRequest(3)
            .minResourcePercentPerRequest(3)
            .queryExecutionTimeoutInSeconds(0)
            .build());
    }
}

Import

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

$ pulumi import azure:synapse/sqlPoolWorkloadGroup:SqlPoolWorkloadGroup example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/resGroup1/providers/Microsoft.Synapse/workspaces/workspace1/sqlPools/sqlPool1/workloadGroups/workloadGroup1

Constructors

SqlPoolWorkloadGroupArgs

fun SqlPoolWorkloadGroupArgs(importance: Output<String>? = null, maxResourcePercent: Output<Int>? = null, maxResourcePercentPerRequest: Output<Double>? = null, minResourcePercent: Output<Int>? = null, minResourcePercentPerRequest: Output<Double>? = null, name: Output<String>? = null, queryExecutionTimeoutInSeconds: Output<Int>? = null, sqlPoolId: Output<String>? = null)