Skip to main content

vw_properties

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

Overview​

Namevw_properties
TypeView
Idazure.billing.vw_properties

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
tags as tags,
JSON_EXTRACT(properties, '$.billingAccountAgreementType') as "billing_account_agreement_type",
JSON_EXTRACT(properties, '$.billingAccountDisplayName') as "billing_account_display_name",
JSON_EXTRACT(properties, '$.billingAccountId') as "billing_account_id",
JSON_EXTRACT(properties, '$.accountAdminNotificationEmailAddress') as "account_admin_notification_email_address",
JSON_EXTRACT(properties, '$.billingAccountSoldToCountry') as "billing_account_sold_to_country",
JSON_EXTRACT(properties, '$.billingAccountStatus') as "billing_account_status",
JSON_EXTRACT(properties, '$.billingAccountStatusReasonCode') as "billing_account_status_reason_code",
JSON_EXTRACT(properties, '$.billingAccountType') as "billing_account_type",
JSON_EXTRACT(properties, '$.billingAccountSubType') as "billing_account_sub_type",
JSON_EXTRACT(properties, '$.billingCurrency') as "billing_currency",
JSON_EXTRACT(properties, '$.billingProfileDisplayName') as "billing_profile_display_name",
JSON_EXTRACT(properties, '$.billingProfileId') as "billing_profile_id",
JSON_EXTRACT(properties, '$.billingProfileSpendingLimit') as "billing_profile_spending_limit",
JSON_EXTRACT(properties, '$.billingProfileSpendingLimitDetails') as "billing_profile_spending_limit_details",
JSON_EXTRACT(properties, '$.billingProfileStatus') as "billing_profile_status",
JSON_EXTRACT(properties, '$.billingProfileStatusReasonCode') as "billing_profile_status_reason_code",
JSON_EXTRACT(properties, '$.billingProfilePaymentMethodFamily') as "billing_profile_payment_method_family",
JSON_EXTRACT(properties, '$.billingProfilePaymentMethodType') as "billing_profile_payment_method_type",
JSON_EXTRACT(properties, '$.billingTenantId') as "billing_tenant_id",
JSON_EXTRACT(properties, '$.costCenter') as "cost_center",
JSON_EXTRACT(properties, '$.customerDisplayName') as "customer_display_name",
JSON_EXTRACT(properties, '$.customerId') as "customer_id",
JSON_EXTRACT(properties, '$.customerStatus') as "customer_status",
JSON_EXTRACT(properties, '$.invoiceSectionDisplayName') as "invoice_section_display_name",
JSON_EXTRACT(properties, '$.invoiceSectionId') as "invoice_section_id",
JSON_EXTRACT(properties, '$.invoiceSectionStatus') as "invoice_section_status",
JSON_EXTRACT(properties, '$.invoiceSectionStatusReasonCode') as "invoice_section_status_reason_code",
JSON_EXTRACT(properties, '$.isTransitionedBillingAccount') as "is_transitioned_billing_account",
JSON_EXTRACT(properties, '$.skuDescription') as "sku_description",
JSON_EXTRACT(properties, '$.skuId') as "sku_id",
JSON_EXTRACT(properties, '$.subscriptionBillingStatus') as "subscription_billing_status",
JSON_EXTRACT(properties, '$.subscriptionBillingStatusDetails') as "subscription_billing_status_details",
JSON_EXTRACT(properties, '$.subscriptionBillingType') as "subscription_billing_type",
JSON_EXTRACT(properties, '$.subscriptionServiceUsageAddress') as "subscription_service_usage_address",
JSON_EXTRACT(properties, '$.subscriptionWorkloadType') as "subscription_workload_type",
JSON_EXTRACT(properties, '$.enrollmentDetails') as "enrollment_details",
JSON_EXTRACT(properties, '$.isAccountAdmin') as "is_account_admin",
JSON_EXTRACT(properties, '$.productId') as "product_id",
JSON_EXTRACT(properties, '$.productName') as "product_name",
subscriptionId
FROM azure.billing.properties
WHERE subscriptionId = 'replace-me';