Databricks SQL administration

The articles in this section are for administrators who want to configure and manage Databricks SQL for their workspace users. Some admin tasks are done in the Databricks SQL admin console and SQL editor, while others are performed in the workspace admin console.

All tasks require you to be a Databricks workspace admin.

Enable and create SQL warehouses

A SQL warehouse is a compute resource that lets you run SQL commands on data objects within Databricks SQL. As an admin, you will need to configure SQL warehouses for your workspace.

Locate the Databricks SQL admin settings

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

General settings

The Databricks SQL admin console includes a tab for General 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. See Workspace colors.