Sql Pool Args
A SQL Analytics pool API Version: 2021-03-01.
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 = "LRS",
Tags = null,
WorkspaceName = "ExampleWorkspace",
});
});
package main
import (
synapse "github.com/pulumi/pulumi-azure-native-sdk/synapse"
"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("LRS"),
Tags: nil,
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 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(Map.ofEntries(
Map.entry("name", ""),
Map.entry("tier", "")
))
.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/01234567-89ab-4def-0123-456789abcdef/resourceGroups/ExampleResourceGroup/providers/Microsoft.Synapse/workspaces/ExampleWorkspaces/sqlPools/ExampleSqlPool
Constructors
Properties
Specifies the mode of sql pool creation. Default: regular sql pool creation. PointInTimeRestore: Creates a sql pool by restoring a point in time backup of an existing sql pool. sourceDatabaseId must be specified as the resource ID of the existing sql pool, and restorePointInTime must be specified. Recovery: Creates a sql pool by a geo-replicated backup. sourceDatabaseId must be specified as the recoverableDatabaseId to restore. Restore: Creates a sql pool by restoring a backup of a deleted sql pool. SourceDatabaseId should be the sql pool's original resource ID. SourceDatabaseId and sourceDatabaseDeletionDate must be specified.
Date the SQL pool was created
Maximum size in bytes
Resource state
Backup database to restore from
The name of the resource group. The name is case insensitive.
Snapshot time to restore
Source database to create from
SQL pool name
The storage account type used to store backups for this sql pool.
The name of the workspace