vw_credits

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

Overview

Name	vw_credits
Type	View
Id	azure.consumption.vw_credits

Fields

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

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.balanceSummary') as "balance_summary",
JSON_EXTRACT(properties, '$.pendingCreditAdjustments') as "pending_credit_adjustments",
JSON_EXTRACT(properties, '$.expiredCredit') as "expired_credit",
JSON_EXTRACT(properties, '$.pendingEligibleCharges') as "pending_eligible_charges",
JSON_EXTRACT(properties, '$.creditCurrency') as "credit_currency",
JSON_EXTRACT(properties, '$.billingCurrency') as "billing_currency",
JSON_EXTRACT(properties, '$.reseller') as "reseller",
JSON_EXTRACT(properties, '$.isEstimatedBalance') as "is_estimated_balance",
JSON_EXTRACT(properties, '$.eTag') as "e_tag",
billingAccountId,
billingProfileId
FROM azure.consumption.credits
WHERE billingAccountId = 'replace-me' AND billingProfileId = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.balanceSummary') as "balance_summary",
json_extract_path_text(properties, '$.pendingCreditAdjustments') as "pending_credit_adjustments",
json_extract_path_text(properties, '$.expiredCredit') as "expired_credit",
json_extract_path_text(properties, '$.pendingEligibleCharges') as "pending_eligible_charges",
json_extract_path_text(properties, '$.creditCurrency') as "credit_currency",
json_extract_path_text(properties, '$.billingCurrency') as "billing_currency",
json_extract_path_text(properties, '$.reseller') as "reseller",
json_extract_path_text(properties, '$.isEstimatedBalance') as "is_estimated_balance",
json_extract_path_text(properties, '$.eTag') as "e_tag",
billingAccountId,
billingProfileId
FROM azure.consumption.credits
WHERE billingAccountId = 'replace-me' AND billingProfileId = 'replace-me';