1. Docs
  2. Reference
  3. API
  4. Azure
  5. mssql
  6. GetElasticPool

GetElasticPool

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

Example Usage

using Pulumi;
using Azure = Pulumi.Azure;

class MyStack : Stack
{
    public MyStack()
    {
        var example = Output.Create(Azure.MSSql.GetElasticPool.InvokeAsync(new Azure.MSSql.GetElasticPoolArgs
        {
            Name = "mssqlelasticpoolname",
            ResourceGroupName = "example-resources",
            ServerName = "example-sql-server",
        }));
        this.ElasticpoolId = example.Apply(example => example.Id);
    }

    [Output("elasticpoolId")]
    public Output<string> ElasticpoolId { get; set; }
}

package main

import (
    "github.com/pulumi/pulumi-azure/sdk/v3/go/azure/mssql"
    "github.com/pulumi/pulumi/sdk/v2/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
    })
}
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)
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);

Using GetElasticPool

function getElasticPool(args: GetElasticPoolArgs, opts?: InvokeOptions): Promise<GetElasticPoolResult>
function  get_elastic_pool(name=None, resource_group_name=None, server_name=None, opts=None)
func LookupElasticPool(ctx *Context, args *LookupElasticPoolArgs, opts ...InvokeOption) (*LookupElasticPoolResult, error)

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

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

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 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.

GetElasticPool Result

The following output properties are available:

Id string

The provider-assigned unique ID for this managed resource.

LicenseType string

The license type to apply for this database.

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
PerDbMaxCapacity int

The maximum capacity any one database can consume.

PerDbMinCapacity int

The minimum capacity all databases are guaranteed.

ResourceGroupName string
ServerName string
Tags Dictionary<string, string>

A mapping of tags to assign to the resource.

ZoneRedundant bool

Whether or not this elastic pool is zone redundant.

Id string

The provider-assigned unique ID for this managed resource.

LicenseType string

The license type to apply for this database.

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
PerDbMaxCapacity int

The maximum capacity any one database can consume.

PerDbMinCapacity int

The minimum capacity all databases are guaranteed.

ResourceGroupName string
ServerName string
Tags map[string]string

A mapping of tags to assign to the resource.

ZoneRedundant bool

Whether or not this elastic pool is zone redundant.

id string

The provider-assigned unique ID for this managed resource.

licenseType string

The license type to apply for this database.

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
perDbMaxCapacity number

The maximum capacity any one database can consume.

perDbMinCapacity number

The minimum capacity all databases are guaranteed.

resourceGroupName string
serverName string
tags {[key: string]: string}

A mapping of tags to assign to the resource.

zoneRedundant boolean

Whether or not this elastic pool is zone redundant.

id str

The provider-assigned unique ID for this managed resource.

license_type str

The license type to apply for this database.

location str

Specifies the supported Azure location where the resource exists.

max_size_bytes float

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
per_db_max_capacity float

The maximum capacity any one database can consume.

per_db_min_capacity float

The minimum capacity all databases are guaranteed.

resource_group_name str
server_name str
tags Dict[str, str]

A mapping of tags to assign to the resource.

zone_redundant bool

Whether or not this elastic pool is zone redundant.

Package Details

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