Sql
data class SqlManagedInstanceArgs(val extendedLocation: Output<ExtendedLocationArgs>? = null, val location: Output<String>? = null, val properties: Output<SqlManagedInstancePropertiesArgs>? = null, val resourceGroupName: Output<String>? = null, val sku: Output<SqlManagedInstanceSkuArgs>? = null, val sqlManagedInstanceName: Output<String>? = null, val tags: Output<Map<String, String>>? = null) : ConvertibleToJava<SqlManagedInstanceArgs>
A SqlManagedInstance. Uses Azure REST API version 2023-01-15-preview. In version 1.x of the Azure Native provider, it used API version 2021-06-01-preview. Other available API versions: 2024-01-01, 2024-05-01-preview, 2025-03-01-preview.
Example Usage
Create or update a SQL Managed Instance
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlManagedInstance = new AzureNative.AzureArcData.SqlManagedInstance("sqlManagedInstance", new()
{
ExtendedLocation = new AzureNative.AzureArcData.Inputs.ExtendedLocationArgs
{
Name = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.ExtendedLocation/customLocations/arclocation",
Type = AzureNative.AzureArcData.ExtendedLocationTypes.CustomLocation,
},
Location = "northeurope",
Properties = new AzureNative.AzureArcData.Inputs.SqlManagedInstancePropertiesArgs
{
ActiveDirectoryInformation = new AzureNative.AzureArcData.Inputs.ActiveDirectoryInformationArgs
{
KeytabInformation = new AzureNative.AzureArcData.Inputs.KeytabInformationArgs
{
Keytab = "********",
},
},
Admin = "Admin user",
BasicLoginInformation = new AzureNative.AzureArcData.Inputs.BasicLoginInformationArgs
{
Password = "********",
Username = "username",
},
ClusterId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Kubernetes/connectedClusters/connectedk8s",
EndTime = "Instance end time",
ExtensionId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Kubernetes/connectedClusters/connectedk8s/providers/Microsoft.KubernetesConfiguration/extensions/extension",
K8sRaw = new AzureNative.AzureArcData.Inputs.SqlManagedInstanceK8sRawArgs
{
Spec = new AzureNative.AzureArcData.Inputs.SqlManagedInstanceK8sSpecArgs
{
Replicas = 1,
Scheduling = new AzureNative.AzureArcData.Inputs.K8sSchedulingArgs
{
Default = new AzureNative.AzureArcData.Inputs.K8sSchedulingOptionsArgs
{
Resources = new AzureNative.AzureArcData.Inputs.K8sResourceRequirementsArgs
{
Limits =
{
{ "additionalProperty", "additionalValue" },
{ "cpu", "1" },
{ "memory", "8Gi" },
},
Requests =
{
{ "additionalProperty", "additionalValue" },
{ "cpu", "1" },
{ "memory", "8Gi" },
},
},
},
},
Security = new AzureNative.AzureArcData.Inputs.K8sSecurityArgs
{
ActiveDirectory = new AzureNative.AzureArcData.Inputs.K8sActiveDirectoryArgs
{
AccountName = "Account name",
Connector = new AzureNative.AzureArcData.Inputs.K8sActiveDirectoryConnectorArgs
{
Name = "Name of connector",
Namespace = "Namespace of connector",
},
EncryptionTypes = new[]
{
"Encryption type item1, Encryption type item2,...",
},
KeytabSecret = "Key tab secret of account",
},
AdminLoginSecret = "test-sql-login-secret",
ServiceCertificateSecret = "Service Certificate Secret",
TransparentDataEncryption = new AzureNative.AzureArcData.Inputs.K8stransparentDataEncryptionArgs
{
Mode = "SystemManaged",
},
},
Settings = new AzureNative.AzureArcData.Inputs.K8sSettingsArgs
{
Network = new AzureNative.AzureArcData.Inputs.K8sNetworkSettingsArgs
{
Forceencryption = 0,
Tlsciphers = "ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384",
Tlsprotocols = "1.2",
},
},
},
},
LicenseType = AzureNative.AzureArcData.ArcSqlManagedInstanceLicenseType.LicenseIncluded,
StartTime = "Instance start time",
},
ResourceGroupName = "testrg",
Sku = new AzureNative.AzureArcData.Inputs.SqlManagedInstanceSkuArgs
{
Dev = true,
Name = AzureNative.AzureArcData.SqlManagedInstanceSkuName.VCore,
Tier = AzureNative.AzureArcData.SqlManagedInstanceSkuTier.GeneralPurpose,
},
SqlManagedInstanceName = "testsqlManagedInstance",
Tags =
{
{ "mytag", "myval" },
},
});
});Content copied to clipboard
package main
import (
azurearcdata "github.com/pulumi/pulumi-azure-native-sdk/azurearcdata/v2"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := azurearcdata.NewSqlManagedInstance(ctx, "sqlManagedInstance", &azurearcdata.SqlManagedInstanceArgs{
ExtendedLocation: &azurearcdata.ExtendedLocationArgs{
Name: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.ExtendedLocation/customLocations/arclocation"),
Type: pulumi.String(azurearcdata.ExtendedLocationTypesCustomLocation),
},
Location: pulumi.String("northeurope"),
Properties: &azurearcdata.SqlManagedInstancePropertiesArgs{
ActiveDirectoryInformation: &azurearcdata.ActiveDirectoryInformationArgs{
KeytabInformation: &azurearcdata.KeytabInformationArgs{
Keytab: pulumi.String("********"),
},
},
Admin: pulumi.String("Admin user"),
BasicLoginInformation: &azurearcdata.BasicLoginInformationArgs{
Password: pulumi.String("********"),
Username: pulumi.String("username"),
},
ClusterId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Kubernetes/connectedClusters/connectedk8s"),
EndTime: pulumi.String("Instance end time"),
ExtensionId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Kubernetes/connectedClusters/connectedk8s/providers/Microsoft.KubernetesConfiguration/extensions/extension"),
K8sRaw: &azurearcdata.SqlManagedInstanceK8sRawArgs{
Spec: &azurearcdata.SqlManagedInstanceK8sSpecArgs{
Replicas: pulumi.Int(1),
Scheduling: &azurearcdata.K8sSchedulingArgs{
Default: &azurearcdata.K8sSchedulingOptionsArgs{
Resources: &azurearcdata.K8sResourceRequirementsArgs{
Limits: pulumi.StringMap{
"additionalProperty": pulumi.String("additionalValue"),
"cpu": pulumi.String("1"),
"memory": pulumi.String("8Gi"),
},
Requests: pulumi.StringMap{
"additionalProperty": pulumi.String("additionalValue"),
"cpu": pulumi.String("1"),
"memory": pulumi.String("8Gi"),
},
},
},
},
Security: &azurearcdata.K8sSecurityArgs{
ActiveDirectory: &azurearcdata.K8sActiveDirectoryArgs{
AccountName: pulumi.String("Account name"),
Connector: &azurearcdata.K8sActiveDirectoryConnectorArgs{
Name: pulumi.String("Name of connector"),
Namespace: pulumi.String("Namespace of connector"),
},
EncryptionTypes: pulumi.StringArray{
pulumi.String("Encryption type item1, Encryption type item2,..."),
},
KeytabSecret: pulumi.String("Key tab secret of account"),
},
AdminLoginSecret: pulumi.String("test-sql-login-secret"),
ServiceCertificateSecret: pulumi.String("Service Certificate Secret"),
TransparentDataEncryption: &azurearcdata.K8stransparentDataEncryptionArgs{
Mode: pulumi.String("SystemManaged"),
},
},
Settings: &azurearcdata.K8sSettingsArgs{
Network: &azurearcdata.K8sNetworkSettingsArgs{
Forceencryption: pulumi.Int(0),
Tlsciphers: pulumi.String("ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384"),
Tlsprotocols: pulumi.String("1.2"),
},
},
},
},
LicenseType: pulumi.String(azurearcdata.ArcSqlManagedInstanceLicenseTypeLicenseIncluded),
StartTime: pulumi.String("Instance start time"),
},
ResourceGroupName: pulumi.String("testrg"),
Sku: &azurearcdata.SqlManagedInstanceSkuArgs{
Dev: pulumi.Bool(true),
Name: azurearcdata.SqlManagedInstanceSkuNameVCore,
Tier: azurearcdata.SqlManagedInstanceSkuTierGeneralPurpose,
},
SqlManagedInstanceName: pulumi.String("testsqlManagedInstance"),
Tags: pulumi.StringMap{
"mytag": pulumi.String("myval"),
},
})
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.azurearcdata.SqlManagedInstance;
import com.pulumi.azurenative.azurearcdata.SqlManagedInstanceArgs;
import com.pulumi.azurenative.azurearcdata.inputs.ExtendedLocationArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlManagedInstancePropertiesArgs;
import com.pulumi.azurenative.azurearcdata.inputs.ActiveDirectoryInformationArgs;
import com.pulumi.azurenative.azurearcdata.inputs.KeytabInformationArgs;
import com.pulumi.azurenative.azurearcdata.inputs.BasicLoginInformationArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlManagedInstanceK8sRawArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlManagedInstanceK8sSpecArgs;
import com.pulumi.azurenative.azurearcdata.inputs.K8sSchedulingArgs;
import com.pulumi.azurenative.azurearcdata.inputs.K8sSchedulingOptionsArgs;
import com.pulumi.azurenative.azurearcdata.inputs.K8sResourceRequirementsArgs;
import com.pulumi.azurenative.azurearcdata.inputs.K8sSecurityArgs;
import com.pulumi.azurenative.azurearcdata.inputs.K8sActiveDirectoryArgs;
import com.pulumi.azurenative.azurearcdata.inputs.K8sActiveDirectoryConnectorArgs;
import com.pulumi.azurenative.azurearcdata.inputs.K8stransparentDataEncryptionArgs;
import com.pulumi.azurenative.azurearcdata.inputs.K8sSettingsArgs;
import com.pulumi.azurenative.azurearcdata.inputs.K8sNetworkSettingsArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlManagedInstanceSkuArgs;
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 sqlManagedInstance = new SqlManagedInstance("sqlManagedInstance", SqlManagedInstanceArgs.builder()
.extendedLocation(ExtendedLocationArgs.builder()
.name("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.ExtendedLocation/customLocations/arclocation")
.type("CustomLocation")
.build())
.location("northeurope")
.properties(SqlManagedInstancePropertiesArgs.builder()
.activeDirectoryInformation(ActiveDirectoryInformationArgs.builder()
.keytabInformation(KeytabInformationArgs.builder()
.keytab("********")
.build())
.build())
.admin("Admin user")
.basicLoginInformation(BasicLoginInformationArgs.builder()
.password("********")
.username("username")
.build())
.clusterId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Kubernetes/connectedClusters/connectedk8s")
.endTime("Instance end time")
.extensionId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Kubernetes/connectedClusters/connectedk8s/providers/Microsoft.KubernetesConfiguration/extensions/extension")
.k8sRaw(SqlManagedInstanceK8sRawArgs.builder()
.spec(SqlManagedInstanceK8sSpecArgs.builder()
.replicas(1)
.scheduling(K8sSchedulingArgs.builder()
.default_(K8sSchedulingOptionsArgs.builder()
.resources(K8sResourceRequirementsArgs.builder()
.limits(Map.ofEntries(
Map.entry("additionalProperty", "additionalValue"),
Map.entry("cpu", "1"),
Map.entry("memory", "8Gi")
))
.requests(Map.ofEntries(
Map.entry("additionalProperty", "additionalValue"),
Map.entry("cpu", "1"),
Map.entry("memory", "8Gi")
))
.build())
.build())
.build())
.security(K8sSecurityArgs.builder()
.activeDirectory(K8sActiveDirectoryArgs.builder()
.accountName("Account name")
.connector(K8sActiveDirectoryConnectorArgs.builder()
.name("Name of connector")
.namespace("Namespace of connector")
.build())
.encryptionTypes("Encryption type item1, Encryption type item2,...")
.keytabSecret("Key tab secret of account")
.build())
.adminLoginSecret("test-sql-login-secret")
.serviceCertificateSecret("Service Certificate Secret")
.transparentDataEncryption(K8stransparentDataEncryptionArgs.builder()
.mode("SystemManaged")
.build())
.build())
.settings(K8sSettingsArgs.builder()
.network(K8sNetworkSettingsArgs.builder()
.forceencryption(0)
.tlsciphers("ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384")
.tlsprotocols("1.2")
.build())
.build())
.build())
.build())
.licenseType("LicenseIncluded")
.startTime("Instance start time")
.build())
.resourceGroupName("testrg")
.sku(SqlManagedInstanceSkuArgs.builder()
.dev(true)
.name("vCore")
.tier("GeneralPurpose")
.build())
.sqlManagedInstanceName("testsqlManagedInstance")
.tags(Map.of("mytag", "myval"))
.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:azurearcdata:SqlManagedInstance testsqlManagedInstance /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.AzureArcData/sqlManagedInstances/{sqlManagedInstanceName}Content copied to clipboard
Constructors
Link copied to clipboard
constructor(extendedLocation: Output<ExtendedLocationArgs>? = null, location: Output<String>? = null, properties: Output<SqlManagedInstancePropertiesArgs>? = null, resourceGroupName: Output<String>? = null, sku: Output<SqlManagedInstanceSkuArgs>? = null, sqlManagedInstanceName: Output<String>? = null, tags: Output<Map<String, String>>? = null)