Azure Native v1.102.0, May 2 23

azure-native.sql.WorkloadClassifier

Explore with Pulumi AI

Workload classifier operations for a data warehouse API Version: 2020-11-01-preview.

Example Usage

Create a workload group with all properties specified.

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var workloadClassifier = new AzureNative.Sql.WorkloadClassifier("workloadClassifier", new()
    {
        Context = "test_context",
        DatabaseName = "testdb",
        EndTime = "14:00",
        Importance = "high",
        Label = "test_label",
        MemberName = "dbo",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        ServerName = "testsvr",
        StartTime = "12:00",
        WorkloadClassifierName = "wlm_workloadclassifier",
        WorkloadGroupName = "wlm_workloadgroup",
    });

});

package main

import (
	sql "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewWorkloadClassifier(ctx, "workloadClassifier", &sql.WorkloadClassifierArgs{
			Context:                pulumi.String("test_context"),
			DatabaseName:           pulumi.String("testdb"),
			EndTime:                pulumi.String("14:00"),
			Importance:             pulumi.String("high"),
			Label:                  pulumi.String("test_label"),
			MemberName:             pulumi.String("dbo"),
			ResourceGroupName:      pulumi.String("Default-SQL-SouthEastAsia"),
			ServerName:             pulumi.String("testsvr"),
			StartTime:              pulumi.String("12:00"),
			WorkloadClassifierName: pulumi.String("wlm_workloadclassifier"),
			WorkloadGroupName:      pulumi.String("wlm_workloadgroup"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.WorkloadClassifier;
import com.pulumi.azurenative.sql.WorkloadClassifierArgs;
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 workloadClassifier = new WorkloadClassifier("workloadClassifier", WorkloadClassifierArgs.builder()        
            .context("test_context")
            .databaseName("testdb")
            .endTime("14:00")
            .importance("high")
            .label("test_label")
            .memberName("dbo")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .serverName("testsvr")
            .startTime("12:00")
            .workloadClassifierName("wlm_workloadclassifier")
            .workloadGroupName("wlm_workloadgroup")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

workload_classifier = azure_native.sql.WorkloadClassifier("workloadClassifier",
    context="test_context",
    database_name="testdb",
    end_time="14:00",
    importance="high",
    label="test_label",
    member_name="dbo",
    resource_group_name="Default-SQL-SouthEastAsia",
    server_name="testsvr",
    start_time="12:00",
    workload_classifier_name="wlm_workloadclassifier",
    workload_group_name="wlm_workloadgroup")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const workloadClassifier = new azure_native.sql.WorkloadClassifier("workloadClassifier", {
    context: "test_context",
    databaseName: "testdb",
    endTime: "14:00",
    importance: "high",
    label: "test_label",
    memberName: "dbo",
    resourceGroupName: "Default-SQL-SouthEastAsia",
    serverName: "testsvr",
    startTime: "12:00",
    workloadClassifierName: "wlm_workloadclassifier",
    workloadGroupName: "wlm_workloadgroup",
});

resources:
  workloadClassifier:
    type: azure-native:sql:WorkloadClassifier
    properties:
      context: test_context
      databaseName: testdb
      endTime: 14:00
      importance: high
      label: test_label
      memberName: dbo
      resourceGroupName: Default-SQL-SouthEastAsia
      serverName: testsvr
      startTime: 12:00
      workloadClassifierName: wlm_workloadclassifier
      workloadGroupName: wlm_workloadgroup

Create a workload group with the required properties specified.

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var workloadClassifier = new AzureNative.Sql.WorkloadClassifier("workloadClassifier", new()
    {
        DatabaseName = "testdb",
        MemberName = "dbo",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        ServerName = "testsvr",
        WorkloadClassifierName = "wlm_workloadclassifier",
        WorkloadGroupName = "wlm_workloadgroup",
    });

});

package main

import (
	sql "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewWorkloadClassifier(ctx, "workloadClassifier", &sql.WorkloadClassifierArgs{
			DatabaseName:           pulumi.String("testdb"),
			MemberName:             pulumi.String("dbo"),
			ResourceGroupName:      pulumi.String("Default-SQL-SouthEastAsia"),
			ServerName:             pulumi.String("testsvr"),
			WorkloadClassifierName: pulumi.String("wlm_workloadclassifier"),
			WorkloadGroupName:      pulumi.String("wlm_workloadgroup"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.WorkloadClassifier;
import com.pulumi.azurenative.sql.WorkloadClassifierArgs;
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 workloadClassifier = new WorkloadClassifier("workloadClassifier", WorkloadClassifierArgs.builder()        
            .databaseName("testdb")
            .memberName("dbo")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .serverName("testsvr")
            .workloadClassifierName("wlm_workloadclassifier")
            .workloadGroupName("wlm_workloadgroup")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

workload_classifier = azure_native.sql.WorkloadClassifier("workloadClassifier",
    database_name="testdb",
    member_name="dbo",
    resource_group_name="Default-SQL-SouthEastAsia",
    server_name="testsvr",
    workload_classifier_name="wlm_workloadclassifier",
    workload_group_name="wlm_workloadgroup")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const workloadClassifier = new azure_native.sql.WorkloadClassifier("workloadClassifier", {
    databaseName: "testdb",
    memberName: "dbo",
    resourceGroupName: "Default-SQL-SouthEastAsia",
    serverName: "testsvr",
    workloadClassifierName: "wlm_workloadclassifier",
    workloadGroupName: "wlm_workloadgroup",
});

resources:
  workloadClassifier:
    type: azure-native:sql:WorkloadClassifier
    properties:
      databaseName: testdb
      memberName: dbo
      resourceGroupName: Default-SQL-SouthEastAsia
      serverName: testsvr
      workloadClassifierName: wlm_workloadclassifier
      workloadGroupName: wlm_workloadgroup

Create WorkloadClassifier Resource

new WorkloadClassifier(name: string, args: WorkloadClassifierArgs, opts?: CustomResourceOptions);

@overload
def WorkloadClassifier(resource_name: str,
                       opts: Optional[ResourceOptions] = None,
                       context: Optional[str] = None,
                       database_name: Optional[str] = None,
                       end_time: Optional[str] = None,
                       importance: Optional[str] = None,
                       label: Optional[str] = None,
                       member_name: Optional[str] = None,
                       resource_group_name: Optional[str] = None,
                       server_name: Optional[str] = None,
                       start_time: Optional[str] = None,
                       workload_classifier_name: Optional[str] = None,
                       workload_group_name: Optional[str] = None)
@overload
def WorkloadClassifier(resource_name: str,
                       args: WorkloadClassifierArgs,
                       opts: Optional[ResourceOptions] = None)

func NewWorkloadClassifier(ctx *Context, name string, args WorkloadClassifierArgs, opts ...ResourceOption) (*WorkloadClassifier, error)

public WorkloadClassifier(string name, WorkloadClassifierArgs args, CustomResourceOptions? opts = null)

public WorkloadClassifier(String name, WorkloadClassifierArgs args)
public WorkloadClassifier(String name, WorkloadClassifierArgs args, CustomResourceOptions options)

type: azure-native:sql:WorkloadClassifier
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string: The unique name of the resource.
args WorkloadClassifierArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

resource_name str: The unique name of the resource.
args WorkloadClassifierArgs: The arguments to resource properties.
opts ResourceOptions: Bag of options to control resource's behavior.

ctx Context: Context object for the current deployment.
name string: The unique name of the resource.
args WorkloadClassifierArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args WorkloadClassifierArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args WorkloadClassifierArgs: The arguments to resource properties.
options CustomResourceOptions: Bag of options to control resource's behavior.

WorkloadClassifier Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The WorkloadClassifier resource accepts the following input properties:

DatabaseName string: The name of the database.
MemberName string: The workload classifier member name.
ResourceGroupName string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
ServerName string: The name of the server.
WorkloadGroupName string: The name of the workload group from which to receive the classifier from.
Context string: The workload classifier context.
EndTime string: The workload classifier end time for classification.
Importance string: The workload classifier importance.
Label string: The workload classifier label.
StartTime string: The workload classifier start time for classification.
WorkloadClassifierName string: The name of the workload classifier to create/update.

DatabaseName string: The name of the database.
MemberName string: The workload classifier member name.
ResourceGroupName string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
ServerName string: The name of the server.
WorkloadGroupName string: The name of the workload group from which to receive the classifier from.
Context string: The workload classifier context.
EndTime string: The workload classifier end time for classification.
Importance string: The workload classifier importance.
Label string: The workload classifier label.
StartTime string: The workload classifier start time for classification.
WorkloadClassifierName string: The name of the workload classifier to create/update.

databaseName String: The name of the database.
memberName String: The workload classifier member name.
resourceGroupName String: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName String: The name of the server.
workloadGroupName String: The name of the workload group from which to receive the classifier from.
context String: The workload classifier context.
endTime String: The workload classifier end time for classification.
importance String: The workload classifier importance.
label String: The workload classifier label.
startTime String: The workload classifier start time for classification.
workloadClassifierName String: The name of the workload classifier to create/update.

databaseName string: The name of the database.
memberName string: The workload classifier member name.
resourceGroupName string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName string: The name of the server.
workloadGroupName string: The name of the workload group from which to receive the classifier from.
context string: The workload classifier context.
endTime string: The workload classifier end time for classification.
importance string: The workload classifier importance.
label string: The workload classifier label.
startTime string: The workload classifier start time for classification.
workloadClassifierName string: The name of the workload classifier to create/update.

database_name str: The name of the database.
member_name str: The workload classifier member name.
resource_group_name str: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
server_name str: The name of the server.
workload_group_name str: The name of the workload group from which to receive the classifier from.
context str: The workload classifier context.
end_time str: The workload classifier end time for classification.
importance str: The workload classifier importance.
label str: The workload classifier label.
start_time str: The workload classifier start time for classification.
workload_classifier_name str: The name of the workload classifier to create/update.

databaseName String: The name of the database.
memberName String: The workload classifier member name.
resourceGroupName String: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName String: The name of the server.
workloadGroupName String: The name of the workload group from which to receive the classifier from.
context String: The workload classifier context.
endTime String: The workload classifier end time for classification.
importance String: The workload classifier importance.
label String: The workload classifier label.
startTime String: The workload classifier start time for classification.
workloadClassifierName String: The name of the workload classifier to create/update.

Outputs

All input properties are implicitly available as output properties. Additionally, the WorkloadClassifier resource produces the following output properties:

Id string: The provider-assigned unique ID for this managed resource.
Name string: Resource name.
Type string: Resource type.

Id string: The provider-assigned unique ID for this managed resource.
Name string: Resource name.
Type string: Resource type.

id String: The provider-assigned unique ID for this managed resource.
name String: Resource name.
type String: Resource type.

id string: The provider-assigned unique ID for this managed resource.
name string: Resource name.
type string: Resource type.

id str: The provider-assigned unique ID for this managed resource.
name str: Resource name.
type str: Resource type.

id String: The provider-assigned unique ID for this managed resource.
name String: Resource name.
type String: Resource type.

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:sql:WorkloadClassifier wlm_workloadclassifier /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb/workloadGroups/wlm_workloadgroup/workloadClassifiers/wlm_workloadclassifier

Package Details

Repository: Azure Native pulumi/pulumi-azure-native
License: Apache-2.0