properties

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

Overview

Name	properties
Type	Resource
Id	azure.billing.properties

Fields

vw_properties

Name	Datatype	Description
account_admin_notification_email_address	text	field from the properties object
billing_account_agreement_type	text	field from the properties object
billing_account_display_name	text	field from the properties object
billing_account_id	text	field from the properties object
billing_account_sold_to_country	text	field from the properties object
billing_account_status	text	field from the properties object
billing_account_status_reason_code	text	field from the properties object
billing_account_sub_type	text	field from the properties object
billing_account_type	text	field from the properties object
billing_currency	text	field from the properties object
billing_profile_display_name	text	field from the properties object
billing_profile_id	text	field from the properties object
billing_profile_payment_method_family	text	field from the properties object
billing_profile_payment_method_type	text	field from the properties object
billing_profile_spending_limit	text	field from the properties object
billing_profile_spending_limit_details	text	field from the properties object
billing_profile_status	text	field from the properties object
billing_profile_status_reason_code	text	field from the properties object
billing_tenant_id	text	field from the properties object
cost_center	text	field from the properties object
customer_display_name	text	field from the properties object
customer_id	text	field from the properties object
customer_status	text	field from the properties object
enrollment_details	text	field from the properties object
invoice_section_display_name	text	field from the properties object
invoice_section_id	text	field from the properties object
invoice_section_status	text	field from the properties object
invoice_section_status_reason_code	text	field from the properties object
is_account_admin	text	field from the properties object
is_transitioned_billing_account	text	field from the properties object
product_id	text	field from the properties object
product_name	text	field from the properties object
sku_description	text	field from the properties object
sku_id	text	field from the properties object
subscriptionId	text	field from the properties object
subscription_billing_status	text	field from the properties object
subscription_billing_status_details	text	field from the properties object
subscription_billing_type	text	field from the properties object
subscription_service_usage_address	text	field from the properties object
subscription_workload_type	text	field from the properties object
tags	text	Dictionary of metadata associated with the resource. It may not be populated for all resource types. Maximum key/value length supported of 256 characters. Keys/value should not empty value nor null. Keys can not contain < > % & \ ? /

properties

Name	Datatype	Description
properties	object	A billing property.
tags	object	Dictionary of metadata associated with the resource. It may not be populated for all resource types. Maximum key/value length supported of 256 characters. Keys/value should not empty value nor null. Keys can not contain < > % & \ ? /

Methods

Name	Accessible by	Required Params	Description
get	SELECT	subscriptionId	Gets the billing properties for a subscription
update	UPDATE	subscriptionId	Updates the billing property of a subscription. Currently, cost center can be updated for billing accounts with agreement type Microsoft Customer Agreement and subscription service usage address can be updated for billing accounts with agreement type Microsoft Online Service Program.

SELECT examples

Gets the billing properties for a subscription

vw_properties

SELECT
account_admin_notification_email_address,
billing_account_agreement_type,
billing_account_display_name,
billing_account_id,
billing_account_sold_to_country,
billing_account_status,
billing_account_status_reason_code,
billing_account_sub_type,
billing_account_type,
billing_currency,
billing_profile_display_name,
billing_profile_id,
billing_profile_payment_method_family,
billing_profile_payment_method_type,
billing_profile_spending_limit,
billing_profile_spending_limit_details,
billing_profile_status,
billing_profile_status_reason_code,
billing_tenant_id,
cost_center,
customer_display_name,
customer_id,
customer_status,
enrollment_details,
invoice_section_display_name,
invoice_section_id,
invoice_section_status,
invoice_section_status_reason_code,
is_account_admin,
is_transitioned_billing_account,
product_id,
product_name,
sku_description,
sku_id,
subscriptionId,
subscription_billing_status,
subscription_billing_status_details,
subscription_billing_type,
subscription_service_usage_address,
subscription_workload_type,
tags
FROM azure.billing.vw_properties
WHERE subscriptionId = '{{ subscriptionId }}';

properties

SELECT
properties,
tags
FROM azure.billing.properties
WHERE subscriptionId = '{{ subscriptionId }}';

UPDATE example

Updates a properties resource.

/*+ update */
UPDATE azure.billing.properties
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
subscriptionId = '{{ subscriptionId }}';