sql_managed_instances

Creates, updates, deletes, gets or lists a sql_managed_instances resource.

Overview

Name	sql_managed_instances
Type	Resource
Id	azure.azure_arc_data.sql_managed_instances

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
extendedLocation	object	The extendedLocation of the resource.
location	string	The geo-location where the resource lives
properties	object	null
sku	object	Resource sku.
tags	object	Resource tags.

list_by_resource_group

Name	Datatype	Description
extendedLocation	object	The extendedLocation of the resource.
location	string	The geo-location where the resource lives
properties	object	null
sku	object	Resource sku.
tags	object	Resource tags.

list

Name	Datatype	Description
extendedLocation	object	The extendedLocation of the resource.
location	string	The geo-location where the resource lives
properties	object	null
sku	object	Resource sku.
tags	object	Resource tags.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, sqlManagedInstanceName	api-version	Retrieves a SQL Managed Instance resource
list_by_resource_group	select	subscriptionId, resourceGroupName	api-version	Gets all sqlManagedInstances in a resource group.
list	select	subscriptionId	api-version
create	insert	subscriptionId, resourceGroupName, sqlManagedInstanceName, data__properties	api-version	Creates or replaces a SQL Managed Instance resource
update	update	subscriptionId, resourceGroupName, sqlManagedInstanceName	api-version	Updates a SQL Managed Instance resource
delete	delete	subscriptionId, resourceGroupName, sqlManagedInstanceName	api-version	Deletes a SQL Managed Instance resource

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
resourceGroupName	string	The name of the Azure resource group
sqlManagedInstanceName	string	Name of SQL Managed Instance
subscriptionId	string	The ID of the Azure subscription
api-version	string	The API version to use for the request

SELECT examples

get

Retrieves a SQL Managed Instance resource

SELECT
extendedLocation,
location,
properties,
sku,
tags
FROM azure.azure_arc_data.sql_managed_instances
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND sqlManagedInstanceName = '{{ sqlManagedInstanceName }}' -- required
AND api-version = '{{ api-version }}'
;

list_by_resource_group

Gets all sqlManagedInstances in a resource group.

SELECT
extendedLocation,
location,
properties,
sku,
tags
FROM azure.azure_arc_data.sql_managed_instances
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND api-version = '{{ api-version }}'
;

list

OK

SELECT
extendedLocation,
location,
properties,
sku,
tags
FROM azure.azure_arc_data.sql_managed_instances
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND api-version = '{{ api-version }}'
;

INSERT examples

create

Creates or replaces a SQL Managed Instance resource

INSERT INTO azure.azure_arc_data.sql_managed_instances (
data__tags,
data__location,
data__properties,
data__extendedLocation,
data__sku,
subscriptionId,
resourceGroupName,
sqlManagedInstanceName,
api-version
)
SELECT 
'{{ tags }}',
'{{ location }}',
'{{ properties }}' /* required */,
'{{ extendedLocation }}',
'{{ sku }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ sqlManagedInstanceName }}',
'{{ api-version }}'
RETURNING
extendedLocation,
location,
properties,
sku,
tags
;

Manifest

# Description fields are for documentation purposes
- name: sql_managed_instances
  props:
    - name: subscriptionId
      value: string
      description: Required parameter for the sql_managed_instances resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the sql_managed_instances resource.
    - name: sqlManagedInstanceName
      value: string
      description: Required parameter for the sql_managed_instances resource.
    - name: tags
      value: object
      description: |
        Resource tags.
    - name: location
      value: string
      description: |
        The geo-location where the resource lives
    - name: properties
      value: object
      description: |
        null
    - name: extendedLocation
      value: object
      description: |
        The extendedLocation of the resource.
    - name: sku
      value: object
      description: |
        Resource sku.
    - name: api-version
      value: string
      description: The API version to use for the request

UPDATE examples

update

Updates a SQL Managed Instance resource

UPDATE azure.azure_arc_data.sql_managed_instances
SET 
data__tags = '{{ tags }}'
WHERE 
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND sqlManagedInstanceName = '{{ sqlManagedInstanceName }}' --required
AND api-version = '{{ api-version}}'
RETURNING
extendedLocation,
location,
properties,
sku,
tags;

DELETE examples

delete

Deletes a SQL Managed Instance resource

DELETE FROM azure.azure_arc_data.sql_managed_instances
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND sqlManagedInstanceName = '{{ sqlManagedInstanceName }}' --required
AND api-version = '{{ api-version }}'
;