associations

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

Overview

Name	associations
Type	Resource
Id	azure.custom_providers.associations

Fields

Name	Datatype	Description
id	string	The association id.
name	string	The association name.
properties	object	The properties of the association.
type	string	The association type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	associationName, scope	Get an association.
list_all	SELECT	scope	Gets all association for the given scope.
create_or_update	INSERT	associationName, scope	Create or update an association.
delete	DELETE	associationName, scope	Delete an association.

SELECT examples

Gets all association for the given scope.

SELECT
id,
name,
properties,
type
FROM azure.custom_providers.associations
WHERE scope = '{{ scope }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.custom_providers.associations (
associationName,
scope,
properties
)
SELECT 
'{{ associationName }}',
'{{ scope }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: targetResourceId
          value: string
        - name: provisioningState
          value: string

DELETE example

Deletes the specified associations resource.

/*+ delete */
DELETE FROM azure.custom_providers.associations
WHERE associationName = '{{ associationName }}'
AND scope = '{{ scope }}';