azure-native.sql.WorkloadGroup

Explore with Pulumi AI

Workload group 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 workloadGroup = new AzureNative.Sql.WorkloadGroup("workloadGroup", new()
    {
        DatabaseName = "testdb",
        Importance = "normal",
        MaxResourcePercent = 100,
        MaxResourcePercentPerRequest = 3,
        MinResourcePercent = 0,
        MinResourcePercentPerRequest = 3,
        QueryExecutionTimeout = 0,
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        ServerName = "testsvr",
        WorkloadGroupName = "smallrc",
    });

});
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.NewWorkloadGroup(ctx, "workloadGroup", &sql.WorkloadGroupArgs{
			DatabaseName:                 pulumi.String("testdb"),
			Importance:                   pulumi.String("normal"),
			MaxResourcePercent:           pulumi.Int(100),
			MaxResourcePercentPerRequest: pulumi.Float64(3),
			MinResourcePercent:           pulumi.Int(0),
			MinResourcePercentPerRequest: pulumi.Float64(3),
			QueryExecutionTimeout:        pulumi.Int(0),
			ResourceGroupName:            pulumi.String("Default-SQL-SouthEastAsia"),
			ServerName:                   pulumi.String("testsvr"),
			WorkloadGroupName:            pulumi.String("smallrc"),
		})
		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.WorkloadGroup;
import com.pulumi.azurenative.sql.WorkloadGroupArgs;
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 workloadGroup = new WorkloadGroup("workloadGroup", WorkloadGroupArgs.builder()        
            .databaseName("testdb")
            .importance("normal")
            .maxResourcePercent(100)
            .maxResourcePercentPerRequest(3)
            .minResourcePercent(0)
            .minResourcePercentPerRequest(3)
            .queryExecutionTimeout(0)
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .serverName("testsvr")
            .workloadGroupName("smallrc")
            .build());

    }
}
import pulumi
import pulumi_azure_native as azure_native

workload_group = azure_native.sql.WorkloadGroup("workloadGroup",
    database_name="testdb",
    importance="normal",
    max_resource_percent=100,
    max_resource_percent_per_request=3,
    min_resource_percent=0,
    min_resource_percent_per_request=3,
    query_execution_timeout=0,
    resource_group_name="Default-SQL-SouthEastAsia",
    server_name="testsvr",
    workload_group_name="smallrc")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const workloadGroup = new azure_native.sql.WorkloadGroup("workloadGroup", {
    databaseName: "testdb",
    importance: "normal",
    maxResourcePercent: 100,
    maxResourcePercentPerRequest: 3,
    minResourcePercent: 0,
    minResourcePercentPerRequest: 3,
    queryExecutionTimeout: 0,
    resourceGroupName: "Default-SQL-SouthEastAsia",
    serverName: "testsvr",
    workloadGroupName: "smallrc",
});
resources:
  workloadGroup:
    type: azure-native:sql:WorkloadGroup
    properties:
      databaseName: testdb
      importance: normal
      maxResourcePercent: 100
      maxResourcePercentPerRequest: 3
      minResourcePercent: 0
      minResourcePercentPerRequest: 3
      queryExecutionTimeout: 0
      resourceGroupName: Default-SQL-SouthEastAsia
      serverName: testsvr
      workloadGroupName: smallrc

Create a workload group with the required properties specified.

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

return await Deployment.RunAsync(() => 
{
    var workloadGroup = new AzureNative.Sql.WorkloadGroup("workloadGroup", new()
    {
        DatabaseName = "testdb",
        MaxResourcePercent = 100,
        MinResourcePercent = 0,
        MinResourcePercentPerRequest = 3,
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        ServerName = "testsvr",
        WorkloadGroupName = "smallrc",
    });

});
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.NewWorkloadGroup(ctx, "workloadGroup", &sql.WorkloadGroupArgs{
			DatabaseName:                 pulumi.String("testdb"),
			MaxResourcePercent:           pulumi.Int(100),
			MinResourcePercent:           pulumi.Int(0),
			MinResourcePercentPerRequest: pulumi.Float64(3),
			ResourceGroupName:            pulumi.String("Default-SQL-SouthEastAsia"),
			ServerName:                   pulumi.String("testsvr"),
			WorkloadGroupName:            pulumi.String("smallrc"),
		})
		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.WorkloadGroup;
import com.pulumi.azurenative.sql.WorkloadGroupArgs;
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 workloadGroup = new WorkloadGroup("workloadGroup", WorkloadGroupArgs.builder()        
            .databaseName("testdb")
            .maxResourcePercent(100)
            .minResourcePercent(0)
            .minResourcePercentPerRequest(3)
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .serverName("testsvr")
            .workloadGroupName("smallrc")
            .build());

    }
}
import pulumi
import pulumi_azure_native as azure_native

