SqlPool

class SqlPool : KotlinCustomResource

A SQL Analytics pool Uses Azure REST API version 2021-06-01. In version 2.x of the Azure Native provider, it used API version 2021-06-01. Other available API versions: 2021-04-01-preview, 2021-05-01, 2021-06-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native synapse [ApiVersion]. See the ../../../version-guide/#accessing-any-api-version-via-local-packages for details.

Example Usage

Create a SQL Analytics pool

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlPool = new AzureNative.Synapse.SqlPool("sqlPool", new()
{
Collation = "",
CreateMode = "",
Location = "Southeast Asia",
MaxSizeBytes = 0,
RecoverableDatabaseId = "",
ResourceGroupName = "ExampleResourceGroup",
Sku = new AzureNative.Synapse.Inputs.SkuArgs
{
Name = "",
Tier = "",
},
SourceDatabaseId = "",
SqlPoolName = "ExampleSqlPool",
StorageAccountType = AzureNative.Synapse.StorageAccountType.LRS,
Tags = null,
WorkspaceName = "ExampleWorkspace",
});
});
package main
import (
synapse "github.com/pulumi/pulumi-azure-native-sdk/synapse/v2"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := synapse.NewSqlPool(ctx, "sqlPool", &synapse.SqlPoolArgs{
Collation: pulumi.String(""),
CreateMode: pulumi.String(""),
Location: pulumi.String("Southeast Asia"),
MaxSizeBytes: pulumi.Float64(0),
RecoverableDatabaseId: pulumi.String(""),
ResourceGroupName: pulumi.String("ExampleResourceGroup"),
Sku: &synapse.SkuArgs{
Name: pulumi.String(""),
Tier: pulumi.String(""),
},
SourceDatabaseId: pulumi.String(""),
SqlPoolName: pulumi.String("ExampleSqlPool"),
StorageAccountType: pulumi.String(synapse.StorageAccountTypeLRS),
Tags: pulumi.StringMap{},
WorkspaceName: pulumi.String("ExampleWorkspace"),
})
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.azurenative.synapse.SqlPool;
import com.pulumi.azurenative.synapse.SqlPoolArgs;
import com.pulumi.azurenative.synapse.inputs.SkuArgs;
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 sqlPool = new SqlPool("sqlPool", SqlPoolArgs.builder()
.collation("")
.createMode("")
.location("Southeast Asia")
.maxSizeBytes(0)
.recoverableDatabaseId("")
.resourceGroupName("ExampleResourceGroup")
.sku(SkuArgs.builder()
.name("")
.tier("")
.build())
.sourceDatabaseId("")
.sqlPoolName("ExampleSqlPool")
.storageAccountType("LRS")
.tags()
.workspaceName("ExampleWorkspace")
.build());
}
}

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:synapse:SqlPool ExampleSqlPool /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}

Properties

Link copied to clipboard
val azureApiVersion: Output<String>

The Azure API version of the resource.

Link copied to clipboard
val collation: Output<String>?

Collation mode

Link copied to clipboard
val creationDate: Output<String>

Date the SQL pool was created

Link copied to clipboard
val id: Output<String>
Link copied to clipboard
val location: Output<String>

The geo-location where the resource lives

Link copied to clipboard
val maxSizeBytes: Output<Double>?

Maximum size in bytes

Link copied to clipboard
val name: Output<String>

The name of the resource

Link copied to clipboard

Resource state

Link copied to clipboard
val pulumiChildResources: Set<KotlinResource>
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard

Backup database to restore from

Link copied to clipboard

Snapshot time to restore

Link copied to clipboard
val sku: Output<SkuResponse>?

SQL pool SKU

Link copied to clipboard

Specifies the time that the sql pool was deleted

Link copied to clipboard
val status: Output<String>

Resource status

Link copied to clipboard

The storage account type used to store backups for this sql pool.

Link copied to clipboard
val tags: Output<Map<String, String>>?

Resource tags.

Link copied to clipboard
val type: Output<String>

The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Link copied to clipboard
val urn: Output<String>