savings_plan_order_aliases
Creates, updates, deletes, gets or lists a savings_plan_order_aliases
resource.
Overview
Name | savings_plan_order_aliases |
Type | Resource |
Id | azure.billing_benefits.savings_plan_order_aliases |
Fields
- vw_savings_plan_order_aliases
- savings_plan_order_aliases
Name | Datatype | Description |
---|---|---|
id | text | Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName} |
name | text | The name of the resource |
applied_scope_properties | text | field from the properties object |
applied_scope_type | text | field from the properties object |
billing_plan | text | field from the properties object |
billing_scope_id | text | field from the properties object |
commitment | text | field from the properties object |
display_name | text | field from the properties object |
kind | text | Resource provider kind |
provisioning_state | text | field from the properties object |
renew | text | field from the properties object |
savingsPlanOrderAliasName | text | field from the properties object |
savings_plan_order_id | text | field from the properties object |
sku | text | The resource model definition representing SKU |
system_data | text | field from the properties object |
term | text | field from the properties object |
type | text | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts" |
Name | Datatype | Description |
---|---|---|
id | string | Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName} |
name | string | The name of the resource |
kind | string | Resource provider kind |
properties | object | Savings plan properties |
sku | object | The resource model definition representing SKU |
systemData | object | Metadata pertaining to creation and last modification of the resource. |
type | string | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts" |
Methods
Name | Accessible by | Required Params | Description |
---|---|---|---|
get | SELECT | savingsPlanOrderAliasName | Get a savings plan. |
create | INSERT | savingsPlanOrderAliasName, data__sku | Create a savings plan. Learn more about permissions needed at https://go.microsoft.com/fwlink/?linkid=2215851 |
SELECT
examples
Get a savings plan.
- vw_savings_plan_order_aliases
- savings_plan_order_aliases
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 }}';
SELECT
id,
name,
kind,
properties,
sku,
systemData,
type
FROM azure.billing_benefits.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.
- All Properties
- Manifest
/*+ create */
INSERT INTO azure.billing_benefits.savings_plan_order_aliases (
savingsPlanOrderAliasName,
data__sku,
sku,
kind,
properties
)
SELECT
'{{ savingsPlanOrderAliasName }}',
'{{ data__sku }}',
'{{ sku }}',
'{{ kind }}',
'{{ properties }}'
;
- name: your_resource_model_name
props:
- name: id
value: string
- name: name
value: string
- name: type
value: string
- name: systemData
value:
- name: createdBy
value: string
- name: createdByType
value: string
- name: createdAt
value: string
- name: lastModifiedBy
value: string
- name: lastModifiedByType
value: string
- name: lastModifiedAt
value: string
- name: sku
value:
- name: name
value: string
- name: tier
value: []
- name: size
value: string
- name: family
value: string
- name: capacity
value: integer
- name: kind
value: string
- name: properties
value:
- name: displayName
value: []
- name: savingsPlanOrderId
value: string
- name: provisioningState
value: []
- name: billingScopeId
value: []
- name: term
value: []
- name: billingPlan
value: []
- name: appliedScopeType
value: []
- name: appliedScopeProperties
value:
- name: tenantId
value: []
- name: managementGroupId
value: []
- name: subscriptionId
value: []
- name: resourceGroupId
value: []
- name: displayName
value: string
- name: commitment
value:
- name: currencyCode
value: string
- name: amount
value: number
- name: grain
value: string
- name: renew
value: []