mssql

This provider is a derived work of the Terraform Provider distributed under MPL 2.0. If you encounter a bug or missing feature, first check the pulumi/pulumi-azure repo; however, if that doesn’t turn up anything, please consult the source terraform-providers/terraform-provider-azurerm repo.

class pulumi_azure.mssql.AwaitableGetElasticPoolResult(location=None, max_size_bytes=None, max_size_gb=None, name=None, per_db_max_capacity=None, per_db_min_capacity=None, resource_group_name=None, server_name=None, tags=None, zone_redundant=None, id=None)
class pulumi_azure.mssql.ElasticPool(resource_name, opts=None, location=None, max_size_bytes=None, max_size_gb=None, name=None, per_database_settings=None, resource_group_name=None, server_name=None, sku=None, tags=None, zone_redundant=None, __props__=None, __name__=None, __opts__=None)

Allows you to manage an Azure SQL Elastic Pool via the 2017-10-01-preview API which allows for vCore and DTU based configurations.

Parameters
  • resource_name (str) – The name of the resource.

  • opts (pulumi.ResourceOptions) – Options for the resource.

  • location (pulumi.Input[str]) – Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

  • max_size_bytes (pulumi.Input[float]) – The max data size of the elastic pool in bytes. Conflicts with max_size_gb.

  • max_size_gb (pulumi.Input[float]) – The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.

  • name (pulumi.Input[str]) – Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCore based tier + family pattern (e.g. GP_Gen4, BC_Gen5) or the DTU based BasicPool, StandardPool, or PremiumPool pattern.

  • per_database_settings (pulumi.Input[dict]) – A per_database_settings block as defined below.

  • resource_group_name (pulumi.Input[str]) – 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.

  • server_name (pulumi.Input[str]) – The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.

  • sku (pulumi.Input[dict]) – A sku block as defined below.

  • tags (pulumi.Input[dict]) – A mapping of tags to assign to the resource.

  • zone_redundant (pulumi.Input[bool]) – Whether or not this elastic pool is zone redundant. tier needs to be Premium for DTU based or BusinessCritical for vCore based sku. Defaults to false.

The per_database_settings object supports the following:

  • maxCapacity (pulumi.Input[float]) - The maximum capacity any one database can consume.

  • minCapacity (pulumi.Input[float]) - The minimum capacity all databases are guaranteed.

The sku object supports the following:

  • capacity (pulumi.Input[float]) - 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.

  • family (pulumi.Input[str]) - The family of hardware Gen4 or Gen5.

  • name (pulumi.Input[str]) - Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCore based tier + family pattern (e.g. GP_Gen4, BC_Gen5) or the DTU based BasicPool, StandardPool, or PremiumPool pattern.

  • tier (pulumi.Input[str]) - The tier of the particular SKU. Possible values are GeneralPurpose, BusinessCritical, Basic, Standard, or Premium. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.

location = None

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

max_size_bytes = None

The max data size of the elastic pool in bytes. Conflicts with max_size_gb.

max_size_gb = None

The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.

name = None

Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCore based tier + family pattern (e.g. GP_Gen4, BC_Gen5) or the DTU based BasicPool, StandardPool, or PremiumPool pattern.

per_database_settings = None

A per_database_settings block as defined below.

  • maxCapacity (float) - The maximum capacity any one database can consume.

  • minCapacity (float) - The minimum capacity all databases are guaranteed.

resource_group_name = None

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.

server_name = None

The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.

sku = None

A sku block as defined below.

  • capacity (float) - 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.

  • family (str) - The family of hardware Gen4 or Gen5.

  • name (str) - Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCore based tier + family pattern (e.g. GP_Gen4, BC_Gen5) or the DTU based BasicPool, StandardPool, or PremiumPool pattern.

  • tier (str) - The tier of the particular SKU. Possible values are GeneralPurpose, BusinessCritical, Basic, Standard, or Premium. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.

tags = None

A mapping of tags to assign to the resource.

zone_redundant = None

Whether or not this elastic pool is zone redundant. tier needs to be Premium for DTU based or BusinessCritical for vCore based sku. Defaults to false.

static get(resource_name, id, opts=None, elastic_pool_properties=None, location=None, max_size_bytes=None, max_size_gb=None, name=None, per_database_settings=None, resource_group_name=None, server_name=None, sku=None, tags=None, zone_redundant=None)

