azure.azcollection.azure_rm_sqlmidatabase module – Manage SQL Managed Instance databases

Note

This module is part of the azure.azcollection collection (version 3.1.0).

You might already have this collection installed if you are using the ansible package. It is not included in ansible-core. To check whether it is installed, run ansible-galaxy collection list.

To install it, use: ansible-galaxy collection install azure.azcollection. You need further requirements to be able to use this module, see Requirements for details.

To use it in a playbook, specify: azure.azcollection.azure_rm_sqlmidatabase.

New in azure.azcollection 2.4.0

Synopsis 

Manage SQL Managed Instance databases.

Requirements 

The below requirements are needed on the host that executes this module.

python >= 2.7
The host that executes this module must have the azure.azcollection collection installed via galaxy
All python packages listed in collection’s requirements.txt must be installed via pip on the host that executes modules from azure.azcollection
Full installation instructions may be found https://galaxy.ansible.com/azure/azcollection

Parameters 

Parameter	Comments
ad_user string	Active Directory username. Use when authenticating with an Active Directory user rather than service principal.
adfs_authority_url string added in azure.azcollection 0.0.1	Azure AD authority url. Use when authenticating with Username/password, and has your own ADFS authority.
api_profile string added in azure.azcollection 0.0.1	Selects an API profile to use when communicating with Azure services. Default value of `latest` is appropriate for public clouds; future values will allow use with Azure Stack. Default: `"latest"`
append_tags boolean	Use to control if tags field is canonical or just appends to existing tags. When canonical, any tags not found in the tags parameter will be removed from the object’s metadata. Choices: `false` `true` ← (default)
auth_source string added in azure.azcollection 0.0.1	Controls the source of the credentials to use for authentication. Can also be set via the `ANSIBLE_AZURE_AUTH_SOURCE` environment variable. When set to `auto` (the default) the precedence is module parameters -> `env` -> `credential_file` -> `cli`. When set to `env`, the credentials will be read from the environment variables When set to `credential_file`, it will read the profile from `~/.azure/credentials`. When set to `cli`, the credentials will be sources from the Azure CLI profile. `subscription_id` or the environment variable `AZURE_SUBSCRIPTION_ID` can be used to identify the subscription ID if more than one is present otherwise the default az cli subscription is used. When set to `msi`, the host machine must be an azure resource with an enabled MSI extension. `subscription_id` or the environment variable `AZURE_SUBSCRIPTION_ID` can be used to identify the subscription ID if the resource is granted access to more than one subscription, otherwise the first subscription is chosen. The `msi` was added in Ansible 2.6. Choices: `"auto"` ← (default) `"cli"` `"credential_file"` `"env"` `"msi"`
cert_validation_mode string added in azure.azcollection 0.0.1	Controls the certificate validation behavior for Azure endpoints. By default, all modules will validate the server certificate, but when an HTTPS proxy is in use, or against Azure Stack, it may be necessary to disable this behavior by passing `ignore`. Can also be set via credential file profile or the `AZURE_CERT_VALIDATION` environment variable. Choices: `"ignore"` `"validate"`
client_id string	Azure client ID. Use when authenticating with a Service Principal or Managed Identity (msi). Can also be set via the `AZURE_CLIENT_ID` environment variable.
cloud_environment string added in azure.azcollection 0.0.1	For cloud environments other than the US public cloud, the environment name (as defined by Azure Python SDK, eg, `AzureChinaCloud`, `AzureUSGovernment`), or a metadata discovery endpoint URL (required for Azure Stack). Can also be set via credential file profile or the `AZURE_CLOUD_ENVIRONMENT` environment variable. Default: `"AzureCloud"`
collation string	The collation of the Azure SQL Managed Database collation to use. For example `SQL_Latin1_General_CP1_CI_AS` or `Latin1_General_100_CS_AS_SC`.
database_name string / required	The name of the SQL managed instance database.
disable_instance_discovery boolean added in azure.azcollection 2.3.0	Determines whether or not instance discovery is performed when attempting to authenticate. Setting this to true will completely disable both instance discovery and authority validation. This functionality is intended for use in scenarios where the metadata endpoint cannot be reached such as in private clouds or Azure Stack. The process of instance discovery entails retrieving authority metadata from https://login.microsoft.com/ to validate the authority. By setting this to True, the validation of the authority is disabled. As a result, it is crucial to ensure that the configured authority host is valid and trustworthy. Set via credential file profile or the `AZURE_DISABLE_INSTANCE_DISCOVERY` environment variable. Choices: `false` ← (default) `true`
location string	The resource location.
log_mode string	Parent argument.
log_path string	Parent argument.
managed_instance_name string / required	The name of the SQL managed instance.
password string	Active Directory user password. Use when authenticating with an Active Directory user rather than service principal.
profile string	Security profile found in ~/.azure/credentials file.
resource_group string / required	The name of the resource group that contains the resource.
secret string	Azure client secret. Use when authenticating with a Service Principal.
state string	State of the SQL Managed Database. Use `present` to create or update a automation runbook and use `absent` to delete. Choices: `"present"` ← (default) `"absent"`
subscription_id string	Your Azure subscription Id.
tags dictionary	Dictionary of string:string pairs to assign as metadata to the object. Metadata tags on the object will be updated with any provided values. To remove tags set append_tags option to false. Currently, Azure DNS zones and Traffic Manager services also don’t allow the use of spaces in the tag. Azure Front Door doesn’t support the use of Azure Automation and Azure CDN only support 15 tags on resources.
tenant string	Azure tenant ID. Use when authenticating with a Service Principal.
thumbprint string added in azure.azcollection 1.14.0	The thumbprint of the private key specified in x509_certificate_path. Use when authenticating with a Service Principal. Required if x509_certificate_path is defined.
x509_certificate_path path added in azure.azcollection 1.14.0	Path to the X509 certificate used to create the service principal in PEM format. The certificate must be appended to the private key. Use when authenticating with a Service Principal.

