Skip to main content

savings_plan_order_aliases

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

Overview

Namesavings_plan_order_aliases
TypeResource
Idazure.billing_benefits.savings_plan_order_aliases

Fields

NameDatatypeDescription
idtextFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
nametextThe name of the resource
applied_scope_propertiestextfield from the properties object
applied_scope_typetextfield from the properties object
billing_plantextfield from the properties object
billing_scope_idtextfield from the properties object
commitmenttextfield from the properties object
display_nametextfield from the properties object
kindtextResource provider kind
provisioning_statetextfield from the properties object
renewtextfield from the properties object
savingsPlanOrderAliasNametextfield from the properties object
savings_plan_order_idtextfield from the properties object
skutextThe resource model definition representing SKU
system_datatextfield from the properties object
termtextfield from the properties object
typetextThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

NameAccessible byRequired ParamsDescription
getSELECTsavingsPlanOrderAliasNameGet a savings plan.
createINSERTsavingsPlanOrderAliasName, data__skuCreate a savings plan. Learn more about permissions needed at https://go.microsoft.com/fwlink/?linkid=2215851

SELECT examples

Get a savings plan.

SELECT
id,
name,
applied_scope_properties,
applied_scope_type,
billing_plan,
billing_scope_id,
commitment,
display_name,
kind,
provisioning_state,
renew,
savingsPlanOrderAliasName,
savings_plan_order_id,
sku,
system_data,
term,
type
FROM azure.billing_benefits.vw_savings_plan_order_aliases
WHERE savingsPlanOrderAliasName = '{{ savingsPlanOrderAliasName }}';

INSERT example

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

/*+ create */
INSERT INTO azure.billing_benefits.savings_plan_order_aliases (
savingsPlanOrderAliasName,
data__sku,
sku,
kind,
properties
)
SELECT
'{{ savingsPlanOrderAliasName }}',
'{{ data__sku }}',
'{{ sku }}',
'{{ kind }}',
'{{ properties }}'
;