Get an existing ElasticPool resource’s state with the given name, id, and optional extra properties used to qualify the lookup.

Parameters
  • resource_name (str) – The unique name of the resulting resource.

  • id (str) – The unique provider ID of the resource to lookup.

  • opts (pulumi.ResourceOptions) – Options for the resource.

  • location (pulumi.Input[str]) – Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

  • max_size_bytes (pulumi.Input[float]) – The max data size of the elastic pool in bytes. Conflicts with max_size_gb.

  • max_size_gb (pulumi.Input[float]) – The max data size of the elastic pool in gigabytes. Conflicts with max_size_bytes.

  • name (pulumi.Input[str]) – Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCore based tier + family pattern (e.g. GP_Gen4, BC_Gen5) or the DTU based BasicPool, StandardPool, or PremiumPool pattern.

  • per_database_settings (pulumi.Input[dict]) – A per_database_settings block as defined below.

  • resource_group_name (pulumi.Input[str]) – 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.

  • server_name (pulumi.Input[str]) – The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.

  • sku (pulumi.Input[dict]) – A sku block as defined below.

  • tags (pulumi.Input[dict]) – A mapping of tags to assign to the resource.

  • zone_redundant (pulumi.Input[bool]) – Whether or not this elastic pool is zone redundant. tier needs to be Premium for DTU based or BusinessCritical for vCore based sku. Defaults to false.

The elastic_pool_properties object supports the following:

  • creationDate (pulumi.Input[str])

  • license_type (pulumi.Input[str])

  • max_size_bytes (pulumi.Input[float]) - The max data size of the elastic pool in bytes. Conflicts with max_size_gb.

  • state (pulumi.Input[str])

  • zone_redundant (pulumi.Input[bool]) - Whether or not this elastic pool is zone redundant. tier needs to be Premium for DTU based or BusinessCritical for vCore based sku. Defaults to false.

The per_database_settings object supports the following:

  • maxCapacity (pulumi.Input[float]) - The maximum capacity any one database can consume.

  • minCapacity (pulumi.Input[float]) - The minimum capacity all databases are guaranteed.

The sku object supports the following:

  • capacity (pulumi.Input[float]) - 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.

  • family (pulumi.Input[str]) - The family of hardware Gen4 or Gen5.

  • name (pulumi.Input[str]) - Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either vCore based tier + family pattern (e.g. GP_Gen4, BC_Gen5) or the DTU based BasicPool, StandardPool, or PremiumPool pattern.

  • tier (pulumi.Input[str]) - The tier of the particular SKU. Possible values are GeneralPurpose, BusinessCritical, Basic, Standard, or Premium. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.

translate_output_property(prop)

Provides subclasses of Resource an opportunity to translate names of output properties into a format of their choosing before writing those properties to the resource object.

Parameters

prop (str) – A property name.

Returns

A potentially transformed property name.

Return type

str

translate_input_property(prop)

Provides subclasses of Resource an opportunity to translate names of input properties into a format of their choosing before sending those properties to the Pulumi engine.

Parameters

prop (str) – A property name.

Returns

A potentially transformed property name.

Return type

str

class pulumi_azure.mssql.GetElasticPoolResult(location=None, max_size_bytes=None, max_size_gb=None, name=None, per_db_max_capacity=None, per_db_min_capacity=None, resource_group_name=None, server_name=None, tags=None, zone_redundant=None, id=None)

A collection of values returned by getElasticPool.

location = None

Specifies the supported Azure location where the resource exists.

max_size_bytes = None

The max data size of the elastic pool in bytes.

max_size_gb = None

The max data size of the elastic pool in gigabytes.

per_db_max_capacity = None

The maximum capacity any one database can consume.

per_db_min_capacity = None

The minimum capacity all databases are guaranteed.

tags = None

A mapping of tags to assign to the resource.

zone_redundant = None

Whether or not this elastic pool is zone redundant.

id = None

id is the provider-assigned unique ID for this managed resource.

pulumi_azure.mssql.get_elastic_pool(name=None, resource_group_name=None, server_name=None, opts=None)

Use this data source to access information about an existing SQL elastic pool.

Parameters
  • name (str) – The name of the elastic pool.

  • resource_group_name (str) – The name of the resource group which contains the elastic pool.

  • server_name (str) – The name of the SQL Server which contains the elastic pool.