Azure v6.22.0, Apr 1 25

We recommend using Azure Native.

Azure v6.22.0 published on Tuesday, Apr 1, 2025 by Pulumi

azure.mssql.getElasticPool

Explore with Pulumi AI

We recommend using Azure Native.

Azure v6.22.0 published on Tuesday, Apr 1, 2025 by Pulumi

pulumi/pulumi-azure

Example Usage

TypeScript
Python
Go
C#
Java
YAML

import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";

const example = azure.mssql.getElasticPool({
    name: "mssqlelasticpoolname",
    resourceGroupName: "example-resources",
    serverName: "example-sql-server",
});
export const elasticpoolId = example.then(example => example.id);

import pulumi
import pulumi_azure as azure

example = azure.mssql.get_elastic_pool(name="mssqlelasticpoolname",
    resource_group_name="example-resources",
    server_name="example-sql-server")
pulumi.export("elasticpoolId", example.id)

package main

import (
	"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 := mssql.LookupElasticPool(ctx, &mssql.LookupElasticPoolArgs{
			Name:              "mssqlelasticpoolname",
			ResourceGroupName: "example-resources",
			ServerName:        "example-sql-server",
		}, nil)
		if err != nil {
			return err
		}
		ctx.Export("elasticpoolId", example.Id)
		return nil
	})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;

return await Deployment.RunAsync(() => 
{
    var example = Azure.MSSql.GetElasticPool.Invoke(new()
    {
        Name = "mssqlelasticpoolname",
        ResourceGroupName = "example-resources",
        ServerName = "example-sql-server",
    });

    return new Dictionary<string, object?>
    {
        ["elasticpoolId"] = example.Apply(getElasticPoolResult => getElasticPoolResult.Id),
    };
});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.mssql.MssqlFunctions;
import com.pulumi.azure.mssql.inputs.GetElasticPoolArgs;
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) {
        final var example = MssqlFunctions.getElasticPool(GetElasticPoolArgs.builder()
            .name("mssqlelasticpoolname")
            .resourceGroupName("example-resources")
            .serverName("example-sql-server")
            .build());

        ctx.export("elasticpoolId", example.applyValue(getElasticPoolResult -> getElasticPoolResult.id()));
    }
}

variables:
  example:
    fn::invoke:
      function: azure:mssql:getElasticPool
      arguments:
        name: mssqlelasticpoolname
        resourceGroupName: example-resources
        serverName: example-sql-server
outputs:
  elasticpoolId: ${example.id}

Using getElasticPool

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

TypeScript
Python
Go
C#
Java
YAML

function getElasticPool(args: GetElasticPoolArgs, opts?: InvokeOptions): Promise<GetElasticPoolResult>
function getElasticPoolOutput(args: GetElasticPoolOutputArgs, opts?: InvokeOptions): Output<GetElasticPoolResult>

def get_elastic_pool(name: Optional[str] = None,
                     resource_group_name: Optional[str] = None,
                     server_name: Optional[str] = None,
                     opts: Optional[InvokeOptions] = None) -> GetElasticPoolResult
def get_elastic_pool_output(name: Optional[pulumi.Input[str]] = None,
                     resource_group_name: Optional[pulumi.Input[str]] = None,
                     server_name: Optional[pulumi.Input[str]] = None,
                     opts: Optional[InvokeOptions] = None) -> Output[GetElasticPoolResult]

func LookupElasticPool(ctx *Context, args *LookupElasticPoolArgs, opts ...InvokeOption) (*LookupElasticPoolResult, error)
func LookupElasticPoolOutput(ctx *Context, args *LookupElasticPoolOutputArgs, opts ...InvokeOption) LookupElasticPoolResultOutput

> Note: This function is named LookupElasticPool in the Go SDK.

