Sql Pool
A SQL Analytics pool Uses Azure REST API version 2021-06-01. In version 1.x of the Azure Native provider, it used API version 2021-03-01. Other available API versions: 2021-05-01, 2021-06-01-preview.
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",
});
});
Content copied to clipboard
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
})
}
Content copied to clipboard
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());
}
}
Content copied to clipboard
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}
Content copied to clipboard
Properties
Link copied to clipboard
Date the SQL pool was created
Link copied to clipboard
Maximum size in bytes
Link copied to clipboard
Resource state
Link copied to clipboard
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
SQL pool SKU
Link copied to clipboard
Specifies the time that the sql pool was deleted
Link copied to clipboard
The storage account type used to store backups for this sql pool.