warehouse_config

Operations on a warehouse_config resource.

Overview

Name	warehouse_config
Type	Resource
Id	databricks_workspace.dbsql.warehouse_config

Fields

Name	Datatype
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

Name	Accessible by	Required 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.

SELECT examples

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 }}';

REPLACE example

Replaces a warehouse_config resource.

/*+ update */
-- replace field1, field2, etc. with the fields you want to update
REPLACE databricks_workspace.dbsql.warehouse_config
SET field1 = '{ value1 }',
field2 = '{ value2 }', ...
WHERE deployment_name = '{{ deployment_name }}';