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

vw_sql_managed_instances

Name	Datatype	Description
active_directory_information	text	field from the properties object
admin	text	field from the properties object
basic_login_information	text	field from the properties object
cluster_id	text	field from the properties object
data_controller_id	text	field from the properties object
end_time	text	field from the properties object
extended_location	text	field from the properties object
extension_id	text	field from the properties object
k8s_raw	text	field from the properties object
last_uploaded_date	text	field from the properties object
license_type	text	field from the properties object
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	The resource model definition representing SKU for Azure Managed Instance - Azure Arc
sqlManagedInstanceName	text	field from the properties object
start_time	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

sql_managed_instances

Name	Datatype	Description
extendedLocation	object	The complex type of the extended location.
location	string	The geo-location where the resource lives
properties	object	Properties of sqlManagedInstance.
sku	object	The resource model definition representing SKU for Azure Managed Instance - Azure Arc
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sqlManagedInstanceName, subscriptionId	Retrieves a SQL Managed Instance resource
list	SELECT	subscriptionId
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all sqlManagedInstances in a resource group.
create	INSERT	resourceGroupName, sqlManagedInstanceName, subscriptionId, data__properties	Creates or replaces a SQL Managed Instance resource
delete	DELETE	resourceGroupName, sqlManagedInstanceName, subscriptionId	Deletes a SQL Managed Instance resource
update	UPDATE	resourceGroupName, sqlManagedInstanceName, subscriptionId	Updates a SQL Managed Instance resource

SELECT examples

vw_sql_managed_instances

SELECT
active_directory_information,
admin,
basic_login_information,
cluster_id,
data_controller_id,
end_time,
extended_location,
extension_id,
k8s_raw,
last_uploaded_date,
license_type,
location,
provisioning_state,
resourceGroupName,
sku,
sqlManagedInstanceName,
start_time,
subscriptionId,
tags
FROM azure.azure_arc_data.vw_sql_managed_instances
WHERE subscriptionId = '{{ subscriptionId }}';

sql_managed_instances

SELECT
extendedLocation,
location,
properties,
sku,
tags
FROM azure.azure_arc_data.sql_managed_instances
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new sql_managed_instances resource.

All Properties

/*+ create */
INSERT INTO azure.azure_arc_data.sql_managed_instances (
resourceGroupName,
sqlManagedInstanceName,
subscriptionId,
data__properties,
tags,
location,
properties,
extendedLocation,
sku
)
SELECT 
'{{ resourceGroupName }}',
'{{ sqlManagedInstanceName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ extendedLocation }}',
'{{ sku }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: dataControllerId
          value: string
        - name: admin
          value: string
        - name: startTime
          value: string
        - name: endTime
          value: string
        - name: k8sRaw
          value:
            - name: spec
              value:
                - name: scheduling
                  value:
                    - name: default
                      value:
                        - name: resources
                          value:
                            - name: requests
                              value: object
                            - name: limits
                              value: object
                - name: replicas
                  value: integer
                - name: security
                  value:
                    - name: adminLoginSecret
                      value: string
                    - name: serviceCertificateSecret
                      value: string
                    - name: activeDirectory
                      value:
                        - name: connector
                          value:
                            - name: name
                              value: string
                            - name: namespace
                              value: string
                        - name: accountName
                          value: string
                        - name: keytabSecret
                          value: string
                        - name: encryptionTypes
                          value:
                            - string
                    - name: transparentDataEncryption
                      value:
                        - name: mode
                          value: string
                        - name: protectorSecret
                          value: string
                - name: settings
                  value:
                    - name: network
                      value:
                        - name: forceencryption
                          value: integer
                        - name: tlsciphers
                          value: string
                        - name: tlsprotocols
                          value: string
        - name: basicLoginInformation
          value:
            - name: username
              value: string
            - name: password
              value: string
        - name: lastUploadedDate
          value: string
        - name: provisioningState
          value: string
        - name: activeDirectoryInformation
          value:
            - name: keytabInformation
              value:
                - name: keytab
                  value: string
        - name: licenseType
          value: string
        - name: clusterId
          value: string
        - name: extensionId
          value: string
    - name: extendedLocation
      value:
        - name: name
          value: string
        - name: type
          value: []
    - name: sku
      value:
        - name: name
          value: string
        - name: tier
          value: string
        - name: dev
          value: boolean
        - name: size
          value: string
        - name: family
          value: string
        - name: capacity
          value: integer

UPDATE example

Updates a sql_managed_instances resource.

/*+ update */
UPDATE azure.azure_arc_data.sql_managed_instances
SET 
tags = '{{ tags }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND sqlManagedInstanceName = '{{ sqlManagedInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified sql_managed_instances resource.

/*+ delete */
DELETE FROM azure.azure_arc_data.sql_managed_instances
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlManagedInstanceName = '{{ sqlManagedInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';