Skip to main content

budgets

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

Overview

Namebudgets
TypeResource
Iddatabricks_account.billing.budgets

Fields

The following fields are returned by SELECT queries:

Request completed successfully.

NameDatatypeDescription
account_idstring
budget_configuration_idstring
display_namestring
alert_configurationsarray
create_timeinteger
filterobject
update_timeinteger

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectGets a budget configuration for an account. Both account and budget configuration are specified by ID.
listselectGets all budgets associated with this account.
createinsertCreate a new budget configuration for an account. For full details, see
updatereplaceUpdates a budget configuration for an account. Both account and budget configuration are specified by ID.
deletedeleteDeletes a budget configuration for an account. Both account and budget configuration are specified by ID. This cannot be undone.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription

SELECT examples

Gets a budget configuration for an account. Both account and budget configuration are specified by ID.

SELECT
account_id,
budget_configuration_id,
display_name,
alert_configurations,
create_time,
filter,
update_time
FROM databricks_account.billing.budgets;

INSERT examples

Create a new budget configuration for an account. For full details, see

INSERT INTO databricks_account.billing.budgets (
data__budget
)
SELECT
'{{ budget }}'
RETURNING
budget
;

REPLACE examples

Updates a budget configuration for an account. Both account and budget configuration are specified by ID.

REPLACE databricks_account.billing.budgets
SET
data__budget = '{{ budget }}'
WHERE

RETURNING
budget;

DELETE examples

Deletes a budget configuration for an account. Both account and budget configuration are specified by ID. This cannot be undone.

DELETE FROM databricks_account.billing.budgets;