Cloud.Service.Azure.SQL.Database

Cloud.Service.Azure.SQL.Database
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
tags
Optional

Database categorization, in case-sensitive key names, or in key-value pairs.

array of object
threat_detection_policy
Optional

Settings for threat detection.