Manage Databricks SQL settings

As a workspace admin, you can manage various settings related to Databricks SQL. This article provides you with an overview of available settings.

Locate the Databricks SQL admin settings

The Databricks SQL admin settings can be found in the admin settings. There you will find a tab for SQL settings, as well as notification destinations and SQL warehouse settings.

SQL settings

The admin settings page includes a tab for SQL Settings. These settings control the Databricks SQL presentation and behavior for all Databricks SQL users in your organization. These settings include:

  • Date & Time Format: The default date and time formats in query visualizations. To change date and time formats for an individual query visualization, see Common data types.

  • Visualization: Whether to display the Plotly toolbar in chart visualizations.

  • Download: Whether to allow users to download query results.

  • Dashboard subscriptions: Enable users to subscribe to dashboards in the workspace.

  • Failure emails: Decide which owners are emailed when refresh schedules fail.

  • Language: Whether to enable multi-byte (Chinese, Japanese, and Korean) search for query names and descriptions. When enabled, searches are slower.

  • SAML Token Expiry Warning: Whether to prompt the user to log in again if you use SAML authentication and their SAML token will expire within a few minutes. This helps to prevent disruption when running queries or refreshing dashboards if you require a SAML token to run queries. You can disable this option if you do not require SAML tokens to run queries.

  • Workspace Colors: Create a custom color palette for visualizations in dashboards. All workspace users can optionally import this custom palette for an individual dashboard.