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={
"maxCapacity": 0,
"minCapacity": 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
The ElasticPool resource accepts the following input properties:
- Per
Database ElasticSettings Pool Per Database Settings - A
per_database_settings
block as defined below. - Resource
Group 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.
- Server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Sku
Elastic
Pool Sku - A
sku
block as defined below. - Enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- License
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration 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
. - Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.NOTE: One of either
max_size_gb
ormax_size_bytes
must be specified.- Max
Size 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.
- Zone
Redundant bool - Whether or not this elastic pool is zone redundant.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
- Per
Database ElasticSettings Pool Per Database Settings Args - A
per_database_settings
block as defined below. - Resource
Group 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.
- Server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Sku
Elastic
Pool Sku Args - A
sku
block as defined below. - Enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- License
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration 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
. - Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.NOTE: One of either
max_size_gb
ormax_size_bytes
must be specified.- Max
Size 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.
- Zone
Redundant bool - Whether or not this elastic pool is zone redundant.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
- per
Database ElasticSettings Pool Per Database Settings - A
per_database_settings
block as defined below. - resource
Group 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.
- server
Name String - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku
Elastic
Pool Sku - A
sku
block as defined below. - enclave
Type String Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- license
Type String - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration 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
. - max
Size IntegerBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.NOTE: One of either
max_size_gb
ormax_size_bytes
must be specified.- max
Size 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.
- zone
Redundant Boolean - Whether or not this elastic pool is zone redundant.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
- per
Database ElasticSettings Pool Per Database Settings - A
per_database_settings
block as defined below. - resource
Group 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.
- server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku
Elastic
Pool Sku - A
sku
block as defined below. - enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- license
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration 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
. - max
Size numberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.NOTE: One of either
max_size_gb
ormax_size_bytes
must be specified.- max
Size 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.
- zone
Redundant boolean - Whether or not this elastic pool is zone redundant.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
- per_
database_ Elasticsettings Pool Per Database Settings Args - A
per_database_settings
block 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
Elastic
Pool Sku Args - A
sku
block as defined below. - enclave_
type str Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- license_
type str - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - 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_gb
ormax_size_bytes
must 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.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
- per
Database Property MapSettings - A
per_database_settings
block as defined below. - resource
Group 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.
- server
Name 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
sku
block as defined below. - enclave
Type String Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- license
Type String - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration 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
. - max
Size NumberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.NOTE: One of either
max_size_gb
ormax_size_bytes
must be specified.- max
Size 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.
- zone
Redundant Boolean - Whether or not this elastic pool is zone redundant.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
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) -> ElasticPool
func 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)
Resource lookup is not supported in YAML
- 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.
- Enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- License
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration 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
. - Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.NOTE: One of either
max_size_gb
ormax_size_bytes
must be specified.- Max
Size 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.
- Per
Database ElasticSettings Pool Per Database Settings - A
per_database_settings
block as defined below. - Resource
Group 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.
- Server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Sku
Elastic
Pool Sku - A
sku
block as defined below. - Dictionary<string, string>
- A mapping of tags to assign to the resource.
- Zone
Redundant bool - Whether or not this elastic pool is zone redundant.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
- Enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- License
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration 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
. - Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.NOTE: One of either
max_size_gb
ormax_size_bytes
must be specified.- Max
Size 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.
- Per
Database ElasticSettings Pool Per Database Settings Args - A
per_database_settings
block as defined below. - Resource
Group 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.
- Server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Sku
Elastic
Pool Sku Args - A
sku
block as defined below. - map[string]string
- A mapping of tags to assign to the resource.
- Zone
Redundant bool - Whether or not this elastic pool is zone redundant.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
- enclave
Type String Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- license
Type String - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration 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
. - max
Size IntegerBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.NOTE: One of either
max_size_gb
ormax_size_bytes
must be specified.- max
Size 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.
- per
Database ElasticSettings Pool Per Database Settings - A
per_database_settings
block as defined below. - resource
Group 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.
- server
Name String - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku
Elastic
Pool Sku - A
sku
block as defined below. - Map<String,String>
- A mapping of tags to assign to the resource.
- zone
Redundant Boolean - Whether or not this elastic pool is zone redundant.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
- enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- license
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration 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
. - max
Size numberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.NOTE: One of either
max_size_gb
ormax_size_bytes
must be specified.- max
Size 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.
- per
Database ElasticSettings Pool Per Database Settings - A
per_database_settings
block as defined below. - resource
Group 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.
- server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- sku
Elastic
Pool Sku - A
sku
block as defined below. - {[key: string]: string}
- A mapping of tags to assign to the resource.
- zone
Redundant boolean - Whether or not this elastic pool is zone redundant.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
- enclave_
type str Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- license_
type str - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - 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_gb
ormax_size_bytes
must 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_settings
block 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
Elastic
Pool Sku Args - A
sku
block 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.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
- enclave
Type String Specifies the type of enclave to be used by the elastic pool. When
enclave_type
is not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefault
orVBS
) removing theenclave_type
field from the configuration file will force the creation of a new resource.-> Possible values areDefault
orVBS
.NOTE: All databases that are added to the elastic pool must have the same
enclave_type
as the elastic pool.NOTE:
enclave_type
is not supported for DC-series SKUs.NOTE: The default value for
enclave_type
field is unset notDefault
.- license
Type String - Specifies the license type applied to this database. Possible values are
LicenseIncluded
andBasePrice
. - location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration 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
. - max
Size NumberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.NOTE: One of either
max_size_gb
ormax_size_bytes
must be specified.- max
Size 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.
- per
Database Property MapSettings - A
per_database_settings
block as defined below. - resource
Group 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.
- server
Name 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
sku
block as defined below. - Map<String>
- A mapping of tags to assign to the resource.
- zone
Redundant Boolean - Whether or not this elastic pool is zone redundant.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
Supporting Types
ElasticPoolPerDatabaseSettings, ElasticPoolPerDatabaseSettingsArgs
- Max
Capacity double - The maximum capacity any one database can consume.
- Min
Capacity double - The minimum capacity all databases are guaranteed.
- Max
Capacity float64 - The maximum capacity any one database can consume.
- Min
Capacity float64 - The minimum capacity all databases are guaranteed.
- max
Capacity Double - The maximum capacity any one database can consume.
- min
Capacity Double - The minimum capacity all databases are guaranteed.
- max
Capacity number - The maximum capacity any one database can consume.
- min
Capacity 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.
- max
Capacity Number - The maximum capacity any one database can consume.
- min
Capacity 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
vCore
based orDTU
based. PossibleDTU
based values areBasicPool
,StandardPool
,PremiumPool
while possiblevCore
based 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
family
of hardwareGen4
,Gen5
,Fsv2
,MOPRMS
, 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
vCore
based orDTU
based. PossibleDTU
based values areBasicPool
,StandardPool
,PremiumPool
while possiblevCore
based 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
family
of hardwareGen4
,Gen5
,Fsv2
,MOPRMS
, 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
vCore
based orDTU
based. PossibleDTU
based values areBasicPool
,StandardPool
,PremiumPool
while possiblevCore
based 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
family
of hardwareGen4
,Gen5
,Fsv2
,MOPRMS
, 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
vCore
based orDTU
based. PossibleDTU
based values areBasicPool
,StandardPool
,PremiumPool
while possiblevCore
based 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
family
of hardwareGen4
,Gen5
,Fsv2
,MOPRMS
, 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
vCore
based orDTU
based. PossibleDTU
based values areBasicPool
,StandardPool
,PremiumPool
while possiblevCore
based 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
family
of hardwareGen4
,Gen5
,Fsv2
,MOPRMS
, 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
vCore
based orDTU
based. PossibleDTU
based values areBasicPool
,StandardPool
,PremiumPool
while possiblevCore
based 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
family
of hardwareGen4
,Gen5
,Fsv2
,MOPRMS
, 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
azurerm
Terraform Provider.