Sql Pool
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
The Azure API version of the resource.
Date the SQL pool was created
Maximum size in bytes
Resource state
Backup database to restore from
Snapshot time to restore
SQL pool SKU
Specifies the time that the sql pool was deleted
The storage account type used to store backups for this sql pool.