SqlPoolArgs

data class SqlPoolArgs(val collation: Output<String>? = null, val createMode: Output<String>? = null, val dataEncrypted: Output<Boolean>? = null, val geoBackupPolicyEnabled: Output<Boolean>? = null, val name: Output<String>? = null, val recoveryDatabaseId: Output<String>? = null, val restore: Output<SqlPoolRestoreArgs>? = null, val skuName: Output<String>? = null, val storageAccountType: Output<String>? = null, val synapseWorkspaceId: Output<String>? = null, val tags: Output<Map<String, String>>? = null) : ConvertibleToJava<SqlPoolArgs>

Manages a Synapse SQL Pool.

Example Usage

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.storage.Account;
import com.pulumi.azure.storage.AccountArgs;
import com.pulumi.azure.storage.DataLakeGen2Filesystem;
import com.pulumi.azure.storage.DataLakeGen2FilesystemArgs;
import com.pulumi.azure.synapse.Workspace;
import com.pulumi.azure.synapse.WorkspaceArgs;
import com.pulumi.azure.synapse.inputs.WorkspaceIdentityArgs;
import com.pulumi.azure.synapse.SqlPool;
import com.pulumi.azure.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 example = new ResourceGroup("example", ResourceGroupArgs.builder()
.name("example-resources")
.location("West Europe")
.build());
var exampleAccount = new Account("exampleAccount", AccountArgs.builder()
.name("examplestorageacc")
.resourceGroupName(example.name())
.location(example.location())
.accountTier("Standard")
.accountReplicationType("LRS")
.accountKind("BlobStorage")
.build());
var exampleDataLakeGen2Filesystem = new DataLakeGen2Filesystem("exampleDataLakeGen2Filesystem", DataLakeGen2FilesystemArgs.builder()
.name("example")
.storageAccountId(exampleAccount.id())
.build());
var exampleWorkspace = new Workspace("exampleWorkspace", WorkspaceArgs.builder()
.name("example")
.resourceGroupName(example.name())
.location(example.location())
.storageDataLakeGen2FilesystemId(exampleDataLakeGen2Filesystem.id())
.sqlAdministratorLogin("sqladminuser")
.sqlAdministratorLoginPassword("H@Sh1CoR3!")
.identity(WorkspaceIdentityArgs.builder()
.type("SystemAssigned")
.build())
.build());
var exampleSqlPool = new SqlPool("exampleSqlPool", SqlPoolArgs.builder()
.name("examplesqlpool")
.synapseWorkspaceId(exampleWorkspace.id())
.skuName("DW100c")
.createMode("Default")
.storageAccountType("GRS")
.build());
}
}

Import

Synapse SQL Pool can be imported using the resource id, e.g.

$ pulumi import azure:synapse/sqlPool:SqlPool example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/group1/providers/Microsoft.Synapse/workspaces/workspace1/sqlPools/sqlPool1

Constructors

Link copied to clipboard
fun SqlPoolArgs(collation: Output<String>? = null, createMode: Output<String>? = null, dataEncrypted: Output<Boolean>? = null, geoBackupPolicyEnabled: Output<Boolean>? = null, name: Output<String>? = null, recoveryDatabaseId: Output<String>? = null, restore: Output<SqlPoolRestoreArgs>? = null, skuName: Output<String>? = null, storageAccountType: Output<String>? = null, synapseWorkspaceId: Output<String>? = null, tags: Output<Map<String, String>>? = null)

Functions

Link copied to clipboard
open override fun toJava(): SqlPoolArgs

Properties

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

The name of the collation to use with this pool, only applicable when create_mode is set to Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new Synapse SQL Pool to be created.

Link copied to clipboard
val createMode: Output<String>? = null

Specifies how to create the SQL Pool. Valid values are: Default, Recovery or PointInTimeRestore. Must be Default to create a new database. Defaults to Default. Changing this forces a new Synapse SQL Pool to be created.

Link copied to clipboard
val dataEncrypted: Output<Boolean>? = null

Is transparent data encryption enabled?

Link copied to clipboard
val geoBackupPolicyEnabled: Output<Boolean>? = null

Is geo-backup policy enabled? Possible values include true or false. Defaults to true.

Link copied to clipboard
val name: Output<String>? = null

The name which should be used for this Synapse SQL Pool. Changing this forces a new Synapse SQL Pool to be created.

Link copied to clipboard
val recoveryDatabaseId: Output<String>? = null

The ID of the Synapse SQL Pool or SQL Database which is to back up, only applicable when create_mode is set to Recovery. Changing this forces a new Synapse SQL Pool to be created.

Link copied to clipboard
val restore: Output<SqlPoolRestoreArgs>? = null

A restore block as defined below. Only applicable when create_mode is set to PointInTimeRestore. Changing this forces a new Synapse SQL Pool to be created.

Link copied to clipboard
val skuName: Output<String>? = null

Specifies the SKU Name for this Synapse SQL Pool. Possible values are DW100c, DW200c, DW300c, DW400c, DW500c, DW1000c, DW1500c, DW2000c, DW2500c, DW3000c, DW5000c, DW6000c, DW7500c, DW10000c, DW15000c or DW30000c.

Link copied to clipboard
val storageAccountType: Output<String>? = null

The storage account type that will be used to store backups for this Synapse SQL Pool. Possible values are LRS or GRS. Changing this forces a new Synapse SQL Pool to be created. Defaults to GRS.

Link copied to clipboard
val synapseWorkspaceId: Output<String>? = null

The ID of Synapse Workspace within which this SQL Pool should be created. Changing this forces a new Synapse SQL Pool to be created.

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

A mapping of tags which should be assigned to the Synapse SQL Pool.