account_settings

Creates, updates, deletes, gets or lists an account_settings resource.

Overview

Name	account_settings
Type	Resource
Id	databricks_account.settingsv2.account_settings

Fields

The following fields are returned by SELECT queries:

get_public_account_setting

Name	Datatype	Description
name	string	Name of the setting.
▶aibi_dashboard_embedding_access_policy	object
▶aibi_dashboard_embedding_approved_domains	object	Setting value for aibi_dashboard_embedding_approved_domains setting. This is the setting value set by consumers, check effective_aibi_dashboard_embedding_approved_domains for final setting value.
▶automatic_cluster_update_workspace	object	Setting value for automatic_cluster_update_workspace setting. This is the setting value set by consumers, check effective_automatic_cluster_update_workspace for final setting value.
▶boolean_val	object	Setting value for boolean type setting. This is the setting value set by consumers, check effective_boolean_val for final setting value.
▶effective_aibi_dashboard_embedding_access_policy	object	Effective setting value for aibi_dashboard_embedding_access_policy setting. This is the final effective value of setting. To set a value use aibi_dashboard_embedding_access_policy.
▶effective_aibi_dashboard_embedding_approved_domains	object	Effective setting value for aibi_dashboard_embedding_approved_domains setting. This is the final effective value of setting. To set a value use aibi_dashboard_embedding_approved_domains.
▶effective_automatic_cluster_update_workspace	object	Effective setting value for automatic_cluster_update_workspace setting. This is the final effective value of setting. To set a value use automatic_cluster_update_workspace.
▶effective_boolean_val	object	Effective setting value for boolean type setting. This is the final effective value of setting. To set a value use boolean_val.
▶effective_integer_val	object	Effective setting value for integer type setting. This is the final effective value of setting. To set a value use integer_val.
▶effective_personal_compute	object	Effective setting value for personal_compute setting. This is the final effective value of setting. To set a value use personal_compute.
▶effective_restrict_workspace_admins	object	Effective setting value for restrict_workspace_admins setting. This is the final effective value of setting. To set a value use restrict_workspace_admins.
▶effective_string_val	object	Effective setting value for string type setting. This is the final effective value of setting. To set a value use string_val.
▶integer_val	object	Setting value for integer type setting. This is the setting value set by consumers, check effective_integer_val for final setting value.
▶personal_compute	object	Setting value for personal_compute setting. This is the setting value set by consumers, check effective_personal_compute for final setting value.
▶restrict_workspace_admins	object	Setting value for restrict_workspace_admins setting. This is the setting value set by consumers, check effective_restrict_workspace_admins for final setting value.
▶string_val	object	Setting value for string type setting. This is the setting value set by consumers, check effective_string_val for final setting value.

list_account_settings_metadata

Name	Datatype	Description
name	string	Name of the setting.
description	string
docs_link	string	Link to databricks documentation for the setting
type	string	Sample message depicting the type of the setting. To set this setting, the value sent must match this type.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_public_account_setting	select	account_id, name		Get a setting value at account level. See :method:settingsv2/listaccountsettingsmetadata for list of
list_account_settings_metadata	select	account_id	page_size, page_token	List valid setting keys and metadata. These settings are available to be referenced via GET
patch_public_account_setting	update	account_id, name, setting		Patch a setting value at account level. See :method:settingsv2/listaccountsettingsmetadata for list of

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.

Name	Datatype	Description
account_id	string
name	string	:param setting: :class:Setting
page_size	integer	The maximum number of settings to return. The service may return fewer than this value. If unspecified, at most 200 settings will be returned. The maximum value is 1000; values above 1000 will be coerced to 1000.
page_token	string	A page token, received from a previous ListAccountSettingsMetadataRequest call. Provide this to retrieve the subsequent page. When paginating, all other parameters provided to ListAccountSettingsMetadataRequest must match the call that provided the page token.

SELECT examples

get_public_account_setting

Get a setting value at account level. See :method:settingsv2/listaccountsettingsmetadata for list of

SELECT
name,
aibi_dashboard_embedding_access_policy,
aibi_dashboard_embedding_approved_domains,
automatic_cluster_update_workspace,
boolean_val,
effective_aibi_dashboard_embedding_access_policy,
effective_aibi_dashboard_embedding_approved_domains,
effective_automatic_cluster_update_workspace,
effective_boolean_val,
effective_integer_val,
effective_personal_compute,
effective_restrict_workspace_admins,
effective_string_val,
integer_val,
personal_compute,
restrict_workspace_admins,
string_val
FROM databricks_account.settingsv2.account_settings
WHERE account_id = '{{ account_id }}' -- required
AND name = '{{ name }}' -- required
;

list_account_settings_metadata

List valid setting keys and metadata. These settings are available to be referenced via GET

SELECT
name,
description,
docs_link,
type
FROM databricks_account.settingsv2.account_settings
WHERE account_id = '{{ account_id }}' -- required
AND page_size = '{{ page_size }}'
AND page_token = '{{ page_token }}'
;

UPDATE examples

patch_public_account_setting

Patch a setting value at account level. See :method:settingsv2/listaccountsettingsmetadata for list of

UPDATE databricks_account.settingsv2.account_settings
SET 
setting = '{{ setting }}'
WHERE 
account_id = '{{ account_id }}' --required
AND name = '{{ name }}' --required
AND setting = '{{ setting }}' --required
RETURNING
name,
aibi_dashboard_embedding_access_policy,
aibi_dashboard_embedding_approved_domains,
automatic_cluster_update_workspace,
boolean_val,
effective_aibi_dashboard_embedding_access_policy,
effective_aibi_dashboard_embedding_approved_domains,
effective_automatic_cluster_update_workspace,
effective_boolean_val,
effective_integer_val,
effective_personal_compute,
effective_restrict_workspace_admins,
effective_string_val,
integer_val,
personal_compute,
restrict_workspace_admins,
string_val;