SQL configuration parameters

This article describes how a Databricks administrator can use the web UI to configure SQL configuration parameters that automatically apply to all SQL warehouses in a workspace.

To configure all SQL warehouses using the REST API, see SQL Warehouses API.

Important

When you change a SQL configuration parameter, all running SQL warehouses are automatically restarted.

For a general overview of the available SQL configuration parameters, see Configuration parameters.

Requirements

You must be a Databricks administrator to configure settings for all SQL warehouses.

Configure SQL parameters

To configure all warehouses with SQL parameters:

  1. Click your username in the top bar of the workspace and select Admin Settings from the drop down.

  2. Click the SQL Warehouse Settings tab.

  3. In the SQL Configuration Parameters textbox, specify one key-value pair per line. Separate the name of the parameter from its value using a space. For example, to enable ANSI_MODE:

    Screenshot that shows ANSI_MODE set to true for all SQL warehouses

    For a list of all parameters that are supported at the global scope, see Configuration parameters.

  4. Click Save.