1. Packages
  2. Azure Classic
  3. API Docs
  4. sql
  5. Database

We recommend using Azure Native.

Viewing docs for Azure v4.42.0 (Older version)
published on Monday, Mar 9, 2026 by Pulumi
Go to latest version
Schema (JSON)
pulumi/pulumi-azure

azure.sql.Database

azure logo

We recommend using Azure Native.

Viewing docs for Azure v4.42.0 (Older version)
published on Monday, Mar 9, 2026 by Pulumi
Go to latest version
Schema (JSON)
pulumi/pulumi-azure

    Import

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

     $ pulumi import azure:sql/database:Database database1 /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/servers/myserver/databases/database1

    Example Usage

    using Pulumi;
using Azure = Pulumi.Azure;

class MyStack : Stack
{
    public MyStack()
    {
        var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new Azure.Core.ResourceGroupArgs
        {
            Location = "West Europe",
        });
        var exampleSqlServer = new Azure.Sql.SqlServer("exampleSqlServer", new Azure.Sql.SqlServerArgs
        {
            ResourceGroupName = exampleResourceGroup.Name,
            Location = "West US",
            Version = "12.0",
            AdministratorLogin = "4dm1n157r470r",
            AdministratorLoginPassword = "4-v3ry-53cr37-p455w0rd",
            Tags = 
            {
                { "environment", "production" },
            },
        });
        var exampleAccount = new Azure.Storage.Account("exampleAccount", new Azure.Storage.AccountArgs
        {
            ResourceGroupName = exampleResourceGroup.Name,
            Location = exampleResourceGroup.Location,
            AccountTier = "Standard",
            AccountReplicationType = "LRS",
        });
        var exampleDatabase = new Azure.Sql.Database("exampleDatabase", new Azure.Sql.DatabaseArgs
        {
            ResourceGroupName = exampleResourceGroup.Name,
            Location = "West US",
            ServerName = exampleSqlServer.Name,
            ExtendedAuditingPolicy = new Azure.Sql.Inputs.DatabaseExtendedAuditingPolicyArgs
            {
                StorageEndpoint = exampleAccount.PrimaryBlobEndpoint,
                StorageAccountAccessKey = exampleAccount.PrimaryAccessKey,
                StorageAccountAccessKeyIsSecondary = true,
                RetentionInDays = 6,
            },
            Tags = 
            {
                { "environment", "production" },
            },
        });
    }

}

    package main

