Docs
PackagesWe recommend using Azure Native.
azure.synapse.SqlPoolWorkloadGroup
Explore with Pulumi AI
Manages a Synapse SQL Pool Workload Group.
Example Usage
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;
return await Deployment.RunAsync(() =>
{
var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new()
{
Location = "west europe",
});
var exampleAccount = new Azure.Storage.Account("exampleAccount", new()
{
ResourceGroupName = exampleResourceGroup.Name,
Location = exampleResourceGroup.Location,
AccountKind = "BlobStorage",
AccountTier = "Standard",
AccountReplicationType = "LRS",
});
var exampleDataLakeGen2Filesystem = new Azure.Storage.DataLakeGen2Filesystem("exampleDataLakeGen2Filesystem", new()
{
StorageAccountId = exampleAccount.Id,
});
var exampleWorkspace = new Azure.Synapse.Workspace("exampleWorkspace", new()
{
ResourceGroupName = exampleResourceGroup.Name,
Location = exampleResourceGroup.Location,
StorageDataLakeGen2FilesystemId = exampleDataLakeGen2Filesystem.Id,
SqlAdministratorLogin = "sqladminuser",
SqlAdministratorLoginPassword = "H@Sh1CoR3!",
Identity = new Azure.Synapse.Inputs.WorkspaceIdentityArgs
{
Type = "SystemAssigned",
},
});
var exampleSqlPool = new Azure.Synapse.SqlPool("exampleSqlPool", new()
{
SynapseWorkspaceId = exampleWorkspace.Id,
SkuName = "DW100c",
CreateMode = "Default",
});
var exampleSqlPoolWorkloadGroup = new Azure.Synapse.SqlPoolWorkloadGroup("exampleSqlPoolWorkloadGroup", new()
{
SqlPoolId = exampleSqlPool.Id,
Importance = "normal",
MaxResourcePercent = 100,
MinResourcePercent = 0,
MaxResourcePercentPerRequest = 3,
MinResourcePercentPerRequest = 3,
QueryExecutionTimeoutInSeconds = 0,
});
});
package main
import (
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/core"
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/storage"
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/synapse"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
exampleResourceGroup, err := core.NewResourceGroup(ctx, "exampleResourceGroup", &core.ResourceGroupArgs{
Location: pulumi.String("west europe"),
})
if err != nil {
return err
}
exampleAccount, err := storage.NewAccount(ctx, "exampleAccount", &storage.AccountArgs{
ResourceGroupName: exampleResourceGroup.Name,
Location: exampleResourceGroup.Location,
AccountKind: pulumi.String("BlobStorage"),
AccountTier: pulumi.String("Standard"),
AccountReplicationType: pulumi.String("LRS"),
})
if err != nil {
return err
}
exampleDataLakeGen2Filesystem, err := storage.NewDataLakeGen2Filesystem(ctx, "exampleDataLakeGen2Filesystem", &storage.DataLakeGen2FilesystemArgs{
StorageAccountId: exampleAccount.ID(),
})
if err != nil {
return err
}
exampleWorkspace, err := synapse.NewWorkspace(ctx, "exampleWorkspace", &synapse.WorkspaceArgs{
ResourceGroupName: exampleResourceGroup.Name,
Location: exampleResourceGroup.Location,
StorageDataLakeGen2FilesystemId: exampleDataLakeGen2Filesystem.ID(),
SqlAdministratorLogin: pulumi.String("sqladminuser"),
SqlAdministratorLoginPassword: pulumi.String("H@Sh1CoR3!"),
Identity: &synapse.WorkspaceIdentityArgs{
Type: pulumi.String("SystemAssigned"),
},
})
if err != nil {
return err
}
exampleSqlPool, err := synapse.NewSqlPool(ctx, "exampleSqlPool", &synapse.SqlPoolArgs{
SynapseWorkspaceId: exampleWorkspace.ID(),
SkuName: pulumi.String("DW100c"),
CreateMode: pulumi.String("Default"),
})
if err != nil {
return err
}
_, err = synapse.NewSqlPoolWorkloadGroup(ctx, "exampleSqlPoolWorkloadGroup", &synapse.SqlPoolWorkloadGroupArgs{
SqlPoolId: exampleSqlPool.ID(),
Importance: pulumi.String("normal"),
MaxResourcePercent: pulumi.Int(100),
MinResourcePercent: pulumi.Int(0),
MaxResourcePercentPerRequest: pulumi.Float64(3),
MinResourcePercentPerRequest: pulumi.Float64(3),
QueryExecutionTimeoutInSeconds: pulumi.Int(0),
})
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.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 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());
}
}
import pulumi
import pulumi_azure as azure
example_resource_group = azure.core.ResourceGroup("exampleResourceGroup", location="west europe")
example_account = azure.storage.Account("exampleAccount",
resource_group_name=example_resource_group.name,
location=example_resource_group.location,
account_kind="BlobStorage",
account_tier="Standard",
account_replication_type="LRS")
example_data_lake_gen2_filesystem = azure.storage.DataLakeGen2Filesystem("exampleDataLakeGen2Filesystem", storage_account_id=example_account.id)
example_workspace = azure.synapse.Workspace("exampleWorkspace",
resource_group_name=example_resource_group.name,
location=example_resource_group.location,
storage_data_lake_gen2_filesystem_id=example_data_lake_gen2_filesystem.id,
sql_administrator_login="sqladminuser",
sql_administrator_login_password="H@Sh1CoR3!",
identity=azure.synapse.WorkspaceIdentityArgs(
type="SystemAssigned",
))
example_sql_pool = azure.synapse.SqlPool("exampleSqlPool",
synapse_workspace_id=example_workspace.id,
sku_name="DW100c",
create_mode="Default")
example_sql_pool_workload_group = azure.synapse.SqlPoolWorkloadGroup("exampleSqlPoolWorkloadGroup",
sql_pool_id=example_sql_pool.id,
importance="normal",
max_resource_percent=100,
min_resource_percent=0,
max_resource_percent_per_request=3,
min_resource_percent_per_request=3,
query_execution_timeout_in_seconds=0)
import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
const exampleResourceGroup = new azure.core.ResourceGroup("exampleResourceGroup", {location: "west europe"});
const exampleAccount = new azure.storage.Account("exampleAccount", {
resourceGroupName: exampleResourceGroup.name,
location: exampleResourceGroup.location,
accountKind: "BlobStorage",
accountTier: "Standard",
accountReplicationType: "LRS",
});
const exampleDataLakeGen2Filesystem = new azure.storage.DataLakeGen2Filesystem("exampleDataLakeGen2Filesystem", {storageAccountId: exampleAccount.id});
const exampleWorkspace = new azure.synapse.Workspace("exampleWorkspace", {
resourceGroupName: exampleResourceGroup.name,
location: exampleResourceGroup.location,
storageDataLakeGen2FilesystemId: exampleDataLakeGen2Filesystem.id,
sqlAdministratorLogin: "sqladminuser",
sqlAdministratorLoginPassword: "H@Sh1CoR3!",
identity: {
type: "SystemAssigned",
},
});
const exampleSqlPool = new azure.synapse.SqlPool("exampleSqlPool", {
synapseWorkspaceId: exampleWorkspace.id,
skuName: "DW100c",
createMode: "Default",
});
const exampleSqlPoolWorkloadGroup = new azure.synapse.SqlPoolWorkloadGroup("exampleSqlPoolWorkloadGroup", {
sqlPoolId: exampleSqlPool.id,
importance: "normal",
maxResourcePercent: 100,
minResourcePercent: 0,
maxResourcePercentPerRequest: 3,
minResourcePercentPerRequest: 3,
queryExecutionTimeoutInSeconds: 0,
});
resources:
exampleResourceGroup:
type: azure:core:ResourceGroup
properties:
location: west europe
exampleAccount:
type: azure:storage:Account
properties:
resourceGroupName: ${exampleResourceGroup.name}
location: ${exampleResourceGroup.location}
accountKind: BlobStorage
accountTier: Standard
accountReplicationType: LRS
exampleDataLakeGen2Filesystem:
type: azure:storage:DataLakeGen2Filesystem
properties:
storageAccountId: ${exampleAccount.id}
exampleWorkspace:
type: azure:synapse:Workspace
properties:
resourceGroupName: ${exampleResourceGroup.name}
location: ${exampleResourceGroup.location}
storageDataLakeGen2FilesystemId: ${exampleDataLakeGen2Filesystem.id}
sqlAdministratorLogin: sqladminuser
sqlAdministratorLoginPassword: H@Sh1CoR3!
identity:
type: SystemAssigned
exampleSqlPool:
type: azure:synapse:SqlPool
properties:
synapseWorkspaceId: ${exampleWorkspace.id}
skuName: DW100c
createMode: Default
exampleSqlPoolWorkloadGroup:
type: azure:synapse:SqlPoolWorkloadGroup
properties:
sqlPoolId: ${exampleSqlPool.id}
importance: normal
maxResourcePercent: 100
minResourcePercent: 0
maxResourcePercentPerRequest: 3
minResourcePercentPerRequest: 3
queryExecutionTimeoutInSeconds: 0
Create SqlPoolWorkloadGroup Resource
new SqlPoolWorkloadGroup(name: string, args: SqlPoolWorkloadGroupArgs, opts?: CustomResourceOptions);@overload
def SqlPoolWorkloadGroup(resource_name: str,
opts: Optional[ResourceOptions] = 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,
name: Optional[str] = None,
query_execution_timeout_in_seconds: Optional[int] = None,
sql_pool_id: Optional[str] = None)
@overload
def SqlPoolWorkloadGroup(resource_name: str,
args: SqlPoolWorkloadGroupArgs,
opts: Optional[ResourceOptions] = None)func NewSqlPoolWorkloadGroup(ctx *Context, name string, args SqlPoolWorkloadGroupArgs, opts ...ResourceOption) (*SqlPoolWorkloadGroup, error)public SqlPoolWorkloadGroup(string name, SqlPoolWorkloadGroupArgs args, CustomResourceOptions? opts = null)
public SqlPoolWorkloadGroup(String name, SqlPoolWorkloadGroupArgs args)
public SqlPoolWorkloadGroup(String name, SqlPoolWorkloadGroupArgs args, CustomResourceOptions options)
type: azure:synapse:SqlPoolWorkloadGroup
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args SqlPoolWorkloadGroupArgs
- 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 SqlPoolWorkloadGroupArgs
- 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 SqlPoolWorkloadGroupArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args SqlPoolWorkloadGroupArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args SqlPoolWorkloadGroupArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
SqlPoolWorkloadGroup 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 SqlPoolWorkloadGroup resource accepts the following input properties:
- Max
Resource intPercent The workload group cap percentage resource.
- Min
Resource intPercent The workload group minimum percentage resource.
- Sql
Pool stringId The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- Importance string
The workload group importance level. Defaults to
normal.- Max
Resource doublePercent Per Request The workload group request maximum grant percentage. Defaults to
3.- Min
Resource doublePercent Per Request The workload group request minimum grant percentage.
- Name string
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- Query
Execution intTimeout In Seconds The workload group query execution timeout.
- Max
Resource intPercent The workload group cap percentage resource.
- Min
Resource intPercent The workload group minimum percentage resource.
- Sql
Pool stringId The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- Importance string
The workload group importance level. Defaults to
normal.- Max
Resource float64Percent Per Request The workload group request maximum grant percentage. Defaults to
3.- Min
Resource float64Percent Per Request The workload group request minimum grant percentage.
- Name string
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- Query
Execution intTimeout In Seconds The workload group query execution timeout.
- max
Resource IntegerPercent The workload group cap percentage resource.
- min
Resource IntegerPercent The workload group minimum percentage resource.
- sql
Pool StringId The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- importance String
The workload group importance level. Defaults to
normal.- max
Resource DoublePercent Per Request The workload group request maximum grant percentage. Defaults to
3.- min
Resource DoublePercent Per Request The workload group request minimum grant percentage.
- name String
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- query
Execution IntegerTimeout In Seconds The workload group query execution timeout.
- max
Resource numberPercent The workload group cap percentage resource.
- min
Resource numberPercent The workload group minimum percentage resource.
- sql
Pool stringId The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- importance string
The workload group importance level. Defaults to
normal.- max
Resource numberPercent Per Request The workload group request maximum grant percentage. Defaults to
3.- min
Resource numberPercent Per Request The workload group request minimum grant percentage.
- name string
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- query
Execution numberTimeout In Seconds The workload group query execution timeout.
- max_
resource_ intpercent The workload group cap percentage resource.
- min_
resource_ intpercent The workload group minimum percentage resource.
- sql_
pool_ strid The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- importance str
The workload group importance level. Defaults to
normal.- max_
resource_ floatpercent_ per_ request The workload group request maximum grant percentage. Defaults to
3.- min_
resource_ floatpercent_ per_ request The workload group request minimum grant percentage.
- name str
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- query_
execution_ inttimeout_ in_ seconds The workload group query execution timeout.
- max
Resource NumberPercent The workload group cap percentage resource.
- min
Resource NumberPercent The workload group minimum percentage resource.
- sql
Pool StringId The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- importance String
The workload group importance level. Defaults to
normal.- max
Resource NumberPercent Per Request The workload group request maximum grant percentage. Defaults to
3.- min
Resource NumberPercent Per Request The workload group request minimum grant percentage.
- name String
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- query
Execution NumberTimeout In Seconds The workload group query execution timeout.
Outputs
All input properties are implicitly available as output properties. Additionally, the SqlPoolWorkloadGroup resource produces the following output properties:
- Id string
The provider-assigned unique ID for this managed resource.
- Id string
The provider-assigned unique ID for this managed resource.
- id String
The provider-assigned unique ID for this managed resource.
- id string
The provider-assigned unique ID for this managed resource.
- id str
The provider-assigned unique ID for this managed resource.
- id String
The provider-assigned unique ID for this managed resource.
Look up Existing SqlPoolWorkloadGroup Resource
Get an existing SqlPoolWorkloadGroup resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: SqlPoolWorkloadGroupState, opts?: CustomResourceOptions): SqlPoolWorkloadGroup@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = 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,
name: Optional[str] = None,
query_execution_timeout_in_seconds: Optional[int] = None,
sql_pool_id: Optional[str] = None) -> SqlPoolWorkloadGroupfunc GetSqlPoolWorkloadGroup(ctx *Context, name string, id IDInput, state *SqlPoolWorkloadGroupState, opts ...ResourceOption) (*SqlPoolWorkloadGroup, error)public static SqlPoolWorkloadGroup Get(string name, Input<string> id, SqlPoolWorkloadGroupState? state, CustomResourceOptions? opts = null)public static SqlPoolWorkloadGroup get(String name, Output<String> id, SqlPoolWorkloadGroupState state, CustomResourceOptions options)Resource lookup is not supported in YAML- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Importance string
The workload group importance level. Defaults to
normal.- Max
Resource intPercent The workload group cap percentage resource.
- Max
Resource doublePercent Per Request The workload group request maximum grant percentage. Defaults to
3.- Min
Resource intPercent The workload group minimum percentage resource.
- Min
Resource doublePercent Per Request The workload group request minimum grant percentage.
- Name string
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- Query
Execution intTimeout In Seconds The workload group query execution timeout.
- Sql
Pool stringId The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- Importance string
The workload group importance level. Defaults to
normal.- Max
Resource intPercent The workload group cap percentage resource.
- Max
Resource float64Percent Per Request The workload group request maximum grant percentage. Defaults to
3.- Min
Resource intPercent The workload group minimum percentage resource.
- Min
Resource float64Percent Per Request The workload group request minimum grant percentage.
- Name string
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- Query
Execution intTimeout In Seconds The workload group query execution timeout.
- Sql
Pool stringId The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- importance String
The workload group importance level. Defaults to
normal.- max
Resource IntegerPercent The workload group cap percentage resource.
- max
Resource DoublePercent Per Request The workload group request maximum grant percentage. Defaults to
3.- min
Resource IntegerPercent The workload group minimum percentage resource.
- min
Resource DoublePercent Per Request The workload group request minimum grant percentage.
- name String
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- query
Execution IntegerTimeout In Seconds The workload group query execution timeout.
- sql
Pool StringId The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- importance string
The workload group importance level. Defaults to
normal.- max
Resource numberPercent The workload group cap percentage resource.
- max
Resource numberPercent Per Request The workload group request maximum grant percentage. Defaults to
3.- min
Resource numberPercent The workload group minimum percentage resource.
- min
Resource numberPercent Per Request The workload group request minimum grant percentage.
- name string
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- query
Execution numberTimeout In Seconds The workload group query execution timeout.
- sql
Pool stringId The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- importance str
The workload group importance level. Defaults to
normal.- max_
resource_ intpercent The workload group cap percentage resource.
- max_
resource_ floatpercent_ per_ request The workload group request maximum grant percentage. Defaults to
3.- min_
resource_ intpercent The workload group minimum percentage resource.
- min_
resource_ floatpercent_ per_ request The workload group request minimum grant percentage.
- name str
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- query_
execution_ inttimeout_ in_ seconds The workload group query execution timeout.
- sql_
pool_ strid The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- importance String
The workload group importance level. Defaults to
normal.- max
Resource NumberPercent The workload group cap percentage resource.
- max
Resource NumberPercent Per Request The workload group request maximum grant percentage. Defaults to
3.- min
Resource NumberPercent The workload group minimum percentage resource.
- min
Resource NumberPercent Per Request The workload group request minimum grant percentage.
- name String
The name which should be used for this Synapse SQL Pool Workload Group. Changing this forces a new Synapse SQL Pool Workload Group to be created.
- query
Execution NumberTimeout In Seconds The workload group query execution timeout.
- sql
Pool StringId The ID of the Synapse SQL Pool. Changing this forces a new Synapse SQL Pool Workload Group to be created.
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
Package Details
- Repository
- Azure Classic pulumi/pulumi-azure
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
azurermTerraform Provider.