public static class GetElasticPool 
{
    public static Task<GetElasticPoolResult> InvokeAsync(GetElasticPoolArgs args, InvokeOptions? opts = null)
    public static Output<GetElasticPoolResult> Invoke(GetElasticPoolInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetElasticPoolResult> getElasticPool(GetElasticPoolArgs args, InvokeOptions options)
public static Output<GetElasticPoolResult> getElasticPool(GetElasticPoolArgs args, InvokeOptions options)

fn::invoke:
  function: azure:mssql/getElasticPool:getElasticPool
  arguments:
    # arguments dictionary

The following arguments are supported:

Name string: The name of the elastic pool.
ResourceGroupName string: The name of the resource group which contains the elastic pool.
ServerName string: The name of the SQL Server which contains the elastic pool.

Name string: The name of the elastic pool.
ResourceGroupName string: The name of the resource group which contains the elastic pool.
ServerName string: The name of the SQL Server which contains the elastic pool.

name String: The name of the elastic pool.
resourceGroupName String: The name of the resource group which contains the elastic pool.
serverName String: The name of the SQL Server which contains the elastic pool.

name string: The name of the elastic pool.
resourceGroupName string: The name of the resource group which contains the elastic pool.
serverName string: The name of the SQL Server which contains the elastic pool.

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.

name String: The name of the elastic pool.
resourceGroupName String: The name of the resource group which contains the elastic pool.
serverName String: The name of the SQL Server which contains the elastic pool.

getElasticPool Result

The following output properties are available:

EnclaveType string: The type of enclave being used by the elastic pool.
Id string: The provider-assigned unique ID for this managed resource.
LicenseType string: The license type to apply for this elastic pool.
Location string: Specifies the supported Azure location where the resource exists.
MaxSizeBytes int: The max data size of the elastic pool in bytes.
MaxSizeGb double: The max data size of the elastic pool in gigabytes.
Name string: Specifies the SKU Name for this Elasticpool.
PerDbMaxCapacity int: The maximum capacity any one database can consume.
PerDbMinCapacity int: The minimum capacity all databases are guaranteed.
ResourceGroupName string
ServerName string
Skus List<GetElasticPoolSkus>: A sku block as defined below.
Tags Dictionary<string, string>: A mapping of tags to assign to the resource.
ZoneRedundant bool: Whether or not this elastic pool is zone redundant.

EnclaveType string: The type of enclave being used by the elastic pool.
Id string: The provider-assigned unique ID for this managed resource.
LicenseType string: The license type to apply for this elastic pool.
Location string: Specifies the supported Azure location where the resource exists.
MaxSizeBytes int: The max data size of the elastic pool in bytes.
MaxSizeGb float64: The max data size of the elastic pool in gigabytes.
Name string: Specifies the SKU Name for this Elasticpool.
PerDbMaxCapacity int: The maximum capacity any one database can consume.
PerDbMinCapacity int: The minimum capacity all databases are guaranteed.
ResourceGroupName string
ServerName string
Skus []GetElasticPoolSkus: A sku block as defined below.
Tags map[string]string: A mapping of tags to assign to the resource.
ZoneRedundant bool: Whether or not this elastic pool is zone redundant.

enclaveType String: The type of enclave being used by the elastic pool.
id String: The provider-assigned unique ID for this managed resource.
licenseType String: The license type to apply for this elastic pool.
location String: Specifies the supported Azure location where the resource exists.
maxSizeBytes Integer: The max data size of the elastic pool in bytes.
maxSizeGb Double: The max data size of the elastic pool in gigabytes.
name String: Specifies the SKU Name for this Elasticpool.
perDbMaxCapacity Integer: The maximum capacity any one database can consume.
perDbMinCapacity Integer: The minimum capacity all databases are guaranteed.
resourceGroupName String
serverName String
skus List<GetElasticPoolSkus>: A sku block as defined below.
tags Map<String,String>: A mapping of tags to assign to the resource.
zoneRedundant Boolean: Whether or not this elastic pool is zone redundant.

enclaveType string: The type of enclave being used by the elastic pool.
id string: The provider-assigned unique ID for this managed resource.
licenseType string: The license type to apply for this elastic pool.
location string: Specifies the supported Azure location where the resource exists.
maxSizeBytes number: The max data size of the elastic pool in bytes.
maxSizeGb number: The max data size of the elastic pool in gigabytes.
name string: Specifies the SKU Name for this Elasticpool.
perDbMaxCapacity number: The maximum capacity any one database can consume.
perDbMinCapacity number: The minimum capacity all databases are guaranteed.
resourceGroupName string
serverName string
skus GetElasticPoolSkus[]: A sku block as defined below.
tags {[key: string]: string}: A mapping of tags to assign to the resource.
zoneRedundant boolean: Whether or not this elastic pool is zone redundant.

enclave_type str: The type of enclave being used by the elastic pool.
id str: The provider-assigned unique ID for this managed resource.
license_type str: The license type to apply for this elastic pool.
location str: Specifies the supported Azure location where the resource exists.
max_size_bytes int: The max data size of the elastic pool in bytes.
max_size_gb float: The max data size of the elastic pool in gigabytes.
name str: Specifies the SKU Name for this Elasticpool.
per_db_max_capacity int: The maximum capacity any one database can consume.
per_db_min_capacity int: The minimum capacity all databases are guaranteed.
resource_group_name str
server_name str
skus Sequence[GetElasticPoolSkus]: A sku block as defined below.
tags Mapping[str, str]: A mapping of tags to assign to the resource.
zone_redundant bool: Whether or not this elastic pool is zone redundant.

enclaveType String: The type of enclave being used by the elastic pool.
id String: The provider-assigned unique ID for this managed resource.
licenseType String: The license type to apply for this elastic pool.
location String: Specifies the supported Azure location where the resource exists.
maxSizeBytes Number: The max data size of the elastic pool in bytes.
maxSizeGb Number: The max data size of the elastic pool in gigabytes.
name String: Specifies the SKU Name for this Elasticpool.
perDbMaxCapacity Number: The maximum capacity any one database can consume.
perDbMinCapacity Number: The minimum capacity all databases are guaranteed.
resourceGroupName String
serverName String
skus List<Property Map>: A sku block as defined below.
tags Map<String>: A mapping of tags to assign to the resource.
zoneRedundant Boolean: Whether or not this elastic pool is zone redundant.

Supporting Types

GetElasticPoolSkus

Capacity int: The scale up/out capacity, representing server's compute units.
Family string: The family of hardware.
Name string: The name of the elastic pool.
Tier string: The tier of the particular SKU.

Capacity int: The scale up/out capacity, representing server's compute units.
Family string: The family of hardware.
Name string: The name of the elastic pool.
Tier string: The tier of the particular SKU.

capacity Integer: The scale up/out capacity, representing server's compute units.
family String: The family of hardware.
name String: The name of the elastic pool.
tier String: The tier of the particular SKU.

capacity number: The scale up/out capacity, representing server's compute units.
family string: The family of hardware.
name string: The name of the elastic pool.
tier string: The tier of the particular SKU.

capacity int: The scale up/out capacity, representing server's compute units.
family str: The family of hardware.
name str: The name of the elastic pool.
tier str: The tier of the particular SKU.

capacity Number: The scale up/out capacity, representing server's compute units.
family String: The family of hardware.
name String: The name of the elastic pool.
tier String: The tier of the particular SKU.

Package Details

Repository: Azure Classic pulumi/pulumi-azure
License: Apache-2.0
Notes: This Pulumi package is based on the azurerm Terraform Provider.

We recommend using Azure Native.

Azure v6.22.0 published on Tuesday, Apr 1, 2025 by Pulumi

pulumi/pulumi-azure

azure.mssql.getElasticPool

On this page

On this page

Example Usage

Using getElasticPool

getElasticPool Result

Supporting Types

GetElasticPoolSkus

Package Details

On this page

On this page