vw_budgets

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

Overview

Name	vw_budgets
Type	View
Id	azure.consumption.vw_budgets

Fields

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

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.category') as "category",
JSON_EXTRACT(properties, '$.amount') as "amount",
JSON_EXTRACT(properties, '$.timeGrain') as "time_grain",
JSON_EXTRACT(properties, '$.timePeriod') as "time_period",
JSON_EXTRACT(properties, '$.filter') as "filter",
JSON_EXTRACT(properties, '$.currentSpend') as "current_spend",
JSON_EXTRACT(properties, '$.notifications') as "notifications",
JSON_EXTRACT(properties, '$.forecastSpend') as "forecast_spend",
scope,
budgetName
FROM azure.consumption.budgets
WHERE scope = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.category') as "category",
json_extract_path_text(properties, '$.amount') as "amount",
json_extract_path_text(properties, '$.timeGrain') as "time_grain",
json_extract_path_text(properties, '$.timePeriod') as "time_period",
json_extract_path_text(properties, '$.filter') as "filter",
json_extract_path_text(properties, '$.currentSpend') as "current_spend",
json_extract_path_text(properties, '$.notifications') as "notifications",
json_extract_path_text(properties, '$.forecastSpend') as "forecast_spend",
scope,
budgetName
FROM azure.consumption.budgets
WHERE scope = 'replace-me';