1. Packages
  2. Azure Native
  3. API Docs
  4. sql
  5. ElasticPool
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.47.1 published on Monday, Jun 24, 2024 by Pulumi

azure-native.sql.ElasticPool

Explore with Pulumi AI

azure-native logo
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.47.1 published on Monday, Jun 24, 2024 by Pulumi

    An elastic pool. Azure REST API version: 2021-11-01. Prior API version in Azure Native 1.x: 2020-11-01-preview.

    Other available API versions: 2014-04-01, 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01-preview.

    Example Usage

    Create or update Hyperscale elastic pool with high availability replica count parameter

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AzureNative = Pulumi.AzureNative;
    
    return await Deployment.RunAsync(() => 
    {
        var elasticPool = new AzureNative.Sql.ElasticPool("elasticPool", new()
        {
            ElasticPoolName = "sqlcrudtest-8102",
            HighAvailabilityReplicaCount = 2,
            Location = "Japan East",
            ResourceGroupName = "sqlcrudtest-2369",
            ServerName = "sqlcrudtest-8069",
            Sku = new AzureNative.Sql.Inputs.SkuArgs
            {
                Name = "HS_Gen5_4",
            },
        });
    
    });
    
    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.NewElasticPool(ctx, "elasticPool", &sql.ElasticPoolArgs{
    			ElasticPoolName:              pulumi.String("sqlcrudtest-8102"),
    			HighAvailabilityReplicaCount: pulumi.Int(2),
    			Location:                     pulumi.String("Japan East"),
    			ResourceGroupName:            pulumi.String("sqlcrudtest-2369"),
    			ServerName:                   pulumi.String("sqlcrudtest-8069"),
    			Sku: &sql.SkuArgs{
    				Name: pulumi.String("HS_Gen5_4"),
    			},
    		})
    		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.ElasticPool;
    import com.pulumi.azurenative.sql.ElasticPoolArgs;
    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 elasticPool = new ElasticPool("elasticPool", ElasticPoolArgs.builder()
                .elasticPoolName("sqlcrudtest-8102")
                .highAvailabilityReplicaCount(2)
                .location("Japan East")
                .resourceGroupName("sqlcrudtest-2369")
                .serverName("sqlcrudtest-8069")
                .sku(SkuArgs.builder()
                    .name("HS_Gen5_4")
                    .build())
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure_native as azure_native
    
    elastic_pool = azure_native.sql.ElasticPool("elasticPool",
        elastic_pool_name="sqlcrudtest-8102",
        high_availability_replica_count=2,
        location="Japan East",
        resource_group_name="sqlcrudtest-2369",
        server_name="sqlcrudtest-8069",
        sku=azure_native.sql.SkuArgs(
            name="HS_Gen5_4",
        ))
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure_native from "@pulumi/azure-native";
    
    const elasticPool = new azure_native.sql.ElasticPool("elasticPool", {
        elasticPoolName: "sqlcrudtest-8102",
        highAvailabilityReplicaCount: 2,
        location: "Japan East",
        resourceGroupName: "sqlcrudtest-2369",
        serverName: "sqlcrudtest-8069",
        sku: {
            name: "HS_Gen5_4",
        },
    });
    
    resources:
      elasticPool:
        type: azure-native:sql:ElasticPool
        properties:
          elasticPoolName: sqlcrudtest-8102
          highAvailabilityReplicaCount: 2
          location: Japan East
          resourceGroupName: sqlcrudtest-2369
          serverName: sqlcrudtest-8069
          sku:
            name: HS_Gen5_4
    

    Create or update elastic pool with all parameter

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AzureNative = Pulumi.AzureNative;
    
    return await Deployment.RunAsync(() => 
    {
        var elasticPool = new AzureNative.Sql.ElasticPool("elasticPool", new()
        {
            ElasticPoolName = "sqlcrudtest-8102",
            Location = "Japan East",
            PerDatabaseSettings = new AzureNative.Sql.Inputs.ElasticPoolPerDatabaseSettingsArgs
            {
                MaxCapacity = 2,
                MinCapacity = 0.25,
            },
            ResourceGroupName = "sqlcrudtest-2369",
            ServerName = "sqlcrudtest-8069",
            Sku = new AzureNative.Sql.Inputs.SkuArgs
            {
                Capacity = 2,
                Name = "GP_Gen4_2",
                Tier = "GeneralPurpose",
            },
        });
    
    });
    
    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.NewElasticPool(ctx, "elasticPool", &sql.ElasticPoolArgs{
    			ElasticPoolName: pulumi.String("sqlcrudtest-8102"),
    			Location:        pulumi.String("Japan East"),
    			PerDatabaseSettings: &sql.ElasticPoolPerDatabaseSettingsArgs{
    				MaxCapacity: pulumi.Float64(2),
    				MinCapacity: pulumi.Float64(0.25),
    			},
    			ResourceGroupName: pulumi.String("sqlcrudtest-2369"),
    			ServerName:        pulumi.String("sqlcrudtest-8069"),
    			Sku: &sql.SkuArgs{
    				Capacity: pulumi.Int(2),
    				Name:     pulumi.String("GP_Gen4_2"),
    				Tier:     pulumi.String("GeneralPurpose"),
    			},
    		})
    		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.ElasticPool;
    import com.pulumi.azurenative.sql.ElasticPoolArgs;
    import com.pulumi.azurenative.sql.inputs.ElasticPoolPerDatabaseSettingsArgs;
    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 elasticPool = new ElasticPool("elasticPool", ElasticPoolArgs.builder()
                .elasticPoolName("sqlcrudtest-8102")
                .location("Japan East")
                .perDatabaseSettings(ElasticPoolPerDatabaseSettingsArgs.builder()
                    .maxCapacity(2)
                    .minCapacity(0.25)
                    .build())
                .resourceGroupName("sqlcrudtest-2369")
                .serverName("sqlcrudtest-8069")
                .sku(SkuArgs.builder()
                    .capacity(2)
                    .name("GP_Gen4_2")
                    .tier("GeneralPurpose")
                    .build())
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure_native as azure_native
    
    elastic_pool = azure_native.sql.ElasticPool("elasticPool",
        elastic_pool_name="sqlcrudtest-8102",
        location="Japan East",
        per_database_settings=azure_native.sql.ElasticPoolPerDatabaseSettingsArgs(
            max_capacity=2,
            min_capacity=0.25,
        ),
        resource_group_name="sqlcrudtest-2369",
        server_name="sqlcrudtest-8069",
        sku=azure_native.sql.SkuArgs(
            capacity=2,
            name="GP_Gen4_2",
            tier="GeneralPurpose",
        ))
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure_native from "@pulumi/azure-native";
    
    const elasticPool = new azure_native.sql.ElasticPool("elasticPool", {
        elasticPoolName: "sqlcrudtest-8102",
        location: "Japan East",
        perDatabaseSettings: {
            maxCapacity: 2,
            minCapacity: 0.25,
        },
        resourceGroupName: "sqlcrudtest-2369",
        serverName: "sqlcrudtest-8069",
        sku: {
            capacity: 2,
            name: "GP_Gen4_2",
            tier: "GeneralPurpose",
        },
    });
    
    resources:
      elasticPool:
        type: azure-native:sql:ElasticPool
        properties:
          elasticPoolName: sqlcrudtest-8102
          location: Japan East
          perDatabaseSettings:
            maxCapacity: 2
            minCapacity: 0.25
          resourceGroupName: sqlcrudtest-2369
          serverName: sqlcrudtest-8069
          sku:
            capacity: 2
            name: GP_Gen4_2
            tier: GeneralPurpose
    

    Create or update elastic pool with maintenance configuration parameter

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AzureNative = Pulumi.AzureNative;
    
    return await Deployment.RunAsync(() => 
    {
        var elasticPool = new AzureNative.Sql.ElasticPool("elasticPool", new()
        {
            ElasticPoolName = "sqlcrudtest-8102",
            Location = "Japan East",
            MaintenanceConfigurationId = "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1",
            ResourceGroupName = "sqlcrudtest-2369",
            ServerName = "sqlcrudtest-8069",
        });
    
    });
    
    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.NewElasticPool(ctx, "elasticPool", &sql.ElasticPoolArgs{
    			ElasticPoolName:            pulumi.String("sqlcrudtest-8102"),
    			Location:                   pulumi.String("Japan East"),
    			MaintenanceConfigurationId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1"),
    			ResourceGroupName:          pulumi.String("sqlcrudtest-2369"),
    			ServerName:                 pulumi.String("sqlcrudtest-8069"),
    		})
    		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.ElasticPool;
    import com.pulumi.azurenative.sql.ElasticPoolArgs;
    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 elasticPool = new ElasticPool("elasticPool", ElasticPoolArgs.builder()
                .elasticPoolName("sqlcrudtest-8102")
                .location("Japan East")
                .maintenanceConfigurationId("/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1")
                .resourceGroupName("sqlcrudtest-2369")
                .serverName("sqlcrudtest-8069")
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure_native as azure_native
    
    elastic_pool = azure_native.sql.ElasticPool("elasticPool",
        elastic_pool_name="sqlcrudtest-8102",
        location="Japan East",
        maintenance_configuration_id="/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1",
        resource_group_name="sqlcrudtest-2369",
        server_name="sqlcrudtest-8069")
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure_native from "@pulumi/azure-native";
    
    const elasticPool = new azure_native.sql.ElasticPool("elasticPool", {
        elasticPoolName: "sqlcrudtest-8102",
        location: "Japan East",
        maintenanceConfigurationId: "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1",
        resourceGroupName: "sqlcrudtest-2369",
        serverName: "sqlcrudtest-8069",
    });
    
    resources:
      elasticPool:
        type: azure-native:sql:ElasticPool
        properties:
          elasticPoolName: sqlcrudtest-8102
          location: Japan East
          maintenanceConfigurationId: /subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1
          resourceGroupName: sqlcrudtest-2369
          serverName: sqlcrudtest-8069
    

    Create or update elastic pool with minimum parameters

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AzureNative = Pulumi.AzureNative;
    
    return await Deployment.RunAsync(() => 
    {
        var elasticPool = new AzureNative.Sql.ElasticPool("elasticPool", new()
        {
            ElasticPoolName = "sqlcrudtest-8102",
            Location = "Japan East",
            ResourceGroupName = "sqlcrudtest-2369",
            ServerName = "sqlcrudtest-8069",
        });
    
    });
    
    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.NewElasticPool(ctx, "elasticPool", &sql.ElasticPoolArgs{
    			ElasticPoolName:   pulumi.String("sqlcrudtest-8102"),
    			Location:          pulumi.String("Japan East"),
    			ResourceGroupName: pulumi.String("sqlcrudtest-2369"),
    			ServerName:        pulumi.String("sqlcrudtest-8069"),
    		})
    		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.ElasticPool;
    import com.pulumi.azurenative.sql.ElasticPoolArgs;
    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 elasticPool = new ElasticPool("elasticPool", ElasticPoolArgs.builder()
                .elasticPoolName("sqlcrudtest-8102")
                .location("Japan East")
                .resourceGroupName("sqlcrudtest-2369")
                .serverName("sqlcrudtest-8069")
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure_native as azure_native
    
    elastic_pool = azure_native.sql.ElasticPool("elasticPool",
        elastic_pool_name="sqlcrudtest-8102",
        location="Japan East",
        resource_group_name="sqlcrudtest-2369",
        server_name="sqlcrudtest-8069")
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure_native from "@pulumi/azure-native";
    
    const elasticPool = new azure_native.sql.ElasticPool("elasticPool", {
        elasticPoolName: "sqlcrudtest-8102",
        location: "Japan East",
        resourceGroupName: "sqlcrudtest-2369",
        serverName: "sqlcrudtest-8069",
    });
    
    resources:
      elasticPool:
        type: azure-native:sql:ElasticPool
        properties:
          elasticPoolName: sqlcrudtest-8102
          location: Japan East
          resourceGroupName: sqlcrudtest-2369
          serverName: sqlcrudtest-8069
    

    Create ElasticPool Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new ElasticPool(name: string, args: ElasticPoolArgs, opts?: CustomResourceOptions);
    @overload
    def ElasticPool(resource_name: str,
                    args: ElasticPoolArgs,
                    opts: Optional[ResourceOptions] = None)
    
    @overload
    def ElasticPool(resource_name: str,
                    opts: Optional[ResourceOptions] = None,
                    resource_group_name: Optional[str] = None,
                    server_name: Optional[str] = None,
                    location: Optional[str] = None,
                    elastic_pool_name: Optional[str] = None,
                    maintenance_configuration_id: Optional[str] = None,
                    max_size_bytes: Optional[float] = None,
                    min_capacity: Optional[float] = None,
                    per_database_settings: Optional[ElasticPoolPerDatabaseSettingsArgs] = None,
                    license_type: Optional[Union[str, ElasticPoolLicenseType]] = None,
                    high_availability_replica_count: Optional[int] = None,
                    sku: Optional[SkuArgs] = None,
                    tags: Optional[Mapping[str, str]] = None,
                    zone_redundant: Optional[bool] = None)
    func NewElasticPool(ctx *Context, name string, args ElasticPoolArgs, opts ...ResourceOption) (*ElasticPool, error)
    public ElasticPool(string name, ElasticPoolArgs args, CustomResourceOptions? opts = null)
    public ElasticPool(String name, ElasticPoolArgs args)
    public ElasticPool(String name, ElasticPoolArgs args, CustomResourceOptions options)
    
    type: azure-native:sql:ElasticPool
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    

    Parameters

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

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var elasticPoolResource = new AzureNative.Sql.ElasticPool("elasticPoolResource", new()
    {
        ResourceGroupName = "string",
        ServerName = "string",
        Location = "string",
        ElasticPoolName = "string",
        MaintenanceConfigurationId = "string",
        MaxSizeBytes = 0,
        MinCapacity = 0,
        PerDatabaseSettings = new AzureNative.Sql.Inputs.ElasticPoolPerDatabaseSettingsArgs
        {
            MaxCapacity = 0,
            MinCapacity = 0,
        },
        LicenseType = "string",
        HighAvailabilityReplicaCount = 0,
        Sku = new AzureNative.Sql.Inputs.SkuArgs
        {
            Name = "string",
            Capacity = 0,
            Family = "string",
            Size = "string",
            Tier = "string",
        },
        Tags = 
        {
            { "string", "string" },
        },
        ZoneRedundant = false,
    });
    
    example, err := sql.NewElasticPool(ctx, "elasticPoolResource", &sql.ElasticPoolArgs{
    ResourceGroupName: pulumi.String("string"),
    ServerName: pulumi.String("string"),
    Location: pulumi.String("string"),
    ElasticPoolName: pulumi.String("string"),
    MaintenanceConfigurationId: pulumi.String("string"),
    MaxSizeBytes: pulumi.Float64(0),
    MinCapacity: pulumi.Float64(0),
    PerDatabaseSettings: &sql.ElasticPoolPerDatabaseSettingsArgs{
    MaxCapacity: pulumi.Float64(0),
    MinCapacity: pulumi.Float64(0),
    },
    LicenseType: pulumi.String("string"),
    HighAvailabilityReplicaCount: pulumi.Int(0),
    Sku: &sql.SkuArgs{
    Name: pulumi.String("string"),
    Capacity: pulumi.Int(0),
    Family: pulumi.String("string"),
    Size: pulumi.String("string"),
    Tier: pulumi.String("string"),
    },
    Tags: pulumi.StringMap{
    "string": pulumi.String("string"),
    },
    ZoneRedundant: pulumi.Bool(false),
    })
    
    var elasticPoolResource = new ElasticPool("elasticPoolResource", ElasticPoolArgs.builder()
        .resourceGroupName("string")
        .serverName("string")
        .location("string")
        .elasticPoolName("string")
        .maintenanceConfigurationId("string")
        .maxSizeBytes(0)
        .minCapacity(0)
        .perDatabaseSettings(ElasticPoolPerDatabaseSettingsArgs.builder()
            .maxCapacity(0)
            .minCapacity(0)
            .build())
        .licenseType("string")
        .highAvailabilityReplicaCount(0)
        .sku(SkuArgs.builder()
            .name("string")
            .capacity(0)
            .family("string")
            .size("string")
            .tier("string")
            .build())
        .tags(Map.of("string", "string"))
        .zoneRedundant(false)
        .build());
    
    elastic_pool_resource = azure_native.sql.ElasticPool("elasticPoolResource",
        resource_group_name="string",
        server_name="string",
        location="string",
        elastic_pool_name="string",
        maintenance_configuration_id="string",
        max_size_bytes=0,
        min_capacity=0,
        per_database_settings=azure_native.sql.ElasticPoolPerDatabaseSettingsArgs(
            max_capacity=0,
            min_capacity=0,
        ),
        license_type="string",
        high_availability_replica_count=0,
        sku=azure_native.sql.SkuArgs(
            name="string",
            capacity=0,
            family="string",
            size="string",
            tier="string",
        ),
        tags={
            "string": "string",
        },
        zone_redundant=False)
    
    const elasticPoolResource = new azure_native.sql.ElasticPool("elasticPoolResource", {
        resourceGroupName: "string",
        serverName: "string",
        location: "string",
        elasticPoolName: "string",
        maintenanceConfigurationId: "string",
        maxSizeBytes: 0,
        minCapacity: 0,
        perDatabaseSettings: {
            maxCapacity: 0,
            minCapacity: 0,
        },
        licenseType: "string",
        highAvailabilityReplicaCount: 0,
        sku: {
            name: "string",
            capacity: 0,
            family: "string",
            size: "string",
            tier: "string",
        },
        tags: {
            string: "string",
        },
        zoneRedundant: false,
    });
    
    type: azure-native:sql:ElasticPool
    properties:
        elasticPoolName: string
        highAvailabilityReplicaCount: 0
        licenseType: string
        location: string
        maintenanceConfigurationId: string
        maxSizeBytes: 0
        minCapacity: 0
        perDatabaseSettings:
            maxCapacity: 0
            minCapacity: 0
        resourceGroupName: string
        serverName: string
        sku:
            capacity: 0
            family: string
            name: string
            size: string
            tier: string
        tags:
            string: string
        zoneRedundant: false
    

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

    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.
    ElasticPoolName string
    The name of the elastic pool.
    HighAvailabilityReplicaCount int
    The number of secondary replicas associated with the elastic pool that are used to provide high availability. Applicable only to Hyperscale elastic pools.
    LicenseType string | Pulumi.AzureNative.Sql.ElasticPoolLicenseType
    The license type to apply for this elastic pool.
    Location string
    Resource location.
    MaintenanceConfigurationId string
    Maintenance configuration id assigned to the elastic pool. This configuration defines the period when the maintenance updates will will occur.
    MaxSizeBytes double
    The storage limit for the database elastic pool in bytes.
    MinCapacity double
    Minimal capacity that serverless pool will not shrink below, if not paused
    PerDatabaseSettings Pulumi.AzureNative.Sql.Inputs.ElasticPoolPerDatabaseSettings
    The per database settings for the elastic pool.
    Sku Pulumi.AzureNative.Sql.Inputs.Sku

    The elastic pool SKU.

    The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or the following command:

    az sql elastic-pool list-editions -l <location> -o table
    
    Tags Dictionary<string, string>
    Resource tags.
    ZoneRedundant bool
    Whether or not this elastic pool is zone redundant, which means the replicas of this elastic pool will be spread across multiple availability zones.
    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.
    ElasticPoolName string
    The name of the elastic pool.
    HighAvailabilityReplicaCount int
    The number of secondary replicas associated with the elastic pool that are used to provide high availability. Applicable only to Hyperscale elastic pools.
    LicenseType string | ElasticPoolLicenseType
    The license type to apply for this elastic pool.
    Location string
    Resource location.
    MaintenanceConfigurationId string
    Maintenance configuration id assigned to the elastic pool. This configuration defines the period when the maintenance updates will will occur.
    MaxSizeBytes float64
    The storage limit for the database elastic pool in bytes.
    MinCapacity float64
    Minimal capacity that serverless pool will not shrink below, if not paused
    PerDatabaseSettings ElasticPoolPerDatabaseSettingsArgs
    The per database settings for the elastic pool.
    Sku SkuArgs

    The elastic pool SKU.

    The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or the following command:

    az sql elastic-pool list-editions -l <location> -o table
    
    Tags map[string]string
    Resource tags.
    ZoneRedundant bool
    Whether or not this elastic pool is zone redundant, which means the replicas of this elastic pool will be spread across multiple availability zones.
    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.
    elasticPoolName String
    The name of the elastic pool.
    highAvailabilityReplicaCount Integer
    The number of secondary replicas associated with the elastic pool that are used to provide high availability. Applicable only to Hyperscale elastic pools.
    licenseType String | ElasticPoolLicenseType
    The license type to apply for this elastic pool.
    location String
    Resource location.
    maintenanceConfigurationId String
    Maintenance configuration id assigned to the elastic pool. This configuration defines the period when the maintenance updates will will occur.
    maxSizeBytes Double
    The storage limit for the database elastic pool in bytes.
    minCapacity Double
    Minimal capacity that serverless pool will not shrink below, if not paused
    perDatabaseSettings ElasticPoolPerDatabaseSettings
    The per database settings for the elastic pool.
    sku Sku

    The elastic pool SKU.

    The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or the following command:

    az sql elastic-pool list-editions -l <location> -o table
    
    tags Map<String,String>
    Resource tags.
    zoneRedundant Boolean
    Whether or not this elastic pool is zone redundant, which means the replicas of this elastic pool will be spread across multiple availability zones.
    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.
    elasticPoolName string
    The name of the elastic pool.
    highAvailabilityReplicaCount number
    The number of secondary replicas associated with the elastic pool that are used to provide high availability. Applicable only to Hyperscale elastic pools.
    licenseType string | ElasticPoolLicenseType
    The license type to apply for this elastic pool.
    location string
    Resource location.
    maintenanceConfigurationId string
    Maintenance configuration id assigned to the elastic pool. This configuration defines the period when the maintenance updates will will occur.
    maxSizeBytes number
    The storage limit for the database elastic pool in bytes.
    minCapacity number
    Minimal capacity that serverless pool will not shrink below, if not paused
    perDatabaseSettings ElasticPoolPerDatabaseSettings
    The per database settings for the elastic pool.
    sku Sku

    The elastic pool SKU.

    The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or the following command:

    az sql elastic-pool list-editions -l <location> -o table
    
    tags {[key: string]: string}
    Resource tags.
    zoneRedundant boolean
    Whether or not this elastic pool is zone redundant, which means the replicas of this elastic pool will be spread across multiple availability zones.
    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.
    elastic_pool_name str
    The name of the elastic pool.
    high_availability_replica_count int
    The number of secondary replicas associated with the elastic pool that are used to provide high availability. Applicable only to Hyperscale elastic pools.
    license_type str | ElasticPoolLicenseType
    The license type to apply for this elastic pool.
    location str
    Resource location.
    maintenance_configuration_id str
    Maintenance configuration id assigned to the elastic pool. This configuration defines the period when the maintenance updates will will occur.
    max_size_bytes float
    The storage limit for the database elastic pool in bytes.
    min_capacity float
    Minimal capacity that serverless pool will not shrink below, if not paused
    per_database_settings ElasticPoolPerDatabaseSettingsArgs
    The per database settings for the elastic pool.
    sku SkuArgs

    The elastic pool SKU.

    The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or the following command:

    az sql elastic-pool list-editions -l <location> -o table
    
    tags Mapping[str, str]
    Resource tags.
    zone_redundant bool
    Whether or not this elastic pool is zone redundant, which means the replicas of this elastic pool will be spread across multiple availability zones.
    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.
    elasticPoolName String
    The name of the elastic pool.
    highAvailabilityReplicaCount Number
    The number of secondary replicas associated with the elastic pool that are used to provide high availability. Applicable only to Hyperscale elastic pools.
    licenseType String | "LicenseIncluded" | "BasePrice"
    The license type to apply for this elastic pool.
    location String
    Resource location.
    maintenanceConfigurationId String
    Maintenance configuration id assigned to the elastic pool. This configuration defines the period when the maintenance updates will will occur.
    maxSizeBytes Number
    The storage limit for the database elastic pool in bytes.
    minCapacity Number
    Minimal capacity that serverless pool will not shrink below, if not paused
    perDatabaseSettings Property Map
    The per database settings for the elastic pool.
    sku Property Map

    The elastic pool SKU.

    The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or the following command:

    az sql elastic-pool list-editions -l <location> -o table
    
    tags Map<String>
    Resource tags.
    zoneRedundant Boolean
    Whether or not this elastic pool is zone redundant, which means the replicas of this elastic pool will be spread across multiple availability zones.

    Outputs

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

    CreationDate string
    The creation date of the elastic pool (ISO8601 format).
    Id string
    The provider-assigned unique ID for this managed resource.
    Kind string
    Kind of elastic pool. This is metadata used for the Azure portal experience.
    Name string
    Resource name.
    State string
    The state of the elastic pool.
    Type string
    Resource type.
    CreationDate string
    The creation date of the elastic pool (ISO8601 format).
    Id string
    The provider-assigned unique ID for this managed resource.
    Kind string
    Kind of elastic pool. This is metadata used for the Azure portal experience.
    Name string
    Resource name.
    State string
    The state of the elastic pool.
    Type string
    Resource type.
    creationDate String
    The creation date of the elastic pool (ISO8601 format).
    id String
    The provider-assigned unique ID for this managed resource.
    kind String
    Kind of elastic pool. This is metadata used for the Azure portal experience.
    name String
    Resource name.
    state String
    The state of the elastic pool.
    type String
    Resource type.
    creationDate string
    The creation date of the elastic pool (ISO8601 format).
    id string
    The provider-assigned unique ID for this managed resource.
    kind string
    Kind of elastic pool. This is metadata used for the Azure portal experience.
    name string
    Resource name.
    state string
    The state of the elastic pool.
    type string
    Resource type.
    creation_date str
    The creation date of the elastic pool (ISO8601 format).
    id str
    The provider-assigned unique ID for this managed resource.
    kind str
    Kind of elastic pool. This is metadata used for the Azure portal experience.
    name str
    Resource name.
    state str
    The state of the elastic pool.
    type str
    Resource type.
    creationDate String
    The creation date of the elastic pool (ISO8601 format).
    id String
    The provider-assigned unique ID for this managed resource.
    kind String
    Kind of elastic pool. This is metadata used for the Azure portal experience.
    name String
    Resource name.
    state String
    The state of the elastic pool.
    type String
    Resource type.

    Supporting Types

    ElasticPoolLicenseType, ElasticPoolLicenseTypeArgs

    LicenseIncluded
    LicenseIncluded
    BasePrice
    BasePrice
    ElasticPoolLicenseTypeLicenseIncluded
    LicenseIncluded
    ElasticPoolLicenseTypeBasePrice
    BasePrice
    LicenseIncluded
    LicenseIncluded
    BasePrice
    BasePrice
    LicenseIncluded
    LicenseIncluded
    BasePrice
    BasePrice
    LICENSE_INCLUDED
    LicenseIncluded
    BASE_PRICE
    BasePrice
    "LicenseIncluded"
    LicenseIncluded
    "BasePrice"
    BasePrice

    ElasticPoolPerDatabaseSettings, ElasticPoolPerDatabaseSettingsArgs

    MaxCapacity double
    The maximum capacity any one database can consume.
    MinCapacity double
    The minimum capacity all databases are guaranteed.
    MaxCapacity float64
    The maximum capacity any one database can consume.
    MinCapacity float64
    The minimum capacity all databases are guaranteed.
    maxCapacity Double
    The maximum capacity any one database can consume.
    minCapacity Double
    The minimum capacity all databases are guaranteed.
    maxCapacity number
    The maximum capacity any one database can consume.
    minCapacity number
    The minimum capacity all databases are guaranteed.
    max_capacity float
    The maximum capacity any one database can consume.
    min_capacity float
    The minimum capacity all databases are guaranteed.
    maxCapacity Number
    The maximum capacity any one database can consume.
    minCapacity Number
    The minimum capacity all databases are guaranteed.

    ElasticPoolPerDatabaseSettingsResponse, ElasticPoolPerDatabaseSettingsResponseArgs

    MaxCapacity double
    The maximum capacity any one database can consume.
    MinCapacity double
    The minimum capacity all databases are guaranteed.
    MaxCapacity float64
    The maximum capacity any one database can consume.
    MinCapacity float64
    The minimum capacity all databases are guaranteed.
    maxCapacity Double
    The maximum capacity any one database can consume.
    minCapacity Double
    The minimum capacity all databases are guaranteed.
    maxCapacity number
    The maximum capacity any one database can consume.
    minCapacity number
    The minimum capacity all databases are guaranteed.
    max_capacity float
    The maximum capacity any one database can consume.
    min_capacity float
    The minimum capacity all databases are guaranteed.
    maxCapacity Number
    The maximum capacity any one database can consume.
    minCapacity Number
    The minimum capacity all databases are guaranteed.

    Sku, SkuArgs

    Name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    Capacity int
    Capacity of the particular SKU.
    Family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    Size string
    Size of the particular SKU
    Tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    Name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    Capacity int
    Capacity of the particular SKU.
    Family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    Size string
    Size of the particular SKU
    Tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name String
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity Integer
    Capacity of the particular SKU.
    family String
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size String
    Size of the particular SKU
    tier String
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity number
    Capacity of the particular SKU.
    family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size string
    Size of the particular SKU
    tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name str
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity int
    Capacity of the particular SKU.
    family str
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size str
    Size of the particular SKU
    tier str
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name String
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity Number
    Capacity of the particular SKU.
    family String
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size String
    Size of the particular SKU
    tier String
    The tier or edition of the particular SKU, e.g. Basic, Premium.

    SkuResponse, SkuResponseArgs

    Name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    Capacity int
    Capacity of the particular SKU.
    Family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    Size string
    Size of the particular SKU
    Tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    Name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    Capacity int
    Capacity of the particular SKU.
    Family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    Size string
    Size of the particular SKU
    Tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name String
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity Integer
    Capacity of the particular SKU.
    family String
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size String
    Size of the particular SKU
    tier String
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity number
    Capacity of the particular SKU.
    family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size string
    Size of the particular SKU
    tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name str
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity int
    Capacity of the particular SKU.
    family str
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size str
    Size of the particular SKU
    tier str
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name String
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity Number
    Capacity of the particular SKU.
    family String
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size String
    Size of the particular SKU
    tier String
    The tier or edition of the particular SKU, e.g. Basic, Premium.

    Import

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

    $ pulumi import azure-native:sql:ElasticPool sqlcrudtest-8102 /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/elasticPools/{elasticPoolName} 
    

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Azure Native pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native logo
    This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
    Azure Native v2.47.1 published on Monday, Jun 24, 2024 by Pulumi