CData Power BI Connector for AWS Data Management 2019 - Online Help
Questions / Feedback?

Budgets

CData 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.

Select

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'

Columns

Name Type Description
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.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7362.0