workload_group = azure_native.sql.WorkloadGroup("workloadGroup",
    database_name="testdb",
    max_resource_percent=100,
    min_resource_percent=0,
    min_resource_percent_per_request=3,
    resource_group_name="Default-SQL-SouthEastAsia",
    server_name="testsvr",
    workload_group_name="smallrc")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const workloadGroup = new azure_native.sql.WorkloadGroup("workloadGroup", {
    databaseName: "testdb",
    maxResourcePercent: 100,
    minResourcePercent: 0,
    minResourcePercentPerRequest: 3,
    resourceGroupName: "Default-SQL-SouthEastAsia",
    serverName: "testsvr",
    workloadGroupName: "smallrc",
});
resources:
  workloadGroup:
    type: azure-native:sql:WorkloadGroup
    properties:
      databaseName: testdb
      maxResourcePercent: 100
      minResourcePercent: 0
      minResourcePercentPerRequest: 3
      resourceGroupName: Default-SQL-SouthEastAsia
      serverName: testsvr
      workloadGroupName: smallrc

Create WorkloadGroup Resource

new WorkloadGroup(name: string, args: WorkloadGroupArgs, opts?: CustomResourceOptions);
@overload
def WorkloadGroup(resource_name: str,
                  opts: Optional[ResourceOptions] = None,
                  database_name: Optional[str] = None,
                  importance: Optional[str] = None,
                  max_resource_percent: Optional[int] = None,
                  max_resource_percent_per_request: Optional[float] = None,
                  min_resource_percent: Optional[int] = None,
                  min_resource_percent_per_request: Optional[float] = None,
                  query_execution_timeout: Optional[int] = None,
                  resource_group_name: Optional[str] = None,
                  server_name: Optional[str] = None,
                  workload_group_name: Optional[str] = None)
@overload
def WorkloadGroup(resource_name: str,
                  args: WorkloadGroupArgs,
                  opts: Optional[ResourceOptions] = None)
func NewWorkloadGroup(ctx *Context, name string, args WorkloadGroupArgs, opts ...ResourceOption) (*WorkloadGroup, error)
public WorkloadGroup(string name, WorkloadGroupArgs args, CustomResourceOptions? opts = null)
public WorkloadGroup(String name, WorkloadGroupArgs args)
public WorkloadGroup(String name, WorkloadGroupArgs args, CustomResourceOptions options)
type: azure-native:sql:WorkloadGroup
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string
The unique name of the resource.
args WorkloadGroupArgs
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 WorkloadGroupArgs
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 WorkloadGroupArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args WorkloadGroupArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name String
The unique name of the resource.
args WorkloadGroupArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

WorkloadGroup 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 WorkloadGroup resource accepts the following input properties:

DatabaseName string

The name of the database.

MaxResourcePercent int

The workload group cap percentage resource.

MinResourcePercent int

The workload group minimum percentage resource.

MinResourcePercentPerRequest double

The workload group request minimum grant percentage.

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.

Importance string

The workload group importance level.

MaxResourcePercentPerRequest double

The workload group request maximum grant percentage.

QueryExecutionTimeout int

The workload group query execution timeout.

WorkloadGroupName string

The name of the workload group.

DatabaseName string

The name of the database.

MaxResourcePercent int

The workload group cap percentage resource.

MinResourcePercent int

The workload group minimum percentage resource.

MinResourcePercentPerRequest float64

The workload group request minimum grant percentage.

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.

Importance string

The workload group importance level.

MaxResourcePercentPerRequest float64

The workload group request maximum grant percentage.

QueryExecutionTimeout int

The workload group query execution timeout.

WorkloadGroupName string

The name of the workload group.

databaseName String

The name of the database.

maxResourcePercent Integer

The workload group cap percentage resource.

minResourcePercent Integer

The workload group minimum percentage resource.

minResourcePercentPerRequest Double

The workload group request minimum grant percentage.

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.

importance String

The workload group importance level.

maxResourcePercentPerRequest Double

The workload group request maximum grant percentage.

queryExecutionTimeout Integer

The workload group query execution timeout.

workloadGroupName String

The name of the workload group.

databaseName string

The name of the database.

maxResourcePercent number

The workload group cap percentage resource.

minResourcePercent number

The workload group minimum percentage resource.

minResourcePercentPerRequest number

The workload group request minimum grant percentage.

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.

importance string

The workload group importance level.

maxResourcePercentPerRequest number

The workload group request maximum grant percentage.

queryExecutionTimeout number

The workload group query execution timeout.

workloadGroupName string

The name of the workload group.

database_name str

The name of the database.

max_resource_percent int

The workload group cap percentage resource.

min_resource_percent int

The workload group minimum percentage resource.

min_resource_percent_per_request float

The workload group request minimum grant percentage.

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.

importance str

The workload group importance level.

max_resource_percent_per_request float

The workload group request maximum grant percentage.

query_execution_timeout int

The workload group query execution timeout.

workload_group_name str

The name of the workload group.

databaseName String

The name of the database.

maxResourcePercent Number

The workload group cap percentage resource.

minResourcePercent Number

The workload group minimum percentage resource.

minResourcePercentPerRequest Number

The workload group request minimum grant percentage.

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.

importance String

The workload group importance level.

maxResourcePercentPerRequest Number

The workload group request maximum grant percentage.

queryExecutionTimeout Number

The workload group query execution timeout.

workloadGroupName String

The name of the workload group.

Outputs

All input properties are implicitly available as output properties. Additionally, the WorkloadGroup 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:WorkloadGroup smallrc /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb/workloadGroups/smallrc 

Package Details

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