Skip to main content

spaces

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

Overview

Namespaces
TypeResource
Idazure.integration_environment.spaces

Fields

NameDatatypeDescription
descriptiontextfield from the properties object
locationtextThe geo-location where the resource lives
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
spaceNametextfield from the properties object
subscriptionIdtextfield from the properties object
tagstextResource tags.

Methods

NameAccessible byRequired ParamsDescription
getSELECTresourceGroupName, spaceName, subscriptionIdGet a Space
list_by_resource_groupSELECTresourceGroupName, subscriptionIdList Space resources by resource group
list_by_subscriptionSELECTsubscriptionIdList Space resources by subscription ID
create_or_updateINSERTresourceGroupName, spaceName, subscriptionIdCreate a Space
deleteDELETEresourceGroupName, spaceName, subscriptionIdDelete a Space
patchUPDATEresourceGroupName, spaceName, subscriptionIdUpdate a Space

SELECT examples

List Space resources by subscription ID

SELECT
description,
location,
provisioning_state,
resourceGroupName,
spaceName,
subscriptionId,
tags
FROM azure.integration_environment.vw_spaces
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

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

UPDATE example

Updates a spaces resource.

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

DELETE example

Deletes the specified spaces resource.

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