savings_plans

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

Overview

Name	savings_plans
Type	Resource
Id	azure.billing_benefits.savings_plans

Fields

vw_savings_plans

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
benefit_start_time	text	field from the properties object
billing_account_id	text	field from the properties object
billing_plan	text	field from the properties object
billing_profile_id	text	field from the properties object
billing_scope_id	text	field from the properties object
commitment	text	field from the properties object
customer_id	text	field from the properties object
display_name	text	field from the properties object
display_provisioning_state	text	field from the properties object
effective_date_time	text	field from the properties object
expiry_date_time	text	field from the properties object
extended_status_info	text	field from the properties object
provisioning_state	text	field from the properties object
purchase_date_time	text	field from the properties object
renew	text	field from the properties object
renew_destination	text	field from the properties object
renew_properties	text	field from the properties object
renew_source	text	field from the properties object
savingsPlanId	text	field from the properties object
savingsPlanOrderId	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"
user_friendly_applied_scope_type	text	field from the properties object
utilization	text	field from the properties object

savings_plans

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
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	savingsPlanId, savingsPlanOrderId	Get savings plan.
list	SELECT	savingsPlanOrderId	List savings plans in an order.
list_all	SELECT		List savings plans.
update	UPDATE	savingsPlanId, savingsPlanOrderId	Update savings plan.
validate_update	EXEC	savingsPlanId, savingsPlanOrderId	Validate savings plan patch.

SELECT examples

List savings plans.

vw_savings_plans

SELECT
id,
name,
applied_scope_properties,
applied_scope_type,
benefit_start_time,
billing_account_id,
billing_plan,
billing_profile_id,
billing_scope_id,
commitment,
customer_id,
display_name,
display_provisioning_state,
effective_date_time,
expiry_date_time,
extended_status_info,
provisioning_state,
purchase_date_time,
renew,
renew_destination,
renew_properties,
renew_source,
savingsPlanId,
savingsPlanOrderId,
sku,
system_data,
term,
type,
user_friendly_applied_scope_type,
utilization
FROM azure.billing_benefits.vw_savings_plans
;

savings_plans

SELECT
id,
name,
properties,
sku,
systemData,
type
FROM azure.billing_benefits.savings_plans
;

UPDATE example

Updates a savings_plans resource.

/*+ update */
UPDATE azure.billing_benefits.savings_plans
SET 
properties = '{{ properties }}'
WHERE 
savingsPlanId = '{{ savingsPlanId }}'
AND savingsPlanOrderId = '{{ savingsPlanOrderId }}';