Skip to main content

skus_nested_resource_type_thirds

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

Overview

Nameskus_nested_resource_type_thirds
TypeResource
Idazure.provider_hub.skus_nested_resource_type_thirds

Fields

The following fields are returned by SELECT queries:

Successfully retrieved the resource type sku.

NameDatatypeDescription
propertiesobject

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, providerNamespace, resourceType, nestedResourceTypeFirst, nestedResourceTypeSecond, nestedResourceTypeThird, skuGets the sku details for the given resource type and sku name.
create_or_updateinsertsubscriptionId, providerNamespace, resourceType, nestedResourceTypeFirst, nestedResourceTypeSecond, nestedResourceTypeThird, skuCreates or updates the resource type skus in the given resource type.
deletedeletesubscriptionId, providerNamespace, resourceType, nestedResourceTypeFirst, nestedResourceTypeSecond, nestedResourceTypeThird, skuDeletes a resource type sku.

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
nestedResourceTypeFirststringThe first child resource type.
nestedResourceTypeSecondstringThe second child resource type.
nestedResourceTypeThirdstringThe third child resource type.
providerNamespacestringThe name of the resource provider hosted within ProviderHub.
resourceTypestringThe resource type.
skustringThe SKU.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Gets the sku details for the given resource type and sku name.

SELECT
properties
FROM azure.provider_hub.skus_nested_resource_type_thirds
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND providerNamespace = '{{ providerNamespace }}' -- required
AND resourceType = '{{ resourceType }}' -- required
AND nestedResourceTypeFirst = '{{ nestedResourceTypeFirst }}' -- required
AND nestedResourceTypeSecond = '{{ nestedResourceTypeSecond }}' -- required
AND nestedResourceTypeThird = '{{ nestedResourceTypeThird }}' -- required
AND sku = '{{ sku }}' -- required
;

INSERT examples

Creates or updates the resource type skus in the given resource type.

INSERT INTO azure.provider_hub.skus_nested_resource_type_thirds (
data__properties,
subscriptionId,
providerNamespace,
resourceType,
nestedResourceTypeFirst,
nestedResourceTypeSecond,
nestedResourceTypeThird,
sku
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ providerNamespace }}',
'{{ resourceType }}',
'{{ nestedResourceTypeFirst }}',
'{{ nestedResourceTypeSecond }}',
'{{ nestedResourceTypeThird }}',
'{{ sku }}'
RETURNING
properties
;

DELETE examples

Deletes a resource type sku.

DELETE FROM azure.provider_hub.skus_nested_resource_type_thirds
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND providerNamespace = '{{ providerNamespace }}' --required
AND resourceType = '{{ resourceType }}' --required
AND nestedResourceTypeFirst = '{{ nestedResourceTypeFirst }}' --required
AND nestedResourceTypeSecond = '{{ nestedResourceTypeSecond }}' --required
AND nestedResourceTypeThird = '{{ nestedResourceTypeThird }}' --required
AND sku = '{{ sku }}' --required
;