We recommend using Azure Native.
azure.mssql.ElasticPool
Explore with Pulumi AI
Allows you to manage an Azure SQL Elastic Pool via the v3.0
API which allows for vCore
and DTU
based configurations.
Example Usage
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;
return await Deployment.RunAsync(() =>
{
var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new()
{
Location = "West Europe",
});
var exampleSqlServer = new Azure.Sql.SqlServer("exampleSqlServer", new()
{
ResourceGroupName = exampleResourceGroup.Name,
Location = exampleResourceGroup.Location,
Version = "12.0",
AdministratorLogin = "4dm1n157r470r",
AdministratorLoginPassword = "4-v3ry-53cr37-p455w0rd",
});
var exampleElasticPool = new Azure.MSSql.ElasticPool("exampleElasticPool", new()
{
ResourceGroupName = exampleResourceGroup.Name,
Location = exampleResourceGroup.Location,
ServerName = exampleSqlServer.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 main
import (
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/core"
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/mssql"
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/sql"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
exampleResourceGroup, err := core.NewResourceGroup(ctx, "exampleResourceGroup", &core.ResourceGroupArgs{
Location: pulumi.String("West Europe"),
})
if err != nil {
return err
}
exampleSqlServer, err := sql.NewSqlServer(ctx, "exampleSqlServer", &sql.SqlServerArgs{
ResourceGroupName: exampleResourceGroup.Name,
Location: exampleResourceGroup.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, "exampleElasticPool", &mssql.ElasticPoolArgs{
ResourceGroupName: exampleResourceGroup.Name,
Location: exampleResourceGroup.Location,
ServerName: exampleSqlServer.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
})
}
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.sql.SqlServer;
import com.pulumi.azure.sql.SqlServerArgs;
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 exampleResourceGroup = new ResourceGroup("exampleResourceGroup", ResourceGroupArgs.builder()
.location("West Europe")
.build());
var exampleSqlServer = new SqlServer("exampleSqlServer", SqlServerArgs.builder()
.resourceGroupName(exampleResourceGroup.name())
.location(exampleResourceGroup.location())
.version("12.0")
.administratorLogin("4dm1n157r470r")
.administratorLoginPassword("4-v3ry-53cr37-p455w0rd")
.build());
var exampleElasticPool = new ElasticPool("exampleElasticPool", ElasticPoolArgs.builder()
.resourceGroupName(exampleResourceGroup.name())
.location(exampleResourceGroup.location())
.serverName(exampleSqlServer.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());
}
}
import pulumi
import pulumi_azure as azure
example_resource_group = azure.core.ResourceGroup("exampleResourceGroup", location="West Europe")
example_sql_server = azure.sql.SqlServer("exampleSqlServer",
resource_group_name=example_resource_group.name,
location=example_resource_group.location,
version="12.0",
administrator_login="4dm1n157r470r",
administrator_login_password="4-v3ry-53cr37-p455w0rd")
example_elastic_pool = azure.mssql.ElasticPool("exampleElasticPool",
resource_group_name=example_resource_group.name,
location=example_resource_group.location,
server_name=example_sql_server.name,
license_type="LicenseIncluded",
max_size_gb=756,
sku=azure.mssql.ElasticPoolSkuArgs(
name="BasicPool",
tier="Basic",
family="Gen4",
capacity=4,
),
per_database_settings=azure.mssql.ElasticPoolPerDatabaseSettingsArgs(
min_capacity=0.25,
max_capacity=4,
))
import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
const exampleResourceGroup = new azure.core.ResourceGroup("exampleResourceGroup", {location: "West Europe"});
const exampleSqlServer = new azure.sql.SqlServer("exampleSqlServer", {
resourceGroupName: exampleResourceGroup.name,
location: exampleResourceGroup.location,
version: "12.0",
administratorLogin: "4dm1n157r470r",
administratorLoginPassword: "4-v3ry-53cr37-p455w0rd",
});
const exampleElasticPool = new azure.mssql.ElasticPool("exampleElasticPool", {
resourceGroupName: exampleResourceGroup.name,
location: exampleResourceGroup.location,
serverName: exampleSqlServer.name,
licenseType: "LicenseIncluded",
maxSizeGb: 756,
sku: {
name: "BasicPool",
tier: "Basic",
family: "Gen4",
capacity: 4,
},
perDatabaseSettings: {
minCapacity: 0.25,
maxCapacity: 4,
},
});
resources:
exampleResourceGroup:
type: azure:core:ResourceGroup
properties:
location: West Europe
exampleSqlServer:
type: azure:sql:SqlServer
properties:
resourceGroupName: ${exampleResourceGroup.name}
location: ${exampleResourceGroup.location}
version: '12.0'
administratorLogin: 4dm1n157r470r
administratorLoginPassword: 4-v3ry-53cr37-p455w0rd
exampleElasticPool:
type: azure:mssql:ElasticPool
properties:
resourceGroupName: ${exampleResourceGroup.name}
location: ${exampleResourceGroup.location}
serverName: ${exampleSqlServer.name}
licenseType: LicenseIncluded
maxSizeGb: 756
sku:
name: BasicPool
tier: Basic
family: Gen4
capacity: 4
perDatabaseSettings:
minCapacity: 0.25
maxCapacity: 4
Create ElasticPool Resource
new ElasticPool(name: string, args: ElasticPoolArgs, opts?: CustomResourceOptions);
@overload
def ElasticPool(resource_name: str,
opts: Optional[ResourceOptions] = 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)
@overload
def ElasticPool(resource_name: str,
args: ElasticPoolArgs,
opts: Optional[ResourceOptions] = 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.
- 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.
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 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.- 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
. Defaults toSQL_Default
.- Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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.- 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
. Defaults toSQL_Default
.- Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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 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.- 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
. Defaults toSQL_Default
.- max
Size IntegerBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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 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.- 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
. Defaults toSQL_Default
.- max
Size numberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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.- 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
. Defaults toSQL_Default
.- max_
size_ intbytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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.- 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
. Defaults toSQL_Default
.- max
Size NumberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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,
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.
- 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
. Defaults toSQL_Default
.- Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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 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.- 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
.
- 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
. Defaults toSQL_Default
.- Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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
.
- 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
. Defaults toSQL_Default
.- max
Size IntegerBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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 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 Boolean Whether or not this elastic pool is zone redundant.
tier
needs to bePremium
forDTU
based orBusinessCritical
forvCore
basedsku
.
- 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
. Defaults toSQL_Default
.- max
Size numberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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 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.- {[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
.
- 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
. Defaults toSQL_Default
.- max_
size_ intbytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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
.
- 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
. Defaults toSQL_Default
.- max
Size NumberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb
.- 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
- 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
- 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
basedtier
+family
pattern (e.g. GP_Gen4, BC_Gen5) or theDTU
basedBasicPool
,StandardPool
, orPremiumPool
pattern. Possible values areBasicPool
,StandardPool
,PremiumPool
,GP_Gen4
,GP_Gen5
,GP_Fsv2
,GP_DC
,BC_Gen4
,BC_Gen5
andBC_DC
.- Tier string
The tier of the particular SKU. Possible values are
GeneralPurpose
,BusinessCritical
,Basic
,Standard
, orPremium
. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.- Family string
The
family
of hardwareGen4
,Gen5
,Fsv2
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
basedtier
+family
pattern (e.g. GP_Gen4, BC_Gen5) or theDTU
basedBasicPool
,StandardPool
, orPremiumPool
pattern. Possible values areBasicPool
,StandardPool
,PremiumPool
,GP_Gen4
,GP_Gen5
,GP_Fsv2
,GP_DC
,BC_Gen4
,BC_Gen5
andBC_DC
.- Tier string
The tier of the particular SKU. Possible values are
GeneralPurpose
,BusinessCritical
,Basic
,Standard
, orPremium
. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.- Family string
The
family
of hardwareGen4
,Gen5
,Fsv2
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
basedtier
+family
pattern (e.g. GP_Gen4, BC_Gen5) or theDTU
basedBasicPool
,StandardPool
, orPremiumPool
pattern. Possible values areBasicPool
,StandardPool
,PremiumPool
,GP_Gen4
,GP_Gen5
,GP_Fsv2
,GP_DC
,BC_Gen4
,BC_Gen5
andBC_DC
.- tier String
The tier of the particular SKU. Possible values are
GeneralPurpose
,BusinessCritical
,Basic
,Standard
, orPremium
. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.- family String
The
family
of hardwareGen4
,Gen5
,Fsv2
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
basedtier
+family
pattern (e.g. GP_Gen4, BC_Gen5) or theDTU
basedBasicPool
,StandardPool
, orPremiumPool
pattern. Possible values areBasicPool
,StandardPool
,PremiumPool
,GP_Gen4
,GP_Gen5
,GP_Fsv2
,GP_DC
,BC_Gen4
,BC_Gen5
andBC_DC
.- tier string
The tier of the particular SKU. Possible values are
GeneralPurpose
,BusinessCritical
,Basic
,Standard
, orPremium
. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.- family string
The
family
of hardwareGen4
,Gen5
,Fsv2
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
basedtier
+family
pattern (e.g. GP_Gen4, BC_Gen5) or theDTU
basedBasicPool
,StandardPool
, orPremiumPool
pattern. Possible values areBasicPool
,StandardPool
,PremiumPool
,GP_Gen4
,GP_Gen5
,GP_Fsv2
,GP_DC
,BC_Gen4
,BC_Gen5
andBC_DC
.- tier str
The tier of the particular SKU. Possible values are
GeneralPurpose
,BusinessCritical
,Basic
,Standard
, orPremium
. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.- family str
The
family
of hardwareGen4
,Gen5
,Fsv2
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
basedtier
+family
pattern (e.g. GP_Gen4, BC_Gen5) or theDTU
basedBasicPool
,StandardPool
, orPremiumPool
pattern. Possible values areBasicPool
,StandardPool
,PremiumPool
,GP_Gen4
,GP_Gen5
,GP_Fsv2
,GP_DC
,BC_Gen4
,BC_Gen5
andBC_DC
.- tier String
The tier of the particular SKU. Possible values are
GeneralPurpose
,BusinessCritical
,Basic
,Standard
, orPremium
. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.- family String
The
family
of hardwareGen4
,Gen5
,Fsv2
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
Package Details
- Repository
- Azure Classic pulumi/pulumi-azure
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
azurerm
Terraform Provider.