Cloud.Service.Azure.SQL.Database

JSON Example

{
    "account": "string",
    "collation": "string",
    "count": 0,
    "create_mode": "string",
    "creation_date": "string",
    "default_secondary_location": "string",
    "edition": "string",
    "elastic_pool_name": "string",
    "encryption": "string",
    "import": [
        {
            "administrator_login": "string",
            "administrator_login_password": "string",
            "authentication_type": "string",
            "operation_mode": "string",
            "storage_key": "string",
            "storage_key_type": "string",
            "storage_uri": "string"
        }
    ],
    "max_size_bytes": "string",
    "name": "string",
    "region": "string",
    "requested_service_objective_id": "string",
    "requested_service_objective_name": "string",
    "resource_group_name": "string",
    "restore_point_in_time": "string",
    "server_name": "string",
    "source_database_deletion_date": "string",
    "source_database_id": "string",
    "tags": {},
    "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",
            "use_server_default": "string"
        }
    ]
}

string

account

Required

(Required) The name of the Microsoft Azure cloud account to use for this resource

string

collation

Optional

Collation rules for the database. Default is SQL_LATIN1_GENERAL_CP1_CI_AS. Only valid when create_mode is Default. Changing the collation deletes the existing resource and creates a new one.

integer

count

Optional

The number of resource instances to be created.

string

create_mode

Optional

Type of database to create. For example, Default or PointInTimeRestore.

string

creation_date

Optional

When to create the database.

string

default_secondary_location

Optional

Default secondary location of the SQL database.

string

edition

Optional

Database edition to be created: Basic, Standard, Premium, or DataWarehouse. Only valid when create_mode is Default.

string

elastic_pool_name

Optional

Elastic database pool that the database belongs to.

string

encryption

Optional

The Encryption property for this resource

array of object

import

Optional

Settings for creating the database by import. Only valid when create_mode is Default.

string

max_size_bytes

Optional

Database size limit, in bytes. Must be a multiple of 1 gigabyte (1073741824). Only valid when create_mode is Default.

string As ^((?![A-Z]).)*$

name

Required

(Required) SQL database name.

string

region

Required

(Required) Supported Azure location where the resource exists. Changing the location deletes the existing resource and creates a new one.

string

requested_service_objective_id

Optional

Identifier of the service pricing tier, which correlates to the performance level for the database.

string

requested_service_objective_name

Optional

Name of the service pricing tier, which correlates to the performance level for the database.

string

resource_group_name

Required

(Required) Resource group in which to create the database. Must be the same as the database server resource group.

string

restore_point_in_time

Optional

When create_mode is PointInTimeRestore, the time at which to restore. For example, 2019-11-08T22:00:40Z.

string

server_name

Required

(Required) Hostname of the SQL server on which to create the database. Use the short hostname. Do not enter the FQDN.

string

source_database_deletion_date

Optional

When create_mode is PointInTimeRestore, the date at which to delete the source database.

string

source_database_id

Optional

The URI of the source database when create_mode is not Default.

object