We recommend using Azure Native.
azure.mssql.ElasticPool
Explore with Pulumi AI
Allows you to manage an Azure SQL Elastic Pool.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
const example = new azure.core.ResourceGroup("example", {
    name: "my-resource-group",
    location: "West Europe",
});
const exampleServer = new azure.mssql.Server("example", {
    name: "my-sql-server",
    resourceGroupName: example.name,
    location: example.location,
    version: "12.0",
    administratorLogin: "4dm1n157r470r",
    administratorLoginPassword: "4-v3ry-53cr37-p455w0rd",
});
const exampleElasticPool = new azure.mssql.ElasticPool("example", {
    name: "test-epool",
    resourceGroupName: example.name,
    location: example.location,
    serverName: exampleServer.name,
    licenseType: "LicenseIncluded",
    maxSizeGb: 756,
    sku: {
        name: "BasicPool",
        tier: "Basic",
        family: "Gen4",
        capacity: 4,
    },
    perDatabaseSettings: {
        minCapacity: 0.25,
        maxCapacity: 4,
    },
});
import pulumi
import pulumi_azure as azure
example = azure.core.ResourceGroup("example",
    name="my-resource-group",
    location="West Europe")
example_server = azure.mssql.Server("example",
    name="my-sql-server",
    resource_group_name=example.name,
    location=example.location,
    version="12.0",
    administrator_login="4dm1n157r470r",
    administrator_login_password="4-v3ry-53cr37-p455w0rd")
example_elastic_pool = azure.mssql.ElasticPool("example",
    name="test-epool",
    resource_group_name=example.name,
    location=example.location,
    server_name=example_server.name,
    license_type="LicenseIncluded",
    max_size_gb=756,
    sku={
        "name": "BasicPool",
        "tier": "Basic",
        "family": "Gen4",
        "capacity": 4,
    },
    per_database_settings={
        "min_capacity": 0.25,
        "max_capacity": 4,
    })
