warehouse_config

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

Overview

Name	warehouse_config
Type	Resource
Id	databricks_workspace.dbsql.warehouse_config

Fields

The following fields are returned by SELECT queries:

getworkspacewarehouseconfig

Name	Datatype	Description
channel	object
config_param	object
data_access_config	array
enabled_warehouse_types	array
global_param	object
google_service_account	string
instance_profile_arn	string
security_policy	string
sql_configuration_parameters	object

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
getworkspacewarehouseconfig	select	deployment_name		Gets the workspace level configuration that is shared by all SQL warehouses in a workspace.
setworkspacewarehouseconfig	replace	deployment_name		Sets the workspace level configuration that is shared by all SQL warehouses in a workspace.

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
deployment_name	string	The Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)

SELECT examples

getworkspacewarehouseconfig

Gets the workspace level configuration that is shared by all SQL warehouses in a workspace.

SELECT
channel,
config_param,
data_access_config,
enabled_warehouse_types,
global_param,
google_service_account,
instance_profile_arn,
security_policy,
sql_configuration_parameters
FROM databricks_workspace.dbsql.warehouse_config
WHERE deployment_name = '{{ deployment_name }}' -- required;

REPLACE examples

setworkspacewarehouseconfig

Sets the workspace level configuration that is shared by all SQL warehouses in a workspace.

REPLACE databricks_workspace.dbsql.warehouse_config
SET 
data__security_policy = '{{ security_policy }}',
data__instance_profile_arn = '{{ instance_profile_arn }}',
data__google_service_account = '{{ google_service_account }}',
data__data_access_config = '{{ data_access_config }}',
data__channel = '{{ channel }}',
data__global_param = '{{ global_param }}',
data__config_param = '{{ config_param }}',
data__sql_configuration_parameters = '{{ sql_configuration_parameters }}',
data__enabled_warehouse_types = '{{ enabled_warehouse_types }}'
WHERE 
deployment_name = '{{ deployment_name }}' --required;