Instance Pool Args
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/v3"
"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/v3"
"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}
Constructors
Properties
The name of the instance pool to be created or updated.
The license type. Possible values are 'LicenseIncluded' (price for SQL license is included) and 'BasePrice' (without SQL license price).
Specifies maintenance configuration id to apply to this managed instance.
The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.