connections

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

Overview

Name	connections
Type	Resource
Id	azure.automation.connections

Fields

vw_connections

Name	Datatype	Description
description	text	field from the properties object
automationAccountName	text	field from the properties object
connectionName	text	field from the properties object
connection_type	text	field from the properties object
creation_time	text	field from the properties object
field_definition_values	text	field from the properties object
last_modified_time	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object

connections

Name	Datatype	Description
properties	object	Definition of the connection properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	automationAccountName, connectionName, resourceGroupName, subscriptionId	Retrieve the connection identified by connection name.
list_by_automation_account	SELECT	automationAccountName, resourceGroupName, subscriptionId	Retrieve a list of connections.
create_or_update	INSERT	automationAccountName, connectionName, resourceGroupName, subscriptionId, data__name, data__properties	Create or update a connection.
delete	DELETE	automationAccountName, connectionName, resourceGroupName, subscriptionId	Delete the connection.
update	UPDATE	automationAccountName, connectionName, resourceGroupName, subscriptionId	Update a connection.

SELECT examples

Retrieve a list of connections.

vw_connections

SELECT
description,
automationAccountName,
connectionName,
connection_type,
creation_time,
field_definition_values,
last_modified_time,
resourceGroupName,
subscriptionId
FROM azure.automation.vw_connections
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

connections

SELECT
properties
FROM azure.automation.connections
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.automation.connections (
automationAccountName,
connectionName,
resourceGroupName,
subscriptionId,
data__name,
data__properties,
name,
properties
)
SELECT 
'{{ automationAccountName }}',
'{{ connectionName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__name }}',
'{{ data__properties }}',
'{{ name }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: properties
      value:
        - name: description
          value: string
        - name: connectionType
          value:
            - name: name
              value: string
        - name: fieldDefinitionValues
          value: object

UPDATE example

Updates a connections resource.

/*+ update */
UPDATE azure.automation.connections
SET 
name = '{{ name }}',
properties = '{{ properties }}'
WHERE 
automationAccountName = '{{ automationAccountName }}'
AND connectionName = '{{ connectionName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified connections resource.

/*+ delete */
DELETE FROM azure.automation.connections
WHERE automationAccountName = '{{ automationAccountName }}'
AND connectionName = '{{ connectionName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';