Skip to main content

guest_subscriptions

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

Overview

Nameguest_subscriptions
TypeResource
Idazure.compute_limit.guest_subscriptions

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
provisioningStatestringThe provisioning state of the resource. Known values are: "Succeeded", "Failed", and "Canceled". (Succeeded, Failed, Canceled)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectlocation, guest_subscription_id, subscription_idGets the properties of a guest subscription.
list_by_subscription_location_resourceselectlocation, subscription_idLists all guest subscriptions in a location.
createinsertlocation, guest_subscription_id, subscription_idAdds a subscription as a guest to consume the compute limits shared by the host subscription.
deletedeletelocation, guest_subscription_id, subscription_idDeletes a subscription as a guest to stop consuming the compute limits shared by the host subscription.

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
guest_subscription_idstringThe name of the GuestSubscription. Required.
locationstringThe name of the Azure region. Required.
subscription_idstring

SELECT examples

Gets the properties of a guest subscription.

SELECT
id,
name,
provisioningState,
systemData,
type
FROM azure.compute_limit.guest_subscriptions
WHERE location = '{{ location }}' -- required
AND guest_subscription_id = '{{ guest_subscription_id }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Adds a subscription as a guest to consume the compute limits shared by the host subscription.

INSERT INTO azure.compute_limit.guest_subscriptions (
properties,
location,
guest_subscription_id,
subscription_id
)
SELECT
'{{ properties }}',
'{{ location }}',
'{{ guest_subscription_id }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Deletes a subscription as a guest to stop consuming the compute limits shared by the host subscription.

DELETE FROM azure.compute_limit.guest_subscriptions
WHERE location = '{{ location }}' --required
AND guest_subscription_id = '{{ guest_subscription_id }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;