package main
import (
	"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/core"
	"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/mssql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		example, err := core.NewResourceGroup(ctx, "example", &core.ResourceGroupArgs{
			Name:     pulumi.String("my-resource-group"),
			Location: pulumi.String("West Europe"),
		})
		if err != nil {
			return err
		}
		exampleServer, err := mssql.NewServer(ctx, "example", &mssql.ServerArgs{
			Name:                       pulumi.String("my-sql-server"),
			ResourceGroupName:          example.Name,
			Location:                   example.Location,
			Version:                    pulumi.String("12.0"),
			AdministratorLogin:         pulumi.String("4dm1n157r470r"),
			AdministratorLoginPassword: pulumi.String("4-v3ry-53cr37-p455w0rd"),
		})
		if err != nil {
			return err
		}
		_, err = mssql.NewElasticPool(ctx, "example", &mssql.ElasticPoolArgs{
			Name:              pulumi.String("test-epool"),
			ResourceGroupName: example.Name,
			Location:          example.Location,
			ServerName:        exampleServer.Name,
			LicenseType:       pulumi.String("LicenseIncluded"),
			MaxSizeGb:         pulumi.Float64(756),
			Sku: &mssql.ElasticPoolSkuArgs{
				Name:     pulumi.String("BasicPool"),
				Tier:     pulumi.String("Basic"),
				Family:   pulumi.String("Gen4"),
				Capacity: pulumi.Int(4),
			},
			PerDatabaseSettings: &mssql.ElasticPoolPerDatabaseSettingsArgs{
				MinCapacity: pulumi.Float64(0.25),
				MaxCapacity: pulumi.Float64(4),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;
return await Deployment.RunAsync(() => 
{
    var example = new Azure.Core.ResourceGroup("example", new()
    {
        Name = "my-resource-group",
        Location = "West Europe",
    });
    var exampleServer = new Azure.MSSql.Server("example", new()
    {
        Name = "my-sql-server",
        ResourceGroupName = example.Name,
        Location = example.Location,
        Version = "12.0",
        AdministratorLogin = "4dm1n157r470r",
        AdministratorLoginPassword = "4-v3ry-53cr37-p455w0rd",
    });
    var exampleElasticPool = new Azure.MSSql.ElasticPool("example", new()
    {
        Name = "test-epool",
        ResourceGroupName = example.Name,
        Location = example.Location,
        ServerName = exampleServer.Name,
        LicenseType = "LicenseIncluded",
        MaxSizeGb = 756,
        Sku = new Azure.MSSql.Inputs.ElasticPoolSkuArgs
        {
            Name = "BasicPool",
            Tier = "Basic",
            Family = "Gen4",
            Capacity = 4,
        },
        PerDatabaseSettings = new Azure.MSSql.Inputs.ElasticPoolPerDatabaseSettingsArgs
        {
            MinCapacity = 0.25,
            MaxCapacity = 4,
        },
    });
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.mssql.Server;
import com.pulumi.azure.mssql.ServerArgs;
import com.pulumi.azure.mssql.ElasticPool;
import com.pulumi.azure.mssql.ElasticPoolArgs;
import com.pulumi.azure.mssql.inputs.ElasticPoolSkuArgs;
import com.pulumi.azure.mssql.inputs.ElasticPoolPerDatabaseSettingsArgs;
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 example = new ResourceGroup("example", ResourceGroupArgs.builder()
            .name("my-resource-group")
            .location("West Europe")
            .build());
        var exampleServer = new Server("exampleServer", ServerArgs.builder()
            .name("my-sql-server")
            .resourceGroupName(example.name())
            .location(example.location())
            .version("12.0")
            .administratorLogin("4dm1n157r470r")
            .administratorLoginPassword("4-v3ry-53cr37-p455w0rd")
            .build());
        var exampleElasticPool = new ElasticPool("exampleElasticPool", ElasticPoolArgs.builder()
            .name("test-epool")
            .resourceGroupName(example.name())
            .location(example.location())
            .serverName(exampleServer.name())
            .licenseType("LicenseIncluded")
            .maxSizeGb(756)
            .sku(ElasticPoolSkuArgs.builder()
                .name("BasicPool")
                .tier("Basic")
                .family("Gen4")
                .capacity(4)
                .build())
            .perDatabaseSettings(ElasticPoolPerDatabaseSettingsArgs.builder()
                .minCapacity(0.25)
                .maxCapacity(4)
                .build())
            .build());
    }
}
resources:
  example:
    type: azure:core:ResourceGroup
    properties:
      name: my-resource-group
      location: West Europe
  exampleServer:
    type: azure:mssql:Server
    name: example
    properties:
      name: my-sql-server
      resourceGroupName: ${example.name}
      location: ${example.location}
      version: '12.0'
      administratorLogin: 4dm1n157r470r
      administratorLoginPassword: 4-v3ry-53cr37-p455w0rd
  exampleElasticPool:
    type: azure:mssql:ElasticPool
    name: example
    properties:
      name: test-epool
      resourceGroupName: ${example.name}
      location: ${example.location}
      serverName: ${exampleServer.name}
      licenseType: LicenseIncluded
      maxSizeGb: 756
      sku:
        name: BasicPool
        tier: Basic
        family: Gen4
        capacity: 4
      perDatabaseSettings:
        minCapacity: 0.25
        maxCapacity: 4
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,
                per_database_settings: Optional[ElasticPoolPerDatabaseSettingsArgs] = None,
                sku: Optional[ElasticPoolSkuArgs] = None,
                server_name: Optional[str] = None,
                resource_group_name: Optional[str] = None,
                maintenance_configuration_name: Optional[str] = None,
                max_size_gb: Optional[float] = None,
                name: Optional[str] = None,
                max_size_bytes: Optional[int] = None,
                enclave_type: Optional[str] = None,
                location: Optional[str] = None,
                license_type: Optional[str] = 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:mssql: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 Azure.MSSql.ElasticPool("elasticPoolResource", new()
{
    PerDatabaseSettings = new Azure.MSSql.Inputs.ElasticPoolPerDatabaseSettingsArgs
    {
        MaxCapacity = 0,
        MinCapacity = 0,
    },
    Sku = new Azure.MSSql.Inputs.ElasticPoolSkuArgs
    {
        Capacity = 0,
        Name = "string",
        Tier = "string",
        Family = "string",
    },
    ServerName = "string",
    ResourceGroupName = "string",
    MaintenanceConfigurationName = "string",
    MaxSizeGb = 0,
    Name = "string",
    MaxSizeBytes = 0,
    EnclaveType = "string",
    Location = "string",
    LicenseType = "string",
    Tags = 
    {
        { "string", "string" },
    },
    ZoneRedundant = false,
});
example, err := mssql.NewElasticPool(ctx, "elasticPoolResource", &mssql.ElasticPoolArgs{
	PerDatabaseSettings: &mssql.ElasticPoolPerDatabaseSettingsArgs{
		MaxCapacity: pulumi.Float64(0),
		MinCapacity: pulumi.Float64(0),
	},
	Sku: &mssql.ElasticPoolSkuArgs{
		Capacity: pulumi.Int(0),
		Name:     pulumi.String("string"),
		Tier:     pulumi.String("string"),
		Family:   pulumi.String("string"),
	},
	ServerName:                   pulumi.String("string"),
	ResourceGroupName:            pulumi.String("string"),
	MaintenanceConfigurationName: pulumi.String("string"),
	MaxSizeGb:                    pulumi.Float64(0),
	Name:                         pulumi.String("string"),
	MaxSizeBytes:                 pulumi.Int(0),
	EnclaveType:                  pulumi.String("string"),
	Location:                     pulumi.String("string"),
	LicenseType:                  pulumi.String("string"),
	Tags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	ZoneRedundant: pulumi.Bool(false),
})
var elasticPoolResource = new ElasticPool("elasticPoolResource", ElasticPoolArgs.builder()
    .perDatabaseSettings(ElasticPoolPerDatabaseSettingsArgs.builder()
        .maxCapacity(0)
        .minCapacity(0)
        .build())
    .sku(ElasticPoolSkuArgs.builder()
        .capacity(0)
        .name("string")
        .tier("string")
        .family("string")
        .build())
    .serverName("string")
    .resourceGroupName("string")
    .maintenanceConfigurationName("string")
    .maxSizeGb(0)
    .name("string")
    .maxSizeBytes(0)
    .enclaveType("string")
    .location("string")
    .licenseType("string")
    .tags(Map.of("string", "string"))
    .zoneRedundant(false)
    .build());
elastic_pool_resource = azure.mssql.ElasticPool("elasticPoolResource",
    per_database_settings={
        "max_capacity": 0,
        "min_capacity": 0,
    },
    sku={
        "capacity": 0,
        "name": "string",
        "tier": "string",
        "family": "string",
    },
    server_name="string",
    resource_group_name="string",
    maintenance_configuration_name="string",
    max_size_gb=0,
    name="string",
    max_size_bytes=0,
    enclave_type="string",
    location="string",
    license_type="string",
    tags={
        "string": "string",
    },
    zone_redundant=False)
const elasticPoolResource = new azure.mssql.ElasticPool("elasticPoolResource", {
    perDatabaseSettings: {
        maxCapacity: 0,
        minCapacity: 0,
    },
    sku: {
        capacity: 0,
        name: "string",
        tier: "string",
        family: "string",
    },
    serverName: "string",
    resourceGroupName: "string",
    maintenanceConfigurationName: "string",
    maxSizeGb: 0,
    name: "string",
    maxSizeBytes: 0,
    enclaveType: "string",
    location: "string",
    licenseType: "string",
    tags: {
        string: "string",
    },
    zoneRedundant: false,
});
type: azure:mssql:ElasticPool
properties:
    enclaveType: string
    licenseType: string
    location: string
    maintenanceConfigurationName: string
    maxSizeBytes: 0
    maxSizeGb: 0
    name: string
    perDatabaseSettings:
        maxCapacity: 0
        minCapacity: 0
    resourceGroupName: string
    serverName: string
    sku:
        capacity: 0
        family: string
        name: 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:
- PerDatabase ElasticSettings Pool Per Database Settings 
- A per_database_settingsblock as defined below.
- ResourceGroup stringName 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- ServerName string
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Sku
ElasticPool Sku 
- A skublock as defined below.
- EnclaveType string
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- LicenseType string
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- MaintenanceConfiguration stringName 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- MaxSize intBytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- MaxSize doubleGb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Dictionary<string, string>
- A mapping of tags to assign to the resource.
- ZoneRedundant bool
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- PerDatabase ElasticSettings Pool Per Database Settings Args 
- A per_database_settingsblock as defined below.
- ResourceGroup stringName 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- ServerName string
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Sku
ElasticPool Sku Args 
- A skublock as defined below.
- EnclaveType string
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- LicenseType string
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- MaintenanceConfiguration stringName 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- MaxSize intBytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- MaxSize float64Gb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- map[string]string
- A mapping of tags to assign to the resource.
- ZoneRedundant bool
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- perDatabase ElasticSettings Pool Per Database Settings 
- A per_database_settingsblock as defined below.
- resourceGroup StringName 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- serverName String
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku
ElasticPool Sku 
- A skublock as defined below.
- enclaveType String
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- licenseType String
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenanceConfiguration StringName 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- maxSize IntegerBytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- maxSize DoubleGb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Map<String,String>
- A mapping of tags to assign to the resource.
- zoneRedundant Boolean
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- perDatabase ElasticSettings Pool Per Database Settings 
- A per_database_settingsblock as defined below.
- resourceGroup stringName 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- serverName string
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku
ElasticPool Sku 
- A skublock as defined below.
- enclaveType string
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- licenseType string
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenanceConfiguration stringName 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- maxSize numberBytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- maxSize numberGb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- {[key: string]: string}
- A mapping of tags to assign to the resource.
- zoneRedundant boolean
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- per_database_ Elasticsettings Pool Per Database Settings Args 
- A per_database_settingsblock as defined below.
- resource_group_ strname 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- server_name str
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku
ElasticPool Sku Args 
- A skublock as defined below.
- enclave_type str
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- license_type str
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- location str
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance_configuration_ strname 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- max_size_ intbytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- max_size_ floatgb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- name str
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Mapping[str, str]
- A mapping of tags to assign to the resource.
- zone_redundant bool
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- perDatabase Property MapSettings 
- A per_database_settingsblock as defined below.
- resourceGroup StringName 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- serverName String
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku Property Map
- A skublock as defined below.
- enclaveType String
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- licenseType String
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenanceConfiguration StringName 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- maxSize NumberBytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- maxSize NumberGb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Map<String>
- A mapping of tags to assign to the resource.
- zoneRedundant Boolean
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
Outputs
All input properties are implicitly available as output properties. Additionally, the ElasticPool resource produces the following output properties:
- Id string
- The provider-assigned unique ID for this managed resource.
- Id string
- The provider-assigned unique ID for this managed resource.
- id String
- The provider-assigned unique ID for this managed resource.
- id string
- The provider-assigned unique ID for this managed resource.
- id str
- The provider-assigned unique ID for this managed resource.
- id String
- The provider-assigned unique ID for this managed resource.
Look up Existing ElasticPool Resource
Get an existing ElasticPool resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: ElasticPoolState, opts?: CustomResourceOptions): ElasticPool@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        enclave_type: Optional[str] = None,
        license_type: Optional[str] = None,
        location: Optional[str] = None,
        maintenance_configuration_name: Optional[str] = None,
        max_size_bytes: Optional[int] = None,
        max_size_gb: Optional[float] = None,
        name: Optional[str] = None,
        per_database_settings: Optional[ElasticPoolPerDatabaseSettingsArgs] = None,
        resource_group_name: Optional[str] = None,
        server_name: Optional[str] = None,
        sku: Optional[ElasticPoolSkuArgs] = None,
        tags: Optional[Mapping[str, str]] = None,
        zone_redundant: Optional[bool] = None) -> ElasticPoolfunc GetElasticPool(ctx *Context, name string, id IDInput, state *ElasticPoolState, opts ...ResourceOption) (*ElasticPool, error)public static ElasticPool Get(string name, Input<string> id, ElasticPoolState? state, CustomResourceOptions? opts = null)public static ElasticPool get(String name, Output<String> id, ElasticPoolState state, CustomResourceOptions options)resources:  _:    type: azure:mssql:ElasticPool    get:      id: ${id}- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- EnclaveType string
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- LicenseType string
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- MaintenanceConfiguration stringName 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- MaxSize intBytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- MaxSize doubleGb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- PerDatabase ElasticSettings Pool Per Database Settings 
- A per_database_settingsblock as defined below.
- ResourceGroup stringName 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- ServerName string
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Sku
ElasticPool Sku 
- A skublock as defined below.
- Dictionary<string, string>
- A mapping of tags to assign to the resource.
- ZoneRedundant bool
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- EnclaveType string
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- LicenseType string
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- MaintenanceConfiguration stringName 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- MaxSize intBytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- MaxSize float64Gb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- PerDatabase ElasticSettings Pool Per Database Settings Args 
- A per_database_settingsblock as defined below.
- ResourceGroup stringName 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- ServerName string
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Sku
ElasticPool Sku Args 
- A skublock as defined below.
- map[string]string
- A mapping of tags to assign to the resource.
- ZoneRedundant bool
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- enclaveType String
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- licenseType String
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenanceConfiguration StringName 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- maxSize IntegerBytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- maxSize DoubleGb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- perDatabase ElasticSettings Pool Per Database Settings 
- A per_database_settingsblock as defined below.
- resourceGroup StringName 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- serverName String
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku
ElasticPool Sku 
- A skublock as defined below.
- Map<String,String>
- A mapping of tags to assign to the resource.
- zoneRedundant Boolean
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- enclaveType string
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- licenseType string
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenanceConfiguration stringName 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- maxSize numberBytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- maxSize numberGb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- perDatabase ElasticSettings Pool Per Database Settings 
- A per_database_settingsblock as defined below.
- resourceGroup stringName 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- serverName string
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku
ElasticPool Sku 
- A skublock as defined below.
- {[key: string]: string}
- A mapping of tags to assign to the resource.
- zoneRedundant boolean
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- enclave_type str
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- license_type str
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- location str
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance_configuration_ strname 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- max_size_ intbytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- max_size_ floatgb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- name str
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- per_database_ Elasticsettings Pool Per Database Settings Args 
- A per_database_settingsblock as defined below.
- resource_group_ strname 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- server_name str
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku
ElasticPool Sku Args 
- A skublock as defined below.
- Mapping[str, str]
- A mapping of tags to assign to the resource.
- zone_redundant bool
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- enclaveType String
- Specifies the type of enclave to be used by the elastic pool. When - enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. Once enabled (e.g., by specifying- Defaultor- VBS) removing the- enclave_typefield from the configuration file will force the creation of a new resource. Possible values are- Defaultor- VBS.- NOTE: All databases that are added to the elastic pool must have the same - enclave_typeas the elastic pool.- NOTE: - enclave_typeis not supported for DC-series SKUs.- NOTE: The default value for - enclave_typefield is unset not- Default.
- licenseType String
- Specifies the license type applied to this database. Possible values are LicenseIncludedandBasePrice.
- location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenanceConfiguration StringName 
- The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default.
- maxSize NumberBytes 
- The max data size of the elastic pool in bytes. Conflicts with - max_size_gb.- NOTE: One of either - max_size_gbor- max_size_bytesmust be specified.
- maxSize NumberGb 
- The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.
- name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- perDatabase Property MapSettings 
- A per_database_settingsblock as defined below.
- resourceGroup StringName 
- The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server. Changing this forces a new resource to be created.
- serverName String
- The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku Property Map
- A skublock as defined below.
- Map<String>
- A mapping of tags to assign to the resource.
- zoneRedundant Boolean
- Whether or not this elastic pool is zone redundant. tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
Supporting Types
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.
ElasticPoolSku, ElasticPoolSkuArgs      
- Capacity int
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- Name string
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS,HS_MOPRMS, orHS_Gen5.
- Tier string
- The tier of the particular SKU. Possible values are GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- Family string
- The familyof hardwareGen4,Gen5,Fsv2,MOPRMS,PRMS, orDC.
- Capacity int
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- Name string
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS,HS_MOPRMS, orHS_Gen5.
- Tier string
- The tier of the particular SKU. Possible values are GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- Family string
- The familyof hardwareGen4,Gen5,Fsv2,MOPRMS,PRMS, orDC.
- capacity Integer
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- name String
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS,HS_MOPRMS, orHS_Gen5.
- tier String
- The tier of the particular SKU. Possible values are GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- family String
- The familyof hardwareGen4,Gen5,Fsv2,MOPRMS,PRMS, orDC.
- capacity number
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- name string
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS,HS_MOPRMS, orHS_Gen5.
- tier string
- The tier of the particular SKU. Possible values are GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- family string
- The familyof hardwareGen4,Gen5,Fsv2,MOPRMS,PRMS, orDC.
- capacity int
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- name str
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS,HS_MOPRMS, orHS_Gen5.
- tier str
- The tier of the particular SKU. Possible values are GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- family str
- The familyof hardwareGen4,Gen5,Fsv2,MOPRMS,PRMS, orDC.
- capacity Number
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- name String
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS,HS_MOPRMS, orHS_Gen5.
- tier String
- The tier of the particular SKU. Possible values are GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- family String
- The familyof hardwareGen4,Gen5,Fsv2,MOPRMS,PRMS, orDC.
Import
SQL Elastic Pool can be imported using the resource id, e.g.
$ pulumi import azure:mssql/elasticPool:ElasticPool example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/servers/myserver/elasticPools/myelasticpoolname
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- Azure Classic pulumi/pulumi-azure
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the azurermTerraform Provider.