Skip to main content

provider_instances

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

Overview

Nameprovider_instances
TypeResource
Idazure_isv.sap_workloads.provider_instances

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
identityobjectA pre-created user assigned identity with appropriate roles assigned. To learn more on identity and roles required, visit the ACSS how-to-guide.
propertiesobjectProvider Instance properties

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, monitorName, providerInstanceNameGets properties of a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.
listselectsubscriptionId, resourceGroupName, monitorNameGets a list of provider instances in the specified SAP monitor. The operations returns various properties of each provider instances.
createinsertsubscriptionId, resourceGroupName, monitorName, providerInstanceNameCreates a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.
deletedeletesubscriptionId, resourceGroupName, monitorName, providerInstanceNameDeletes a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
monitorNamestringName of the SAP monitor resource.
providerInstanceNamestringName of the provider instance.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Gets properties of a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.

SELECT
identity,
properties
FROM azure_isv.sap_workloads.provider_instances
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND monitorName = '{{ monitorName }}' -- required
AND providerInstanceName = '{{ providerInstanceName }}' -- required
;

INSERT examples

Creates a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.

INSERT INTO azure_isv.sap_workloads.provider_instances (
data__identity,
data__properties,
subscriptionId,
resourceGroupName,
monitorName,
providerInstanceName
)
SELECT
'{{ identity }}',
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ monitorName }}',
'{{ providerInstanceName }}'
RETURNING
identity,
properties
;

DELETE examples

Deletes a provider instance for the specified subscription, resource group, SAP monitor name, and resource name.

DELETE FROM azure_isv.sap_workloads.provider_instances
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND monitorName = '{{ monitorName }}' --required
AND providerInstanceName = '{{ providerInstanceName }}' --required
;