import (
	"github.com/pulumi/pulumi-azure/sdk/v4/go/azure/core"
	"github.com/pulumi/pulumi-azure/sdk/v4/go/azure/sql"
	"github.com/pulumi/pulumi-azure/sdk/v4/go/azure/storage"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		exampleResourceGroup, err := core.NewResourceGroup(ctx, "exampleResourceGroup", &core.ResourceGroupArgs{
			Location: pulumi.String("West Europe"),
		})
		if err != nil {
			return err
		}
		exampleSqlServer, err := sql.NewSqlServer(ctx, "exampleSqlServer", &sql.SqlServerArgs{
			ResourceGroupName:          exampleResourceGroup.Name,
			Location:                   pulumi.String("West US"),
			Version:                    pulumi.String("12.0"),
			AdministratorLogin:         pulumi.String("4dm1n157r470r"),
			AdministratorLoginPassword: pulumi.String("4-v3ry-53cr37-p455w0rd"),
			Tags: pulumi.StringMap{
				"environment": pulumi.String("production"),
			},
		})
		if err != nil {
			return err
		}
		exampleAccount, err := storage.NewAccount(ctx, "exampleAccount", &storage.AccountArgs{
			ResourceGroupName:      exampleResourceGroup.Name,
			Location:               exampleResourceGroup.Location,
			AccountTier:            pulumi.String("Standard"),
			AccountReplicationType: pulumi.String("LRS"),
		})
		if err != nil {
			return err
		}
		_, err = sql.NewDatabase(ctx, "exampleDatabase", &sql.DatabaseArgs{
			ResourceGroupName: exampleResourceGroup.Name,
			Location:          pulumi.String("West US"),
			ServerName:        exampleSqlServer.Name,
			ExtendedAuditingPolicy: &sql.DatabaseExtendedAuditingPolicyArgs{
				StorageEndpoint:                    exampleAccount.PrimaryBlobEndpoint,
				StorageAccountAccessKey:            exampleAccount.PrimaryAccessKey,
				StorageAccountAccessKeyIsSecondary: pulumi.Bool(true),
				RetentionInDays:                    pulumi.Int(6),
			},
			Tags: pulumi.StringMap{
				"environment": pulumi.String("production"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    Example coming soon!

    import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";

const exampleResourceGroup = new azure.core.ResourceGroup("exampleResourceGroup", {location: "West Europe"});
const exampleSqlServer = new azure.sql.SqlServer("exampleSqlServer", {
    resourceGroupName: exampleResourceGroup.name,
    location: "West US",
    version: "12.0",
    administratorLogin: "4dm1n157r470r",
    administratorLoginPassword: "4-v3ry-53cr37-p455w0rd",
    tags: {
        environment: "production",
    },
});
const exampleAccount = new azure.storage.Account("exampleAccount", {
    resourceGroupName: exampleResourceGroup.name,
    location: exampleResourceGroup.location,
    accountTier: "Standard",
    accountReplicationType: "LRS",
});
const exampleDatabase = new azure.sql.Database("exampleDatabase", {
    resourceGroupName: exampleResourceGroup.name,
    location: "West US",
    serverName: exampleSqlServer.name,
    extendedAuditingPolicy: {
        storageEndpoint: exampleAccount.primaryBlobEndpoint,
        storageAccountAccessKey: exampleAccount.primaryAccessKey,
        storageAccountAccessKeyIsSecondary: true,
        retentionInDays: 6,
    },
    tags: {
        environment: "production",
    },
});

    import pulumi
import pulumi_azure as azure

example_resource_group = azure.core.ResourceGroup("exampleResourceGroup", location="West Europe")
example_sql_server = azure.sql.SqlServer("exampleSqlServer",
    resource_group_name=example_resource_group.name,
    location="West US",
    version="12.0",
    administrator_login="4dm1n157r470r",
    administrator_login_password="4-v3ry-53cr37-p455w0rd",
    tags={
        "environment": "production",
    })
example_account = azure.storage.Account("exampleAccount",
    resource_group_name=example_resource_group.name,
    location=example_resource_group.location,
    account_tier="Standard",
    account_replication_type="LRS")
example_database = azure.sql.Database("exampleDatabase",
    resource_group_name=example_resource_group.name,
    location="West US",
    server_name=example_sql_server.name,
    extended_auditing_policy=azure.sql.DatabaseExtendedAuditingPolicyArgs(
        storage_endpoint=example_account.primary_blob_endpoint,
        storage_account_access_key=example_account.primary_access_key,
        storage_account_access_key_is_secondary=True,
        retention_in_days=6,
    ),
    tags={
        "environment": "production",
    })

    Example coming soon!

    Create Database Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new Database(name: string, args: DatabaseArgs, opts?: CustomResourceOptions);
    @overload
def Database(resource_name: str,
             args: DatabaseArgs,
             opts: Optional[ResourceOptions] = None)

@overload
def Database(resource_name: str,
             opts: Optional[ResourceOptions] = None,
             resource_group_name: Optional[str] = None,
             server_name: Optional[str] = None,
             import_: Optional[DatabaseImportArgs] = None,
             requested_service_objective_id: Optional[str] = None,
             extended_auditing_policy: Optional[DatabaseExtendedAuditingPolicyArgs] = None,
             collation: Optional[str] = None,
             location: Optional[str] = None,
             max_size_bytes: Optional[str] = None,
             max_size_gb: Optional[str] = None,
             name: Optional[str] = None,
             read_scale: Optional[bool] = None,
             elastic_pool_name: Optional[str] = None,
             requested_service_objective_name: Optional[str] = None,
             edition: Optional[str] = None,
             restore_point_in_time: Optional[str] = None,
             create_mode: Optional[str] = None,
             source_database_deletion_date: Optional[str] = None,
             source_database_id: Optional[str] = None,
             tags: Optional[Mapping[str, str]] = None,
             threat_detection_policy: Optional[DatabaseThreatDetectionPolicyArgs] = None,
             zone_redundant: Optional[bool] = None)
    func NewDatabase(ctx *Context, name string, args DatabaseArgs, opts ...ResourceOption) (*Database, error)
    public Database(string name, DatabaseArgs args, CustomResourceOptions? opts = null)
    public Database(String name, DatabaseArgs args)
public Database(String name, DatabaseArgs args, CustomResourceOptions options)

    type: azure:sql:Database
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args DatabaseArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args DatabaseArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args DatabaseArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args DatabaseArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args DatabaseArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var exampledatabaseResourceResourceFromSqldatabase = new Azure.Sql.Database("exampledatabaseResourceResourceFromSqldatabase", new()
{
    ResourceGroupName = "string",
    ServerName = "string",
    Import = new Azure.Sql.Inputs.DatabaseImportArgs
    {
        AdministratorLogin = "string",
        AdministratorLoginPassword = "string",
        AuthenticationType = "string",
        StorageKey = "string",
        StorageKeyType = "string",
        StorageUri = "string",
        OperationMode = "string",
    },
    RequestedServiceObjectiveId = "string",
    Collation = "string",
    Location = "string",
    MaxSizeBytes = "string",
    MaxSizeGb = "string",
    Name = "string",
    ReadScale = false,
    ElasticPoolName = "string",
    RequestedServiceObjectiveName = "string",
    Edition = "string",
    RestorePointInTime = "string",
    CreateMode = "string",
    SourceDatabaseDeletionDate = "string",
    SourceDatabaseId = "string",
    Tags = 
    {
        { "string", "string" },
    },
    ThreatDetectionPolicy = new Azure.Sql.Inputs.DatabaseThreatDetectionPolicyArgs
    {
        DisabledAlerts = new[]
        {
            "string",
        },
        EmailAccountAdmins = "string",
        EmailAddresses = new[]
        {
            "string",
        },
        RetentionDays = 0,
        State = "string",
        StorageAccountAccessKey = "string",
        StorageEndpoint = "string",
    },
    ZoneRedundant = false,
});

    example, err := sql.NewDatabase(ctx, "exampledatabaseResourceResourceFromSqldatabase", &sql.DatabaseArgs{
	ResourceGroupName: pulumi.String("string"),
	ServerName:        pulumi.String("string"),
	Import: &sql.DatabaseImportArgs{
		AdministratorLogin:         pulumi.String("string"),
		AdministratorLoginPassword: pulumi.String("string"),
		AuthenticationType:         pulumi.String("string"),
		StorageKey:                 pulumi.String("string"),
		StorageKeyType:             pulumi.String("string"),
		StorageUri:                 pulumi.String("string"),
		OperationMode:              pulumi.String("string"),
	},
	RequestedServiceObjectiveId:   pulumi.String("string"),
	Collation:                     pulumi.String("string"),
	Location:                      pulumi.String("string"),
	MaxSizeBytes:                  pulumi.String("string"),
	MaxSizeGb:                     pulumi.String("string"),
	Name:                          pulumi.String("string"),
	ReadScale:                     pulumi.Bool(false),
	ElasticPoolName:               pulumi.String("string"),
	RequestedServiceObjectiveName: pulumi.String("string"),
	Edition:                       pulumi.String("string"),
	RestorePointInTime:            pulumi.String("string"),
	CreateMode:                    pulumi.String("string"),
	SourceDatabaseDeletionDate:    pulumi.String("string"),
	SourceDatabaseId:              pulumi.String("string"),
	Tags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	ThreatDetectionPolicy: &sql.DatabaseThreatDetectionPolicyArgs{
		DisabledAlerts: pulumi.StringArray{
			pulumi.String("string"),
		},
		EmailAccountAdmins: pulumi.String("string"),
		EmailAddresses: pulumi.StringArray{
			pulumi.String("string"),
		},
		RetentionDays:           pulumi.Int(0),
		State:                   pulumi.String("string"),
		StorageAccountAccessKey: pulumi.String("string"),
		StorageEndpoint:         pulumi.String("string"),
	},
	ZoneRedundant: pulumi.Bool(false),
})

    var exampledatabaseResourceResourceFromSqldatabase = new com.pulumi.azure.sql.Database("exampledatabaseResourceResourceFromSqldatabase", com.pulumi.azure.sql.DatabaseArgs.builder()
    .resourceGroupName("string")
    .serverName("string")
    .import_(DatabaseImportArgs.builder()
        .administratorLogin("string")
        .administratorLoginPassword("string")
        .authenticationType("string")
        .storageKey("string")
        .storageKeyType("string")
        .storageUri("string")
        .operationMode("string")
        .build())
    .requestedServiceObjectiveId("string")
    .collation("string")
    .location("string")
    .maxSizeBytes("string")
    .maxSizeGb("string")
    .name("string")
    .readScale(false)
    .elasticPoolName("string")
    .requestedServiceObjectiveName("string")
    .edition("string")
    .restorePointInTime("string")
    .createMode("string")
    .sourceDatabaseDeletionDate("string")
    .sourceDatabaseId("string")
    .tags(Map.of("string", "string"))
    .threatDetectionPolicy(DatabaseThreatDetectionPolicyArgs.builder()
        .disabledAlerts("string")
        .emailAccountAdmins("string")
        .emailAddresses("string")
        .retentionDays(0)
        .state("string")
        .storageAccountAccessKey("string")
        .storageEndpoint("string")
        .build())
    .zoneRedundant(false)
    .build());

    exampledatabase_resource_resource_from_sqldatabase = azure.sql.Database("exampledatabaseResourceResourceFromSqldatabase",
    resource_group_name="string",
    server_name="string",
    import_={
        "administrator_login": "string",
        "administrator_login_password": "string",
        "authentication_type": "string",
        "storage_key": "string",
        "storage_key_type": "string",
        "storage_uri": "string",
        "operation_mode": "string",
    },
    requested_service_objective_id="string",
    collation="string",
    location="string",
    max_size_bytes="string",
    max_size_gb="string",
    name="string",
    read_scale=False,
    elastic_pool_name="string",
    requested_service_objective_name="string",
    edition="string",
    restore_point_in_time="string",
    create_mode="string",
    source_database_deletion_date="string",
    source_database_id="string",
    tags={
        "string": "string",
    },
    threat_detection_policy={
        "disabled_alerts": ["string"],
        "email_account_admins": "string",
        "email_addresses": ["string"],
        "retention_days": 0,
        "state": "string",
        "storage_account_access_key": "string",
        "storage_endpoint": "string",
    },
    zone_redundant=False)

    const exampledatabaseResourceResourceFromSqldatabase = new azure.sql.Database("exampledatabaseResourceResourceFromSqldatabase", {
    resourceGroupName: "string",
    serverName: "string",
    "import": {
        administratorLogin: "string",
        administratorLoginPassword: "string",
        authenticationType: "string",
        storageKey: "string",
        storageKeyType: "string",
        storageUri: "string",
        operationMode: "string",
    },
    requestedServiceObjectiveId: "string",
    collation: "string",
    location: "string",
    maxSizeBytes: "string",
    maxSizeGb: "string",
    name: "string",
    readScale: false,
    elasticPoolName: "string",
    requestedServiceObjectiveName: "string",
    edition: "string",
    restorePointInTime: "string",
    createMode: "string",
    sourceDatabaseDeletionDate: "string",
    sourceDatabaseId: "string",
    tags: {
        string: "string",
    },
    threatDetectionPolicy: {
        disabledAlerts: ["string"],
        emailAccountAdmins: "string",
        emailAddresses: ["string"],
        retentionDays: 0,
        state: "string",
        storageAccountAccessKey: "string",
        storageEndpoint: "string",
    },
    zoneRedundant: false,
});

    type: azure:sql:Database
properties:
    collation: string
    createMode: string
    edition: string
    elasticPoolName: string
    import:
        administratorLogin: string
        administratorLoginPassword: string
        authenticationType: string
        operationMode: string
        storageKey: string
        storageKeyType: string
        storageUri: string
    location: string
    maxSizeBytes: string
    maxSizeGb: string
    name: string
    readScale: false
    requestedServiceObjectiveId: string
    requestedServiceObjectiveName: string
    resourceGroupName: string
    restorePointInTime: string
    serverName: string
    sourceDatabaseDeletionDate: string
    sourceDatabaseId: string
    tags:
        string: string
    threatDetectionPolicy:
        disabledAlerts:
            - string
        emailAccountAdmins: string
        emailAddresses:
            - string
        retentionDays: 0
        state: string
        storageAccountAccessKey: string
        storageEndpoint: string
    zoneRedundant: false

    Database Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The Database resource accepts the following input properties:

    ResourceGroupName string
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    ServerName string
    The name of the SQL Server on which to create the database.
    Collation string
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    CreateMode string
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    Edition string
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    ElasticPoolName string
    The name of the elastic database pool.
    ExtendedAuditingPolicy DatabaseExtendedAuditingPolicy
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    Import DatabaseImport
    A Database Import block as documented below. create_mode must be set to Default.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MaxSizeBytes string
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    MaxSizeGb string
    Name string
    The name of the database.
    ReadScale bool
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    RequestedServiceObjectiveId string
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    RequestedServiceObjectiveName string
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    RestorePointInTime string
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    SourceDatabaseDeletionDate string
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    SourceDatabaseId string
    The URI of the source database if create_mode value is not Default.
    Tags Dictionary<string, string>
    A mapping of tags to assign to the resource.
    ThreatDetectionPolicy DatabaseThreatDetectionPolicy
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    ZoneRedundant bool
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.
    ResourceGroupName string
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    ServerName string
    The name of the SQL Server on which to create the database.
    Collation string
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    CreateMode string
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    Edition string
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    ElasticPoolName string
    The name of the elastic database pool.
    ExtendedAuditingPolicy DatabaseExtendedAuditingPolicyArgs
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    Import DatabaseImportArgs
    A Database Import block as documented below. create_mode must be set to Default.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MaxSizeBytes string
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    MaxSizeGb string
    Name string
    The name of the database.
    ReadScale bool
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    RequestedServiceObjectiveId string
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    RequestedServiceObjectiveName string
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    RestorePointInTime string
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    SourceDatabaseDeletionDate string
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    SourceDatabaseId string
    The URI of the source database if create_mode value is not Default.
    Tags map[string]string
    A mapping of tags to assign to the resource.
    ThreatDetectionPolicy DatabaseThreatDetectionPolicyArgs
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    ZoneRedundant bool
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.
    resourceGroupName String
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    serverName String
    The name of the SQL Server on which to create the database.
    collation String
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    createMode String
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    edition String
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    elasticPoolName String
    The name of the elastic database pool.
    extendedAuditingPolicy DatabaseExtendedAuditingPolicy
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    import_ DatabaseImport
    A Database Import block as documented below. create_mode must be set to Default.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maxSizeBytes String
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    maxSizeGb String
    name String
    The name of the database.
    readScale Boolean
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    requestedServiceObjectiveId String
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    requestedServiceObjectiveName String
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    restorePointInTime String
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    sourceDatabaseDeletionDate String
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    sourceDatabaseId String
    The URI of the source database if create_mode value is not Default.
    tags Map<String,String>
    A mapping of tags to assign to the resource.
    threatDetectionPolicy DatabaseThreatDetectionPolicy
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    zoneRedundant Boolean
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.
    resourceGroupName string
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    serverName string
    The name of the SQL Server on which to create the database.
    collation string
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    createMode string
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    edition string
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    elasticPoolName string
    The name of the elastic database pool.
    extendedAuditingPolicy DatabaseExtendedAuditingPolicy
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    import DatabaseImport
    A Database Import block as documented below. create_mode must be set to Default.
    location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maxSizeBytes string
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    maxSizeGb string
    name string
    The name of the database.
    readScale boolean
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    requestedServiceObjectiveId string
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    requestedServiceObjectiveName string
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    restorePointInTime string
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    sourceDatabaseDeletionDate string
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    sourceDatabaseId string
    The URI of the source database if create_mode value is not Default.
    tags {[key: string]: string}
    A mapping of tags to assign to the resource.
    threatDetectionPolicy DatabaseThreatDetectionPolicy
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    zoneRedundant boolean
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.
    resource_group_name str
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    server_name str
    The name of the SQL Server on which to create the database.
    collation str
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    create_mode str
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    edition str
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    elastic_pool_name str
    The name of the elastic database pool.
    extended_auditing_policy DatabaseExtendedAuditingPolicyArgs
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    import_ DatabaseImportArgs
    A Database Import block as documented below. create_mode must be set to Default.
    location str
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    max_size_bytes str
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    max_size_gb str
    name str
    The name of the database.
    read_scale bool
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    requested_service_objective_id str
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    requested_service_objective_name str
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    restore_point_in_time str
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    source_database_deletion_date str
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    source_database_id str
    The URI of the source database if create_mode value is not Default.
    tags Mapping[str, str]
    A mapping of tags to assign to the resource.
    threat_detection_policy DatabaseThreatDetectionPolicyArgs
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    zone_redundant bool
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.
    resourceGroupName String
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    serverName String
    The name of the SQL Server on which to create the database.
    collation String
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    createMode String
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    edition String
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    elasticPoolName String
    The name of the elastic database pool.
    extendedAuditingPolicy Property Map
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    import Property Map
    A Database Import block as documented below. create_mode must be set to Default.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maxSizeBytes String
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    maxSizeGb String
    name String
    The name of the database.
    readScale Boolean
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    requestedServiceObjectiveId String
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    requestedServiceObjectiveName String
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    restorePointInTime String
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    sourceDatabaseDeletionDate String
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    sourceDatabaseId String
    The URI of the source database if create_mode value is not Default.
    tags Map<String>
    A mapping of tags to assign to the resource.
    threatDetectionPolicy Property Map
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    zoneRedundant Boolean
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the Database resource produces the following output properties:

    CreationDate string
    The creation date of the SQL Database.
    DefaultSecondaryLocation string
    The default secondary location of the SQL Database.
    Encryption string
    Id string
    The provider-assigned unique ID for this managed resource.
    CreationDate string
    The creation date of the SQL Database.
    DefaultSecondaryLocation string
    The default secondary location of the SQL Database.
    Encryption string
    Id string
    The provider-assigned unique ID for this managed resource.
    creationDate String
    The creation date of the SQL Database.
    defaultSecondaryLocation String
    The default secondary location of the SQL Database.
    encryption String
    id String
    The provider-assigned unique ID for this managed resource.
    creationDate string
    The creation date of the SQL Database.
    defaultSecondaryLocation string
    The default secondary location of the SQL Database.
    encryption string
    id string
    The provider-assigned unique ID for this managed resource.
    creation_date str
    The creation date of the SQL Database.
    default_secondary_location str
    The default secondary location of the SQL Database.
    encryption str
    id str
    The provider-assigned unique ID for this managed resource.
    creationDate String
    The creation date of the SQL Database.
    defaultSecondaryLocation String
    The default secondary location of the SQL Database.
    encryption String
    id String
    The provider-assigned unique ID for this managed resource.

    Look up Existing Database Resource

    Get an existing Database resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: DatabaseState, opts?: CustomResourceOptions): Database
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        collation: Optional[str] = None,
        create_mode: Optional[str] = None,
        creation_date: Optional[str] = None,
        default_secondary_location: Optional[str] = None,
        edition: Optional[str] = None,
        elastic_pool_name: Optional[str] = None,
        encryption: Optional[str] = None,
        extended_auditing_policy: Optional[DatabaseExtendedAuditingPolicyArgs] = None,
        import_: Optional[DatabaseImportArgs] = None,
        location: Optional[str] = None,
        max_size_bytes: Optional[str] = None,
        max_size_gb: Optional[str] = None,
        name: Optional[str] = None,
        read_scale: Optional[bool] = None,
        requested_service_objective_id: Optional[str] = None,
        requested_service_objective_name: Optional[str] = None,
        resource_group_name: Optional[str] = None,
        restore_point_in_time: Optional[str] = None,
        server_name: Optional[str] = None,
        source_database_deletion_date: Optional[str] = None,
        source_database_id: Optional[str] = None,
        tags: Optional[Mapping[str, str]] = None,
        threat_detection_policy: Optional[DatabaseThreatDetectionPolicyArgs] = None,
        zone_redundant: Optional[bool] = None) -> Database
    func GetDatabase(ctx *Context, name string, id IDInput, state *DatabaseState, opts ...ResourceOption) (*Database, error)
    public static Database Get(string name, Input<string> id, DatabaseState? state, CustomResourceOptions? opts = null)
    public static Database get(String name, Output<String> id, DatabaseState state, CustomResourceOptions options)
    resources:  _:    type: azure:sql:Database    get:      id: ${id}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    Collation string
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    CreateMode string
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    CreationDate string
    The creation date of the SQL Database.
    DefaultSecondaryLocation string
    The default secondary location of the SQL Database.
    Edition string
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    ElasticPoolName string
    The name of the elastic database pool.
    Encryption string
    ExtendedAuditingPolicy DatabaseExtendedAuditingPolicy
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    Import DatabaseImport
    A Database Import block as documented below. create_mode must be set to Default.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MaxSizeBytes string
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    MaxSizeGb string
    Name string
    The name of the database.
    ReadScale bool
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    RequestedServiceObjectiveId string
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    RequestedServiceObjectiveName string
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    ResourceGroupName string
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    RestorePointInTime string
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    ServerName string
    The name of the SQL Server on which to create the database.
    SourceDatabaseDeletionDate string
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    SourceDatabaseId string
    The URI of the source database if create_mode value is not Default.
    Tags Dictionary<string, string>
    A mapping of tags to assign to the resource.
    ThreatDetectionPolicy DatabaseThreatDetectionPolicy
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    ZoneRedundant bool
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.
    Collation string
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    CreateMode string
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    CreationDate string
    The creation date of the SQL Database.
    DefaultSecondaryLocation string
    The default secondary location of the SQL Database.
    Edition string
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    ElasticPoolName string
    The name of the elastic database pool.
    Encryption string
    ExtendedAuditingPolicy DatabaseExtendedAuditingPolicyArgs
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    Import DatabaseImportArgs
    A Database Import block as documented below. create_mode must be set to Default.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MaxSizeBytes string
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    MaxSizeGb string
    Name string
    The name of the database.
    ReadScale bool
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    RequestedServiceObjectiveId string
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    RequestedServiceObjectiveName string
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    ResourceGroupName string
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    RestorePointInTime string
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    ServerName string
    The name of the SQL Server on which to create the database.
    SourceDatabaseDeletionDate string
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    SourceDatabaseId string
    The URI of the source database if create_mode value is not Default.
    Tags map[string]string
    A mapping of tags to assign to the resource.
    ThreatDetectionPolicy DatabaseThreatDetectionPolicyArgs
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    ZoneRedundant bool
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.
    collation String
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    createMode String
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    creationDate String
    The creation date of the SQL Database.
    defaultSecondaryLocation String
    The default secondary location of the SQL Database.
    edition String
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    elasticPoolName String
    The name of the elastic database pool.
    encryption String
    extendedAuditingPolicy DatabaseExtendedAuditingPolicy
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    import_ DatabaseImport
    A Database Import block as documented below. create_mode must be set to Default.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maxSizeBytes String
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    maxSizeGb String
    name String
    The name of the database.
    readScale Boolean
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    requestedServiceObjectiveId String
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    requestedServiceObjectiveName String
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    resourceGroupName String
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    restorePointInTime String
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    serverName String
    The name of the SQL Server on which to create the database.
    sourceDatabaseDeletionDate String
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    sourceDatabaseId String
    The URI of the source database if create_mode value is not Default.
    tags Map<String,String>
    A mapping of tags to assign to the resource.
    threatDetectionPolicy DatabaseThreatDetectionPolicy
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    zoneRedundant Boolean
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.
    collation string
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    createMode string
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    creationDate string
    The creation date of the SQL Database.
    defaultSecondaryLocation string
    The default secondary location of the SQL Database.
    edition string
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    elasticPoolName string
    The name of the elastic database pool.
    encryption string
    extendedAuditingPolicy DatabaseExtendedAuditingPolicy
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    import DatabaseImport
    A Database Import block as documented below. create_mode must be set to Default.
    location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maxSizeBytes string
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    maxSizeGb string
    name string
    The name of the database.
    readScale boolean
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    requestedServiceObjectiveId string
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    requestedServiceObjectiveName string
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    resourceGroupName string
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    restorePointInTime string
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    serverName string
    The name of the SQL Server on which to create the database.
    sourceDatabaseDeletionDate string
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    sourceDatabaseId string
    The URI of the source database if create_mode value is not Default.
    tags {[key: string]: string}
    A mapping of tags to assign to the resource.
    threatDetectionPolicy DatabaseThreatDetectionPolicy
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    zoneRedundant boolean
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.
    collation str
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    create_mode str
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    creation_date str
    The creation date of the SQL Database.
    default_secondary_location str
    The default secondary location of the SQL Database.
    edition str
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    elastic_pool_name str
    The name of the elastic database pool.
    encryption str
    extended_auditing_policy DatabaseExtendedAuditingPolicyArgs
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    import_ DatabaseImportArgs
    A Database Import block as documented below. create_mode must be set to Default.
    location str
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    max_size_bytes str
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    max_size_gb str
    name str
    The name of the database.
    read_scale bool
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    requested_service_objective_id str
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    requested_service_objective_name str
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    resource_group_name str
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    restore_point_in_time str
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    server_name str
    The name of the SQL Server on which to create the database.
    source_database_deletion_date str
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    source_database_id str
    The URI of the source database if create_mode value is not Default.
    tags Mapping[str, str]
    A mapping of tags to assign to the resource.
    threat_detection_policy DatabaseThreatDetectionPolicyArgs
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    zone_redundant bool
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.
    collation String
    The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.
    createMode String
    Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API
    creationDate String
    The creation date of the SQL Database.
    defaultSecondaryLocation String
    The default secondary location of the SQL Database.
    edition String
    The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.
    elasticPoolName String
    The name of the elastic database pool.
    encryption String
    extendedAuditingPolicy Property Map
    A extended_auditing_policy block as defined below.

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    import Property Map
    A Database Import block as documented below. create_mode must be set to Default.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maxSizeBytes String
    The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.
    maxSizeGb String
    name String
    The name of the database.
    readScale Boolean
    Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.
    requestedServiceObjectiveId String
    A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .
    requestedServiceObjectiveName String
    The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus -o table. For further information please see Azure CLI - az sql db.
    resourceGroupName String
    The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.
    restorePointInTime String
    The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z
    serverName String
    The name of the SQL Server on which to create the database.
    sourceDatabaseDeletionDate String
    The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.
    sourceDatabaseId String
    The URI of the source database if create_mode value is not Default.
    tags Map<String>
    A mapping of tags to assign to the resource.
    threatDetectionPolicy Property Map
    Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
    zoneRedundant Boolean
    Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.

    Supporting Types

    DatabaseExtendedAuditingPolicy, DatabaseExtendedAuditingPolicyArgs

    LogMonitoringEnabled bool
    RetentionInDays int
    Specifies the number of days to retain logs for in the storage account.
    StorageAccountAccessKey string
    Specifies the access key to use for the auditing storage account.
    StorageAccountAccessKeyIsSecondary bool
    Specifies whether storage_account_access_key value is the storage's secondary key.
    StorageEndpoint string
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net).
    LogMonitoringEnabled bool
    RetentionInDays int
    Specifies the number of days to retain logs for in the storage account.
    StorageAccountAccessKey string
    Specifies the access key to use for the auditing storage account.
    StorageAccountAccessKeyIsSecondary bool
    Specifies whether storage_account_access_key value is the storage's secondary key.
    StorageEndpoint string
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net).
    logMonitoringEnabled Boolean
    retentionInDays Integer
    Specifies the number of days to retain logs for in the storage account.
    storageAccountAccessKey String
    Specifies the access key to use for the auditing storage account.
    storageAccountAccessKeyIsSecondary Boolean
    Specifies whether storage_account_access_key value is the storage's secondary key.
    storageEndpoint String
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net).
    logMonitoringEnabled boolean
    retentionInDays number
    Specifies the number of days to retain logs for in the storage account.
    storageAccountAccessKey string
    Specifies the access key to use for the auditing storage account.
    storageAccountAccessKeyIsSecondary boolean
    Specifies whether storage_account_access_key value is the storage's secondary key.
    storageEndpoint string
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net).
    log_monitoring_enabled bool
    retention_in_days int
    Specifies the number of days to retain logs for in the storage account.
    storage_account_access_key str
    Specifies the access key to use for the auditing storage account.
    storage_account_access_key_is_secondary bool
    Specifies whether storage_account_access_key value is the storage's secondary key.
    storage_endpoint str
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net).
    logMonitoringEnabled Boolean
    retentionInDays Number
    Specifies the number of days to retain logs for in the storage account.
    storageAccountAccessKey String
    Specifies the access key to use for the auditing storage account.
    storageAccountAccessKeyIsSecondary Boolean
    Specifies whether storage_account_access_key value is the storage's secondary key.
    storageEndpoint String
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net).

    DatabaseImport, DatabaseImportArgs

    AdministratorLogin string
    Specifies the name of the SQL administrator.
    AdministratorLoginPassword string
    Specifies the password of the SQL administrator.
    AuthenticationType string
    Specifies the type of authentication used to access the server. Valid values are SQL or ADPassword.
    StorageKey string
    Specifies the access key for the storage account.
    StorageKeyType string
    Specifies the type of access key for the storage account. Valid values are StorageAccessKey or SharedAccessKey.
    StorageUri string
    Specifies the blob URI of the .bacpac file.
    OperationMode string
    Specifies the type of import operation being performed. The only allowable value is Import.
    AdministratorLogin string
    Specifies the name of the SQL administrator.
    AdministratorLoginPassword string
    Specifies the password of the SQL administrator.
    AuthenticationType string
    Specifies the type of authentication used to access the server. Valid values are SQL or ADPassword.
    StorageKey string
    Specifies the access key for the storage account.
    StorageKeyType string
    Specifies the type of access key for the storage account. Valid values are StorageAccessKey or SharedAccessKey.
    StorageUri string
    Specifies the blob URI of the .bacpac file.
    OperationMode string
    Specifies the type of import operation being performed. The only allowable value is Import.
    administratorLogin String
    Specifies the name of the SQL administrator.
    administratorLoginPassword String
    Specifies the password of the SQL administrator.
    authenticationType String
    Specifies the type of authentication used to access the server. Valid values are SQL or ADPassword.
    storageKey String
    Specifies the access key for the storage account.
    storageKeyType String
    Specifies the type of access key for the storage account. Valid values are StorageAccessKey or SharedAccessKey.
    storageUri String
    Specifies the blob URI of the .bacpac file.
    operationMode String
    Specifies the type of import operation being performed. The only allowable value is Import.
    administratorLogin string
    Specifies the name of the SQL administrator.
    administratorLoginPassword string
    Specifies the password of the SQL administrator.
    authenticationType string
    Specifies the type of authentication used to access the server. Valid values are SQL or ADPassword.
    storageKey string
    Specifies the access key for the storage account.
    storageKeyType string
    Specifies the type of access key for the storage account. Valid values are StorageAccessKey or SharedAccessKey.
    storageUri string
    Specifies the blob URI of the .bacpac file.
    operationMode string
    Specifies the type of import operation being performed. The only allowable value is Import.
    administrator_login str
    Specifies the name of the SQL administrator.
    administrator_login_password str
    Specifies the password of the SQL administrator.
    authentication_type str
    Specifies the type of authentication used to access the server. Valid values are SQL or ADPassword.
    storage_key str
    Specifies the access key for the storage account.
    storage_key_type str
    Specifies the type of access key for the storage account. Valid values are StorageAccessKey or SharedAccessKey.
    storage_uri str
    Specifies the blob URI of the .bacpac file.
    operation_mode str
    Specifies the type of import operation being performed. The only allowable value is Import.
    administratorLogin String
    Specifies the name of the SQL administrator.
    administratorLoginPassword String
    Specifies the password of the SQL administrator.
    authenticationType String
    Specifies the type of authentication used to access the server. Valid values are SQL or ADPassword.
    storageKey String
    Specifies the access key for the storage account.
    storageKeyType String
    Specifies the type of access key for the storage account. Valid values are StorageAccessKey or SharedAccessKey.
    storageUri String
    Specifies the blob URI of the .bacpac file.
    operationMode String
    Specifies the type of import operation being performed. The only allowable value is Import.

    DatabaseThreatDetectionPolicy, DatabaseThreatDetectionPolicyArgs

    DisabledAlerts List<string>
    Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.
    EmailAccountAdmins string
    Should the account administrators be emailed when this alert is triggered?
    EmailAddresses List<string>
    A list of email addresses which alerts should be sent to.
    RetentionDays int
    Specifies the number of days to keep in the Threat Detection audit logs.
    State string
    The State of the Policy. Possible values are Enabled, Disabled or New.
    StorageAccountAccessKey string
    Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.
    StorageEndpoint string
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.
    UseServerDefault string

    Deprecated: This field is now non-functional and thus will be removed in version 3.0 of the Azure Provider

    DisabledAlerts []string
    Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.
    EmailAccountAdmins string
    Should the account administrators be emailed when this alert is triggered?
    EmailAddresses []string
    A list of email addresses which alerts should be sent to.
    RetentionDays int
    Specifies the number of days to keep in the Threat Detection audit logs.
    State string
    The State of the Policy. Possible values are Enabled, Disabled or New.
    StorageAccountAccessKey string
    Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.
    StorageEndpoint string
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.
    UseServerDefault string

    Deprecated: This field is now non-functional and thus will be removed in version 3.0 of the Azure Provider

    disabledAlerts List<String>
    Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.
    emailAccountAdmins String
    Should the account administrators be emailed when this alert is triggered?
    emailAddresses List<String>
    A list of email addresses which alerts should be sent to.
    retentionDays Integer
    Specifies the number of days to keep in the Threat Detection audit logs.
    state String
    The State of the Policy. Possible values are Enabled, Disabled or New.
    storageAccountAccessKey String
    Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.
    storageEndpoint String
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.
    useServerDefault String

    Deprecated: This field is now non-functional and thus will be removed in version 3.0 of the Azure Provider

    disabledAlerts string[]
    Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.
    emailAccountAdmins string
    Should the account administrators be emailed when this alert is triggered?
    emailAddresses string[]
    A list of email addresses which alerts should be sent to.
    retentionDays number
    Specifies the number of days to keep in the Threat Detection audit logs.
    state string
    The State of the Policy. Possible values are Enabled, Disabled or New.
    storageAccountAccessKey string
    Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.
    storageEndpoint string
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.
    useServerDefault string

    Deprecated: This field is now non-functional and thus will be removed in version 3.0 of the Azure Provider

    disabled_alerts Sequence[str]
    Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.
    email_account_admins str
    Should the account administrators be emailed when this alert is triggered?
    email_addresses Sequence[str]
    A list of email addresses which alerts should be sent to.
    retention_days int
    Specifies the number of days to keep in the Threat Detection audit logs.
    state str
    The State of the Policy. Possible values are Enabled, Disabled or New.
    storage_account_access_key str
    Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.
    storage_endpoint str
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.
    use_server_default str

    Deprecated: This field is now non-functional and thus will be removed in version 3.0 of the Azure Provider

    disabledAlerts List<String>
    Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.
    emailAccountAdmins String
    Should the account administrators be emailed when this alert is triggered?
    emailAddresses List<String>
    A list of email addresses which alerts should be sent to.
    retentionDays Number
    Specifies the number of days to keep in the Threat Detection audit logs.
    state String
    The State of the Policy. Possible values are Enabled, Disabled or New.
    storageAccountAccessKey String
    Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.
    storageEndpoint String
    Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.
    useServerDefault String

    Deprecated: This field is now non-functional and thus will be removed in version 3.0 of the Azure Provider

    Package Details

    Repository
    Azure Classic pulumi/pulumi-azure
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the azurerm Terraform Provider.
    azure logo

    We recommend using Azure Native.

    Viewing docs for Azure v4.42.0 (Older version)
    published on Monday, Mar 9, 2026 by Pulumi
    Go to latest version
    Schema (JSON)
    pulumi/pulumi-azure
      Try Pulumi Cloud free. Your team will thank you.