Ready to level-up your engineering skills? Join a Pulumi Workshop. Register Now
  1. Docs
  2. Reference
  3. API
  4. Azure NextGen
  5. synapse
  6. SqlPoolWorkloadClassifier

SqlPoolWorkloadClassifier

Workload classifier operations for a data warehouse

Example Usage

Create a workload classifier with all properties specified.

using Pulumi;
using AzureNextGen = Pulumi.AzureNextGen;

class MyStack : Stack
{
    public MyStack()
    {
        var sqlPoolWorkloadClassifier = new AzureNextGen.Synapse.V20190601Preview.SqlPoolWorkloadClassifier("sqlPoolWorkloadClassifier", new AzureNextGen.Synapse.V20190601Preview.SqlPoolWorkloadClassifierArgs
        {
            Context = "test_context",
            EndTime = "14:00",
            Importance = "high",
            Label = "test_label",
            MemberName = "dbo",
            ResourceGroupName = "sqlcrudtest-6852",
            SqlPoolName = "sqlcrudtest-9187",
            StartTime = "12:00",
            WorkloadClassifierName = "wlm_workloadclassifier",
            WorkloadGroupName = "wlm_workloadgroup",
            WorkspaceName = "sqlcrudtest-2080",
        });
    }

}

package main

import (
    synapse "github.com/pulumi/pulumi-azure-nextgen/sdk/go/azure/synapse/v20190601preview"
    "github.com/pulumi/pulumi/sdk/v2/go/pulumi"
)

func main() {
    pulumi.Run(func(ctx *pulumi.Context) error {
        _, err := synapse.NewSqlPoolWorkloadClassifier(ctx, "sqlPoolWorkloadClassifier", &synapse.SqlPoolWorkloadClassifierArgs{
            Context:                pulumi.String("test_context"),
            EndTime:                pulumi.String("14:00"),
            Importance:             pulumi.String("high"),
            Label:                  pulumi.String("test_label"),
            MemberName:             pulumi.String("dbo"),
            ResourceGroupName:      pulumi.String("sqlcrudtest-6852"),
            SqlPoolName:            pulumi.String("sqlcrudtest-9187"),
            StartTime:              pulumi.String("12:00"),
            WorkloadClassifierName: pulumi.String("wlm_workloadclassifier"),
            WorkloadGroupName:      pulumi.String("wlm_workloadgroup"),
            WorkspaceName:          pulumi.String("sqlcrudtest-2080"),
        })
        if err != nil {
            return err
        }
        return nil
    })
}
import pulumi
import pulumi_azure_nextgen as azure_nextgen

sql_pool_workload_classifier = azure_nextgen.synapse.v20190601preview.SqlPoolWorkloadClassifier("sqlPoolWorkloadClassifier",
    context="test_context",
    end_time="14:00",
    importance="high",
    label="test_label",
    member_name="dbo",
    resource_group_name="sqlcrudtest-6852",
    sql_pool_name="sqlcrudtest-9187",
    start_time="12:00",
    workload_classifier_name="wlm_workloadclassifier",
    workload_group_name="wlm_workloadgroup",
    workspace_name="sqlcrudtest-2080")
import * as pulumi from "@pulumi/pulumi";
import * as azure_nextgen from "@pulumi/azure-nextgen";

const sqlPoolWorkloadClassifier = new azure_nextgen.synapse.v20190601preview.SqlPoolWorkloadClassifier("sqlPoolWorkloadClassifier", {
    context: "test_context",
    endTime: "14:00",
    importance: "high",
    label: "test_label",
    memberName: "dbo",
    resourceGroupName: "sqlcrudtest-6852",
    sqlPoolName: "sqlcrudtest-9187",
    startTime: "12:00",
    workloadClassifierName: "wlm_workloadclassifier",
    workloadGroupName: "wlm_workloadgroup",
    workspaceName: "sqlcrudtest-2080",
});

Create a workload classifier with the required properties specified.

using Pulumi;
using AzureNextGen = Pulumi.AzureNextGen;

class MyStack : Stack
{
    public MyStack()
    {
        var sqlPoolWorkloadClassifier = new AzureNextGen.Synapse.V20190601Preview.SqlPoolWorkloadClassifier("sqlPoolWorkloadClassifier", new AzureNextGen.Synapse.V20190601Preview.SqlPoolWorkloadClassifierArgs
        {
            MemberName = "dbo",
            ResourceGroupName = "sqlcrudtest-6852",
            SqlPoolName = "sqlcrudtest-9187",
            WorkloadClassifierName = "wlm_workloadclassifier",
            WorkloadGroupName = "wlm_workloadgroup",
            WorkspaceName = "sqlcrudtest-2080",
        });
    }

}

package main

import (
    synapse "github.com/pulumi/pulumi-azure-nextgen/sdk/go/azure/synapse/v20190601preview"
    "github.com/pulumi/pulumi/sdk/v2/go/pulumi"
)

