vw_balances

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

Overview

Name	vw_balances
Type	View
Id	azure.consumption.vw_balances

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
JSON_EXTRACT(properties, '$.currency') as "currency",
JSON_EXTRACT(properties, '$.beginningBalance') as "beginning_balance",
JSON_EXTRACT(properties, '$.endingBalance') as "ending_balance",
JSON_EXTRACT(properties, '$.newPurchases') as "new_purchases",
JSON_EXTRACT(properties, '$.adjustments') as "adjustments",
JSON_EXTRACT(properties, '$.utilized') as "utilized",
JSON_EXTRACT(properties, '$.serviceOverage') as "service_overage",
JSON_EXTRACT(properties, '$.chargesBilledSeparately') as "charges_billed_separately",
JSON_EXTRACT(properties, '$.totalOverage') as "total_overage",
JSON_EXTRACT(properties, '$.totalUsage') as "total_usage",
JSON_EXTRACT(properties, '$.azureMarketplaceServiceCharges') as "azure_marketplace_service_charges",
JSON_EXTRACT(properties, '$.billingFrequency') as "billing_frequency",
JSON_EXTRACT(properties, '$.priceHidden') as "price_hidden",
JSON_EXTRACT(properties, '$.overageRefund') as "overage_refund",
JSON_EXTRACT(properties, '$.newPurchasesDetails') as "new_purchases_details",
JSON_EXTRACT(properties, '$.adjustmentDetails') as "adjustment_details",
billingAccountId
FROM azure.consumption.balances
WHERE billingAccountId = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
json_extract_path_text(properties, '$.currency') as "currency",
json_extract_path_text(properties, '$.beginningBalance') as "beginning_balance",
json_extract_path_text(properties, '$.endingBalance') as "ending_balance",
json_extract_path_text(properties, '$.newPurchases') as "new_purchases",
json_extract_path_text(properties, '$.adjustments') as "adjustments",
json_extract_path_text(properties, '$.utilized') as "utilized",
json_extract_path_text(properties, '$.serviceOverage') as "service_overage",
json_extract_path_text(properties, '$.chargesBilledSeparately') as "charges_billed_separately",
json_extract_path_text(properties, '$.totalOverage') as "total_overage",
json_extract_path_text(properties, '$.totalUsage') as "total_usage",
json_extract_path_text(properties, '$.azureMarketplaceServiceCharges') as "azure_marketplace_service_charges",
json_extract_path_text(properties, '$.billingFrequency') as "billing_frequency",
json_extract_path_text(properties, '$.priceHidden') as "price_hidden",
json_extract_path_text(properties, '$.overageRefund') as "overage_refund",
json_extract_path_text(properties, '$.newPurchasesDetails') as "new_purchases_details",
json_extract_path_text(properties, '$.adjustmentDetails') as "adjustment_details",
billingAccountId
FROM azure.consumption.balances
WHERE billingAccountId = 'replace-me';