Skip to main content

skus_nested_resource_type_firsts

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

Overview

Nameskus_nested_resource_type_firsts
TypeResource
Idazure.provider_hub.skus_nested_resource_type_firsts

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, skuGets the sku details for the given resource type and sku name.
create_or_updateinsertsubscriptionId, providerNamespace, resourceType, nestedResourceTypeFirst, skuCreates or updates the resource type skus in the given resource type.
deletedeletesubscriptionId, providerNamespace, resourceType, nestedResourceTypeFirst, 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.
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_firsts
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND providerNamespace = '{{ providerNamespace }}' -- required
AND resourceType = '{{ resourceType }}' -- required
AND nestedResourceTypeFirst = '{{ nestedResourceTypeFirst }}' -- 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_firsts (
data__properties,
subscriptionId,
providerNamespace,
resourceType,
nestedResourceTypeFirst,
sku
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ providerNamespace }}',
'{{ resourceType }}',
'{{ nestedResourceTypeFirst }}',
'{{ sku }}'
RETURNING
properties
;

DELETE examples

Deletes a resource type sku.

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