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 endpoints in a workspace.

To configure all SQL endpoints using the REST API, see Global SQL Endpoints API.

Important

When you change a SQL configuration parameter, all running SQL endpoints 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 endpoints.

Configure SQL parameters

To configure all endpoints with SQL parameters:

  1. Click User Settings Icon Settings at the bottom of the sidebar and select SQL Admin Console.

  2. Click the SQL Endpoint 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 endpoints

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

  4. Click Save.