Notes 

Note

For authentication with Azure you can pass parameters, set environment variables, use a profile stored in ~/.azure/credentials, or log in before you run your tasks or playbook with az login.
Authentication is also possible using a service principal or Active Directory user.
To authenticate via service principal, pass subscription_id, client_id, secret and tenant or set environment variables AZURE_SUBSCRIPTION_ID, AZURE_CLIENT_ID, AZURE_SECRET and AZURE_TENANT.
To authenticate via Active Directory user, pass ad_user and password, or set AZURE_AD_USER and AZURE_PASSWORD in the environment.
Alternatively, credentials can be stored in ~/.azure/credentials. This is an ini file containing a [default] section and the following keys: subscription_id, client_id, secret and tenant or subscription_id, ad_user and password. It is also possible to add additional profiles. Specify the profile by passing profile or setting AZURE_PROFILE in the environment.

Examples 

- name: Create a SQL managed instance database
  azure_rm_sqlmidatabase:
    resource_group: testrg
    managed_instance_name: testinstancename
    database_name: newdatabase
    collation: SQL_Latin1_General_CP1_CI_AS
    location: eastus
    tags:
      key2: value2

- name: Delete the SQL managed instance database
  azure_rm_sqlmidatabase:
    resource_group: testrg
    managed_instance_name: testinstancename
    database_name: newdatabase
    state: absent

Return Values 

Common return values are documented here, the following are the fields unique to this module:

Key	Description
database complex	A dictionary containing facts for SQL Managed Instance database info. Returned: always
auto_complete_restore boolean	Whether to auto complete restore of this managed database. Returned: always
catalog_collation string	Collation of the metadata catalog. Returned: always
create_date string	Creation date of the database. Returned: always Sample: `"2024-05-06T23:59:49.770Z"`
create_mode string	Managed database create mode. Returned: always
database_name string	The sql mi databse name. Returned: always Sample: `"fredtest"`
default_secondary_location string	Geo paired region. Returned: always Sample: `"westus"`
id string	The resource ID. Returned: always Sample: `"/subscriptions/xxx-xxxx/resourceGroups/testRG/providers/Microsoft.Sql/managedInstances/fredsqlmin/databases/fredtest"`
last_backup_name string	Last backup file name for restore of this managed database. Returned: always
location string	The resource’s location. Returned: always Sample: `"eastus"`
long_term_retention_backup_resource_id string	The name of the Long Term Retention backup to be used for restore of this managed database. Returned: always
managed_instance_name string	The name of the SQL managed instance. Returned: always Sample: `"fredsqlmin"`
recoverable_database_id string	The resource identifier of the recoverable database associated with the database. Returned: always
resource_group string	The resource’s resource group. Returned: always Sample: `"testRG"`
restorable_dropped_database_id string	The restorable dropped database resource id. Returned: always
restore_point_in_time string	Specifies the point in time (ISO8601 format) of the source database. Returned: always
source_database_id string	The resource identifier of the source database associated with create operation of this database. Returned: always
status string	Status of the database. Returned: always Sample: `"online"`
storage_container_sas_token string	Specifies the storage container sas token. Returned: always
storage_container_uri string	Specifies the uri of the storage container where backups for this restore are stopped. Returned: always
tags string	The resource’s tags Returned: always Sample: `"{'key1': 'value1'}"`
type string	The resource type. Returned: always Sample: `"Microsoft.Sql/managedInstances/databases"`

Authors

xuzhang3 (@xuzhang3)
Fred-sun (@Fred-sun)

azure.azcollection.azure_rm_sqlmidatabase module – Manage SQL Managed Instance databases

Synopsis 

Requirements 

Parameters 

Notes 

See Also 

Examples 

Return Values 

Authors

Collection links

azure.azcollection.azure_rm_sqlmidatabase module – Manage SQL Managed Instance databases

Synopsis

Requirements

Parameters

Notes

See Also

Examples

Return Values

Authors

Collection links

Synopsis 

Requirements 

Parameters 

Notes 

See Also 

Examples 

Return Values 