func main() {
    pulumi.Run(func(ctx *pulumi.Context) error {
        _, err := synapse.NewSqlPoolWorkloadClassifier(ctx, "sqlPoolWorkloadClassifier", &synapse.SqlPoolWorkloadClassifierArgs{
            MemberName:             pulumi.String("dbo"),
            ResourceGroupName:      pulumi.String("sqlcrudtest-6852"),
            SqlPoolName:            pulumi.String("sqlcrudtest-9187"),
            WorkloadClassifierName: pulumi.String("wlm_workloadclassifier"),
            WorkloadGroupName:      pulumi.String("wlm_workloadgroup"),
            WorkspaceName:          pulumi.String("sqlcrudtest-2080"),
        })
        if err != nil {
            return err
        }
        return nil
    })
}
import pulumi
import pulumi_azure_nextgen as azure_nextgen

sql_pool_workload_classifier = azure_nextgen.synapse.v20190601preview.SqlPoolWorkloadClassifier("sqlPoolWorkloadClassifier",
    member_name="dbo",
    resource_group_name="sqlcrudtest-6852",
    sql_pool_name="sqlcrudtest-9187",
    workload_classifier_name="wlm_workloadclassifier",
    workload_group_name="wlm_workloadgroup",
    workspace_name="sqlcrudtest-2080")
import * as pulumi from "@pulumi/pulumi";
import * as azure_nextgen from "@pulumi/azure-nextgen";

const sqlPoolWorkloadClassifier = new azure_nextgen.synapse.v20190601preview.SqlPoolWorkloadClassifier("sqlPoolWorkloadClassifier", {
    memberName: "dbo",
    resourceGroupName: "sqlcrudtest-6852",
    sqlPoolName: "sqlcrudtest-9187",
    workloadClassifierName: "wlm_workloadclassifier",
    workloadGroupName: "wlm_workloadgroup",
    workspaceName: "sqlcrudtest-2080",
});

Create a SqlPoolWorkloadClassifier Resource

new SqlPoolWorkloadClassifier(name: string, args: SqlPoolWorkloadClassifierArgs, opts?: CustomResourceOptions);
def SqlPoolWorkloadClassifier(resource_name: str, opts: Optional[ResourceOptions] = None, context: 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, sql_pool_name: Optional[str] = None, start_time: Optional[str] = None, workload_classifier_name: Optional[str] = None, workload_group_name: Optional[str] = None, workspace_name: Optional[str] = None)
func NewSqlPoolWorkloadClassifier(ctx *Context, name string, args SqlPoolWorkloadClassifierArgs, opts ...ResourceOption) (*SqlPoolWorkloadClassifier, error)
public SqlPoolWorkloadClassifier(string name, SqlPoolWorkloadClassifierArgs args, CustomResourceOptions? opts = null)
name string
The unique name of the resource.
args SqlPoolWorkloadClassifierArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
opts ResourceOptions
A bag of options that control this resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args SqlPoolWorkloadClassifierArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args SqlPoolWorkloadClassifierArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.

SqlPoolWorkloadClassifier Resource Properties

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

Inputs

The SqlPoolWorkloadClassifier resource accepts the following input properties:

MemberName string
The workload classifier member name.
ResourceGroupName string
The name of the resource group. The name is case insensitive.
SqlPoolName string
SQL pool name
WorkloadClassifierName string
The name of the workload classifier.
WorkloadGroupName string
The name of the workload group.
WorkspaceName string
The name of the workspace
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.
MemberName string
The workload classifier member name.
ResourceGroupName string
The name of the resource group. The name is case insensitive.
SqlPoolName string
SQL pool name
WorkloadClassifierName string
The name of the workload classifier.
WorkloadGroupName string
The name of the workload group.
WorkspaceName string
The name of the workspace
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.
memberName string
The workload classifier member name.
resourceGroupName string
The name of the resource group. The name is case insensitive.
sqlPoolName string
SQL pool name
workloadClassifierName string
The name of the workload classifier.
workloadGroupName string
The name of the workload group.
workspaceName string
The name of the workspace
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.
member_name str
The workload classifier member name.
resource_group_name str
The name of the resource group. The name is case insensitive.
sql_pool_name str
SQL pool name
workload_classifier_name str
The name of the workload classifier.
workload_group_name str
The name of the workload group.
workspace_name str
The name of the workspace
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.

Outputs

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

Id string
The provider-assigned unique ID for this managed resource.
Name string
The name of the resource
Type string
The type of the resource. E.g. “Microsoft.Compute/virtualMachines” or “Microsoft.Storage/storageAccounts”
Id string
The provider-assigned unique ID for this managed resource.
Name string
The name of the resource
Type string
The type of the resource. E.g. “Microsoft.Compute/virtualMachines” or “Microsoft.Storage/storageAccounts”
id string
The provider-assigned unique ID for this managed resource.
name string
The name of the resource
type string
The type of the resource. E.g. “Microsoft.Compute/virtualMachines” or “Microsoft.Storage/storageAccounts”
id str
The provider-assigned unique ID for this managed resource.
name str
The name of the resource
type str
The type of the resource. E.g. “Microsoft.Compute/virtualMachines” or “Microsoft.Storage/storageAccounts”

Import

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

$ pulumi import azure-nextgen:synapse/v20190601preview:SqlPoolWorkloadClassifier wlm_workloadclassifier /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Synapse/workspaces/sqlcrudtest-2080/sqlPools/sqlcrudtest-9187/workloadGroups/wlm_workloadgroup/workloadClassifiers/wlm_workloadclassifier

Package Details

Repository
https://github.com/pulumi/pulumi-azure-nextgen
License
Apache-2.0