pulumi-azure-native-kotlin/com.pulumi.azurenative.sql.kotlin/InstancePool

InstancePool

class InstancePool : KotlinCustomResource

An Azure SQL instance pool. Uses Azure REST API version 2023-08-01. In version 2.x of the Azure Native provider, it used API version 2021-11-01. Other available API versions: 2018-06-01-preview, 2020-02-02-preview, 2020-08-01-preview, 2020-11-01-preview, 2021-02-01-preview, 2021-05-01-preview, 2021-08-01-preview, 2021-11-01, 2021-11-01-preview, 2022-02-01-preview, 2022-05-01-preview, 2022-08-01-preview, 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01-preview, 2024-05-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native sql [ApiVersion]. See the ../../../version-guide/#accessing-any-api-version-via-local-packages for details.

Example Usage

Create an instance pool with all properties.

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var instancePool = new AzureNative.Sql.InstancePool("instancePool", new()
    {
        InstancePoolName = "testIP",
        LicenseType = AzureNative.Sql.InstancePoolLicenseType.LicenseIncluded,
        Location = "japaneast",
        MaintenanceConfigurationId = "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_MI_1",
        ResourceGroupName = "group1",
        Sku = new AzureNative.Sql.Inputs.SkuArgs
        {
            Family = "Gen5",
            Name = "GP_Gen5",
            Tier = "GeneralPurpose",
        },
        SubnetId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Network/virtualNetworks/myvnet/subnets/mysubnet1",
        Tags =
        {
            { "a", "b" },
        },
        VCores = 8,
    });
});

package main
import (
	sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewInstancePool(ctx, "instancePool", &sql.InstancePoolArgs{
			InstancePoolName:           pulumi.String("testIP"),
			LicenseType:                pulumi.String(sql.InstancePoolLicenseTypeLicenseIncluded),
			Location:                   pulumi.String("japaneast"),
			MaintenanceConfigurationId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_MI_1"),
			ResourceGroupName:          pulumi.String("group1"),
			Sku: &sql.SkuArgs{
				Family: pulumi.String("Gen5"),
				Name:   pulumi.String("GP_Gen5"),
				Tier:   pulumi.String("GeneralPurpose"),
			},
			SubnetId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Network/virtualNetworks/myvnet/subnets/mysubnet1"),
			Tags: pulumi.StringMap{
				"a": pulumi.String("b"),
			},
			VCores: pulumi.Int(8),
		})
		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.InstancePool;
import com.pulumi.azurenative.sql.InstancePoolArgs;
import com.pulumi.azurenative.sql.inputs.SkuArgs;
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 instancePool = new InstancePool("instancePool", InstancePoolArgs.builder()
            .instancePoolName("testIP")
            .licenseType("LicenseIncluded")
            .location("japaneast")
            .maintenanceConfigurationId("/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_MI_1")
            .resourceGroupName("group1")
            .sku(SkuArgs.builder()
                .family("Gen5")
                .name("GP_Gen5")
                .tier("GeneralPurpose")
                .build())
            .subnetId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Network/virtualNetworks/myvnet/subnets/mysubnet1")
            .tags(Map.of("a", "b"))
            .vCores(8)
            .build());
    }
}

Create an instance pool with min properties.

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var instancePool = new AzureNative.Sql.InstancePool("instancePool", new()
    {
        InstancePoolName = "testIP",
        LicenseType = AzureNative.Sql.InstancePoolLicenseType.LicenseIncluded,
        Location = "japaneast",
        ResourceGroupName = "group1",
        Sku = new AzureNative.Sql.Inputs.SkuArgs
        {
            Family = "Gen5",
            Name = "GP_Gen5",
            Tier = "GeneralPurpose",
        },
        SubnetId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Network/virtualNetworks/myvnet/subnets/mysubnet1",
        VCores = 8,
    });
});

package main
import (
	sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewInstancePool(ctx, "instancePool", &sql.InstancePoolArgs{
			InstancePoolName:  pulumi.String("testIP"),
			LicenseType:       pulumi.String(sql.InstancePoolLicenseTypeLicenseIncluded),
			Location:          pulumi.String("japaneast"),
			ResourceGroupName: pulumi.String("group1"),
			Sku: &sql.SkuArgs{
				Family: pulumi.String("Gen5"),
				Name:   pulumi.String("GP_Gen5"),
				Tier:   pulumi.String("GeneralPurpose"),
			},
			SubnetId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Network/virtualNetworks/myvnet/subnets/mysubnet1"),
			VCores:   pulumi.Int(8),
		})
		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.InstancePool;
import com.pulumi.azurenative.sql.InstancePoolArgs;
import com.pulumi.azurenative.sql.inputs.SkuArgs;
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 instancePool = new InstancePool("instancePool", InstancePoolArgs.builder()
            .instancePoolName("testIP")
            .licenseType("LicenseIncluded")
            .location("japaneast")
            .resourceGroupName("group1")
            .sku(SkuArgs.builder()
                .family("Gen5")
                .name("GP_Gen5")
                .tier("GeneralPurpose")
                .build())
            .subnetId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Network/virtualNetworks/myvnet/subnets/mysubnet1")
            .vCores(8)
            .build());
    }
}

Import

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

$ pulumi import azure-native:sql:InstancePool testIP /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/instancePools/{instancePoolName}