Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Azure Native v1
  3. API Docs
  4. sql
  5. ElasticPool
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
pulumi/pulumi-azure-native

azure-native.sql.ElasticPool

Explore with Pulumi AI

azure-native-v1 logo
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
pulumi/pulumi-azure-native

    An elastic pool. API Version: 2020-11-01-preview.

    Example Usage

    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"
	"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 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(Map.ofEntries(
                Map.entry("maxCapacity", 2),
                Map.entry("minCapacity", 0.25)
            ))
            .resourceGroupName("sqlcrudtest-2369")
            .serverName("sqlcrudtest-8069")
            .sku(Map.ofEntries(
                Map.entry("capacity", 2),
                Map.entry("name", "GP_Gen4_2"),
                Map.entry("tier", "GeneralPurpose")
            ))
            .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"
	"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"
	"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,
                elastic_pool_name: Optional[str] = None,
                license_type: Optional[Union[str, ElasticPoolLicenseType]] = None,
                location: Optional[str] = None,
                maintenance_configuration_id: Optional[str] = None,
                max_size_bytes: Optional[float] = None,
                per_database_settings: Optional[ElasticPoolPerDatabaseSettingsArgs] = 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",
    ElasticPoolName = "string",
    LicenseType = "string",
    Location = "string",
    MaintenanceConfigurationId = "string",
    MaxSizeBytes = 0,
    PerDatabaseSettings = 
    {
        { "maxCapacity", 0 },
        { "minCapacity", 0 },
    },
    Sku = 
    {
        { "name", "string" },
        { "capacity", 0 },
        { "family", "string" },
        { "size", "string" },
        { "tier", "string" },
    },
    Tags = 
    {
        { "string", "string" },
    },
    ZoneRedundant = false,
});

    example, err := sql.NewElasticPool(ctx, "elasticPoolResource", &sql.ElasticPoolArgs{
	ResourceGroupName:          "string",
	ServerName:                 "string",
	ElasticPoolName:            "string",
	LicenseType:                "string",
	Location:                   "string",
	MaintenanceConfigurationId: "string",
	MaxSizeBytes:               0,
	PerDatabaseSettings: map[string]interface{}{
		"maxCapacity": 0,
		"minCapacity": 0,
	},
	Sku: map[string]interface{}{
		"name":     "string",
		"capacity": 0,
		"family":   "string",
		"size":     "string",
		"tier":     "string",
	},
	Tags: map[string]interface{}{
		"string": "string",
	},
	ZoneRedundant: false,
})

    var elasticPoolResource = new ElasticPool("elasticPoolResource", ElasticPoolArgs.builder()
    .resourceGroupName("string")
    .serverName("string")
    .elasticPoolName("string")
    .licenseType("string")
    .location("string")
    .maintenanceConfigurationId("string")
    .maxSizeBytes(0)
    .perDatabaseSettings(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
    .sku(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
    .tags(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
    .zoneRedundant(false)
    .build());

    elastic_pool_resource = azure_native.sql.ElasticPool("elasticPoolResource",
    resource_group_name=string,
    server_name=string,
    elastic_pool_name=string,
    license_type=string,
    location=string,
    maintenance_configuration_id=string,
    max_size_bytes=0,
    per_database_settings={
        maxCapacity: 0,
        minCapacity: 0,
    },
    sku={
        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",
    elasticPoolName: "string",
    licenseType: "string",
    location: "string",
    maintenanceConfigurationId: "string",
    maxSizeBytes: 0,
    perDatabaseSettings: {
        maxCapacity: 0,
        minCapacity: 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
    licenseType: string
    location: string
    maintenanceConfigurationId: string
    maxSizeBytes: 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

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    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.
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    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/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102

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

    Package Details

    Repository
    azure-native-v1 pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native-v1 logo
    These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
    Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
    pulumi/pulumi-azure-native