Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Bicep resource definition
The sqlManagedInstances resource type can be deployed with operations that target:
- Resource groups - See resource group deployment commands
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.AzureArcData/sqlManagedInstances resource, add the following Bicep to your template.
resource symbolicname 'Microsoft.AzureArcData/sqlManagedInstances@2021-07-01-preview' = {
extendedLocation: {
name: 'string'
type: 'string'
}
location: 'string'
name: 'string'
properties: {
admin: 'string'
basicLoginInformation: {
password: 'string'
username: 'string'
}
dataControllerId: 'string'
endTime: 'string'
k8sRaw: any(...)
lastUploadedDate: 'string'
licenseType: 'string'
startTime: 'string'
}
sku: {
capacity: int
dev: bool
family: 'string'
name: 'string'
size: 'string'
tier: 'string'
}
tags: {
{customized property}: 'string'
}
}
Property Values
Microsoft.AzureArcData/sqlManagedInstances
| Name | Description | Value |
|---|---|---|
| extendedLocation | The extendedLocation of the resource. | ExtendedLocation |
| location | The geo-location where the resource lives | string (required) |
| name | The resource name | string (required) |
| properties | null | SqlManagedInstanceProperties (required) |
| sku | Resource sku. | SqlManagedInstanceSku |
| tags | Resource tags | Dictionary of tag names and values. See Tags in templates |
BasicLoginInformation
| Name | Description | Value |
|---|---|---|
| password | Login password. | string Constraints: Sensitive value. Pass in as a secure parameter. |
| username | Login username. | string |
ExtendedLocation
| Name | Description | Value |
|---|---|---|
| name | The name of the extended location. | string |
| type | The type of the extended location. | 'CustomLocation' |
SqlManagedInstanceProperties
| Name | Description | Value |
|---|---|---|
| admin | The instance admin user | string |
| basicLoginInformation | Username and password for basic authentication. | BasicLoginInformation |
| dataControllerId | null | string |
| endTime | The instance end time | string |
| k8sRaw | The raw kubernetes information | any |
| lastUploadedDate | Last uploaded date from Kubernetes cluster. Defaults to current date time | string |
| licenseType | The license type to apply for this managed instance. | 'BasePrice' 'LicenseIncluded' |
| startTime | The instance start time | string |
SqlManagedInstanceSku
| Name | Description | Value |
|---|---|---|
| capacity | int | |
| dev | Whether dev/test is enabled. When the dev field is set to true, the resource is used for dev/test purpose. | bool |
| family | string | |
| name | The name of the SKU. | 'vCore' (required) |
| size | The SKU size. When the name field is the combination of tier and some other value, this would be the standalone code. | string |
| tier | The tier for this managed instance. | 'BusinessCritical' 'GeneralPurpose' |
TrackedResourceTags
| Name | Description | Value |
|---|
ARM template resource definition
The sqlManagedInstances resource type can be deployed with operations that target:
- Resource groups - See resource group deployment commands
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.AzureArcData/sqlManagedInstances resource, add the following JSON to your template.
{
"type": "Microsoft.AzureArcData/sqlManagedInstances",
"apiVersion": "2021-07-01-preview",
"name": "string",
"extendedLocation": {
"name": "string",
"type": "string"
},
"location": "string",
"properties": {
"admin": "string",
"basicLoginInformation": {
"password": "string",
"username": "string"
},
"dataControllerId": "string",
"endTime": "string",
"k8sRaw": {},
"lastUploadedDate": "string",
"licenseType": "string",
"startTime": "string"
},
"sku": {
"capacity": "int",
"dev": "bool",
"family": "string",
"name": "string",
"size": "string",
"tier": "string"
},
"tags": {
"{customized property}": "string"
}
}
Property Values
Microsoft.AzureArcData/sqlManagedInstances
| Name | Description | Value |
|---|---|---|
| apiVersion | The api version | '2021-07-01-preview' |
| extendedLocation | The extendedLocation of the resource. | ExtendedLocation |
| location | The geo-location where the resource lives | string (required) |
| name | The resource name | string (required) |
| properties | null | SqlManagedInstanceProperties (required) |
| sku | Resource sku. | SqlManagedInstanceSku |
| tags | Resource tags | Dictionary of tag names and values. See Tags in templates |
| type | The resource type | 'Microsoft.AzureArcData/sqlManagedInstances' |
BasicLoginInformation
| Name | Description | Value |
|---|---|---|
| password | Login password. | string Constraints: Sensitive value. Pass in as a secure parameter. |
| username | Login username. | string |
ExtendedLocation
| Name | Description | Value |
|---|---|---|
| name | The name of the extended location. | string |
| type | The type of the extended location. | 'CustomLocation' |
SqlManagedInstanceProperties
| Name | Description | Value |
|---|---|---|
| admin | The instance admin user | string |
| basicLoginInformation | Username and password for basic authentication. | BasicLoginInformation |
| dataControllerId | null | string |
| endTime | The instance end time | string |
| k8sRaw | The raw kubernetes information | any |
| lastUploadedDate | Last uploaded date from Kubernetes cluster. Defaults to current date time | string |
| licenseType | The license type to apply for this managed instance. | 'BasePrice' 'LicenseIncluded' |
| startTime | The instance start time | string |
SqlManagedInstanceSku
| Name | Description | Value |
|---|---|---|
| capacity | int | |
| dev | Whether dev/test is enabled. When the dev field is set to true, the resource is used for dev/test purpose. | bool |
| family | string | |
| name | The name of the SKU. | 'vCore' (required) |
| size | The SKU size. When the name field is the combination of tier and some other value, this would be the standalone code. | string |
| tier | The tier for this managed instance. | 'BusinessCritical' 'GeneralPurpose' |
TrackedResourceTags
| Name | Description | Value |
|---|
Usage Examples
Terraform (AzAPI provider) resource definition
The sqlManagedInstances resource type can be deployed with operations that target:
- Resource groups
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.AzureArcData/sqlManagedInstances resource, add the following Terraform to your template.
resource "azapi_resource" "symbolicname" {
type = "Microsoft.AzureArcData/sqlManagedInstances@2021-07-01-preview"
name = "string"
parent_id = "string"
location = "string"
tags = {
{customized property} = "string"
}
body = {
extendedLocation = {
name = "string"
type = "string"
}
properties = {
admin = "string"
basicLoginInformation = {
password = "string"
username = "string"
}
dataControllerId = "string"
endTime = "string"
k8sRaw = ?
lastUploadedDate = "string"
licenseType = "string"
startTime = "string"
}
sku = {
capacity = int
dev = bool
family = "string"
name = "string"
size = "string"
tier = "string"
}
}
}
Property Values
Microsoft.AzureArcData/sqlManagedInstances
| Name | Description | Value |
|---|---|---|
| extendedLocation | The extendedLocation of the resource. | ExtendedLocation |
| location | The geo-location where the resource lives | string (required) |
| name | The resource name | string (required) |
| properties | null | SqlManagedInstanceProperties (required) |
| sku | Resource sku. | SqlManagedInstanceSku |
| tags | Resource tags | Dictionary of tag names and values. |
| type | The resource type | "Microsoft.AzureArcData/sqlManagedInstances@2021-07-01-preview" |
BasicLoginInformation
| Name | Description | Value |
|---|---|---|
| password | Login password. | string Constraints: Sensitive value. Pass in as a secure parameter. |
| username | Login username. | string |
ExtendedLocation
| Name | Description | Value |
|---|---|---|
| name | The name of the extended location. | string |
| type | The type of the extended location. | 'CustomLocation' |
SqlManagedInstanceProperties
| Name | Description | Value |
|---|---|---|
| admin | The instance admin user | string |
| basicLoginInformation | Username and password for basic authentication. | BasicLoginInformation |
| dataControllerId | null | string |
| endTime | The instance end time | string |
| k8sRaw | The raw kubernetes information | any |
| lastUploadedDate | Last uploaded date from Kubernetes cluster. Defaults to current date time | string |
| licenseType | The license type to apply for this managed instance. | 'BasePrice' 'LicenseIncluded' |
| startTime | The instance start time | string |
SqlManagedInstanceSku
| Name | Description | Value |
|---|---|---|
| capacity | int | |
| dev | Whether dev/test is enabled. When the dev field is set to true, the resource is used for dev/test purpose. | bool |
| family | string | |
| name | The name of the SKU. | 'vCore' (required) |
| size | The SKU size. When the name field is the combination of tier and some other value, this would be the standalone code. | string |
| tier | The tier for this managed instance. | 'BusinessCritical' 'GeneralPurpose' |
TrackedResourceTags
| Name | Description | Value |
|---|