skus

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

Overview

Name	skus
Type	Resource
Id	azure.provider_hub.skus

Fields

Name	Datatype	Description
properties	object

Methods

Name	Accessible by	Required Params	Description
get	SELECT	providerNamespace, resourceType, sku, subscriptionId	Gets the sku details for the given resource type and sku name.
list_by_resource_type_registrations	SELECT	providerNamespace, resourceType, subscriptionId	Gets the list of skus for the given resource type.
list_by_resource_type_registrations_nested_resource_type_first	SELECT	nestedResourceTypeFirst, providerNamespace, resourceType, subscriptionId	Gets the list of skus for the given resource type.
list_by_resource_type_registrations_nested_resource_type_second	SELECT	nestedResourceTypeFirst, nestedResourceTypeSecond, providerNamespace, resourceType, subscriptionId	Gets the list of skus for the given resource type.
list_by_resource_type_registrations_nested_resource_type_third	SELECT	nestedResourceTypeFirst, nestedResourceTypeSecond, nestedResourceTypeThird, providerNamespace, resourceType, subscriptionId	Gets the list of skus for the given resource type.
create_or_update	INSERT	providerNamespace, resourceType, sku, subscriptionId	Creates or updates the resource type skus in the given resource type.
delete	DELETE	providerNamespace, resourceType, sku, subscriptionId	Deletes a resource type sku.

SELECT examples

Gets the list of skus for the given resource type.

SELECT
properties
FROM azure.provider_hub.skus
WHERE providerNamespace = '{{ providerNamespace }}'
AND resourceType = '{{ resourceType }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.provider_hub.skus (
providerNamespace,
resourceType,
sku,
subscriptionId,
properties
)
SELECT 
'{{ providerNamespace }}',
'{{ resourceType }}',
'{{ sku }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value: string

DELETE example

Deletes the specified skus resource.

/*+ delete */
DELETE FROM azure.provider_hub.skus
WHERE providerNamespace = '{{ providerNamespace }}'
AND resourceType = '{{ resourceType }}'
AND sku = '{{ sku }}'
AND subscriptionId = '{{ subscriptionId }}';