get Elastic Pool
Use this data source to access information about an existing SQL elastic pool.
Example Usage
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);
Content copied to clipboard
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)
Content copied to clipboard
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),
};
});
Content copied to clipboard
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
})
}
Content copied to clipboard
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()));
}
}
Content copied to clipboard
variables:
example:
fn::invoke:
function: azure:mssql:getElasticPool
arguments:
name: mssqlelasticpoolname
resourceGroupName: example-resources
serverName: example-sql-server
outputs:
elasticpoolId: ${example.id}
Content copied to clipboard
Return
A collection of values returned by getElasticPool.
Parameters
argument
A collection of arguments for invoking getElasticPool.
suspend fun getElasticPool(name: String, resourceGroupName: String, serverName: String): GetElasticPoolResult
Return
A collection of values returned by getElasticPool.
Parameters
name
The name of the elastic pool.
resource Group Name
The name of the resource group which contains the elastic pool.
server Name
The name of the SQL Server which contains the elastic pool.
See also
suspend fun getElasticPool(argument: suspend GetElasticPoolPlainArgsBuilder.() -> Unit): GetElasticPoolResult
Return
A collection of values returned by getElasticPool.
Parameters
argument
Builder for com.pulumi.azure.mssql.kotlin.inputs.GetElasticPoolPlainArgs.