infrastructure_resources

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

Overview

Name	infrastructure_resources
Type	Resource
Id	azure.integration_environment.infrastructure_resources

Fields

vw_infrastructure_resources

Name	Datatype	Description
infrastructureResourceName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_id	text	field from the properties object
resource_type	text	field from the properties object
spaceName	text	field from the properties object
subscriptionId	text	field from the properties object

infrastructure_resources

Name	Datatype	Description
properties	object	The properties of infrastructure resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	infrastructureResourceName, resourceGroupName, spaceName, subscriptionId	Get a InfrastructureResource
list_by_space	SELECT	resourceGroupName, spaceName, subscriptionId	List InfrastructureResource resources by Space
create_or_update	INSERT	infrastructureResourceName, resourceGroupName, spaceName, subscriptionId	Create a InfrastructureResource
delete	DELETE	infrastructureResourceName, resourceGroupName, spaceName, subscriptionId	Delete a InfrastructureResource
patch	UPDATE	infrastructureResourceName, resourceGroupName, spaceName, subscriptionId	Update a InfrastructureResource

SELECT examples

List InfrastructureResource resources by Space

vw_infrastructure_resources

SELECT
infrastructureResourceName,
provisioning_state,
resourceGroupName,
resource_id,
resource_type,
spaceName,
subscriptionId
FROM azure.integration_environment.vw_infrastructure_resources
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND spaceName = '{{ spaceName }}'
AND subscriptionId = '{{ subscriptionId }}';

infrastructure_resources

SELECT
properties
FROM azure.integration_environment.infrastructure_resources
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND spaceName = '{{ spaceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.integration_environment.infrastructure_resources (
infrastructureResourceName,
resourceGroupName,
spaceName,
subscriptionId,
properties
)
SELECT 
'{{ infrastructureResourceName }}',
'{{ resourceGroupName }}',
'{{ spaceName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: resourceType
          value: string
        - name: resourceId
          value: string

UPDATE example

Updates a infrastructure_resources resource.

/*+ update */
UPDATE azure.integration_environment.infrastructure_resources
SET 
properties = '{{ properties }}'
WHERE 
infrastructureResourceName = '{{ infrastructureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND spaceName = '{{ spaceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified infrastructure_resources resource.

/*+ delete */
DELETE FROM azure.integration_environment.infrastructure_resources
WHERE infrastructureResourceName = '{{ infrastructureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND spaceName = '{{ spaceName }}'
AND subscriptionId = '{{ subscriptionId }}';