skus

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

Overview

Name	skus
Type	Resource
Id	azure.provider_hub.skus

Fields

The following fields are returned by SELECT queries:

list_by_resource_type_registrations_nested_resource_type_third

SUccessfully retrieved the resource type skus.

Name	Datatype	Description
properties	object

list_by_resource_type_registrations_nested_resource_type_second

SUccessfully retrieved the resource type skus.

Name	Datatype	Description
properties	object

get

Successfully retrieved the resource type sku.

Name	Datatype	Description
properties	object

list_by_resource_type_registrations_nested_resource_type_first

SUccessfully retrieved the resource type skus.

Name	Datatype	Description
properties	object

list_by_resource_type_registrations

SUccessfully retrieved the resource type skus.

Name	Datatype	Description
properties	object

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_by_resource_type_registrations_nested_resource_type_third	select	subscriptionId, providerNamespace, resourceType, nestedResourceTypeFirst, nestedResourceTypeSecond, nestedResourceTypeThird		Gets the list of skus for the given resource type.
list_by_resource_type_registrations_nested_resource_type_second	select	subscriptionId, providerNamespace, resourceType, nestedResourceTypeFirst, nestedResourceTypeSecond		Gets the list of skus for the given resource type.
get	select	subscriptionId, providerNamespace, resourceType, sku		Gets the sku details for the given resource type and sku name.
list_by_resource_type_registrations_nested_resource_type_first	select	subscriptionId, providerNamespace, resourceType, nestedResourceTypeFirst		Gets the list of skus for the given resource type.
list_by_resource_type_registrations	select	subscriptionId, providerNamespace, resourceType		Gets the list of skus for the given resource type.
create_or_update	insert	subscriptionId, providerNamespace, resourceType, sku		Creates or updates the resource type skus in the given resource type.
delete	delete	subscriptionId, providerNamespace, resourceType, sku		Deletes 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.

Name	Datatype	Description
nestedResourceTypeFirst	string	The first child resource type.
nestedResourceTypeSecond	string	The second child resource type.
nestedResourceTypeThird	string	The third child resource type.
providerNamespace	string	The name of the resource provider hosted within ProviderHub.
resourceType	string	The resource type.
sku	string	The SKU.
subscriptionId	string	The ID of the target subscription.

SELECT examples

list_by_resource_type_registrations_nested_resource_type_third

Gets the list of skus for the given resource type.

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

list_by_resource_type_registrations_nested_resource_type_second

Gets the list of skus for the given resource type.

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

get

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

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

list_by_resource_type_registrations_nested_resource_type_first

Gets the list of skus for the given resource type.

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

list_by_resource_type_registrations

Gets the list of skus for the given resource type.

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

INSERT examples

create_or_update

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

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

Manifest

# Description fields are for documentation purposes
- name: skus
  props:
    - name: subscriptionId
      value: string
      description: Required parameter for the skus resource.
    - name: providerNamespace
      value: string
      description: Required parameter for the skus resource.
    - name: resourceType
      value: string
      description: Required parameter for the skus resource.
    - name: sku
      value: string
      description: Required parameter for the skus resource.
    - name: properties
      value: object

DELETE examples

delete

Deletes a resource type sku.

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