BudgetsCData Power BI Connector for AWS Data Management 2019 - Build 19.0.7362
Lists the budgets that are associated with an account.
Table Specific Information
No special permissions are required to use this view.
AccountId is required. Server-side filtering is supported only on AccountId, while other filters are processed client-side within the connector.
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
SELECT * FROM Budgets WHERE AccountId='xxxxxxxxxxxx'
|AccountId||String||The accountId that is associated with the budgets that you want descriptions of.|
|BudgetLimitAmount||String||The total amount of cost, usage, RI utilization, or RI coverage that you want to track with your budget.|
|BudgetLimitUnit||String||The unit of measurement that is used for the budget forecast, actual spend, or budget threshold, such as dollars or GB.|
|BudgetName||String||The name of a budget. The name must be unique within accounts.|
|BudgetType||String||Whether this budget tracks monetary costs, usage, RI utilization, or RI coverage.|
|CalculatedActualAmount||String||The actual cost or usage that the budget tracks.|
|CalculatedActualUnit||String||The unit of measurement that is used for the budget forecast, actual spend, or budget threshold, such as dollars or GB.|
|CalculatedForecastedAmount||String||The forecasted cost or usage that the budget tracks.|
|CalculatedForecastedUnit||String||The unit of measurement that is used for the budget forecast, actual spend, or budget threshold, such as dollars or GB.|
|CostFilters||String||The cost filters, such as service or region, that are applied to a budget.|
|IncludeCredit||Boolean||Specifies whether a budget includes credits.|
|IncludeDiscount||Boolean||Specifies whether a budget includes discounts.|
|IncludeOtherSubscription||Boolean||Specifies whether a budget includes non-RI subscription costs.|
|IncludeRecurring||Boolean||Specifies whether a budget includes recurring fees such as monthly RI fees.|
|IncludeRefund||Boolean||Specifies whether a budget includes refunds.|
|IncludeSubscription||Boolean||Specifies whether a budget includes subscriptions.|
|IncludeSupport||Boolean||Specifies whether a budget includes support subscription fees.|
|IncludeTax||Boolean||Specifies whether a budget includes taxes.|
|IncludeUpfront||Boolean||Specifies whether a budget includes upfront RI costs.|
|UseBlended||Boolean||Specifies whether a budget uses a rate.|
|StartDate||Date||The start date for retrieving the budget.|
|EndDate||Date||The end date for retrieving the budget.|
|TimeUnit||String||The length of time until a budget resets the actual and forecasted spend. DAILY is available only for RI_UTILIZATION and RI_COVERAGE budgets.|