Databricks SQL administration

  • Article

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 SQL editor, while others are performed in the workspace admin settings.

All tasks require you to be an Azure Databricks workspace admin.

Note

Databricks SQL Pro and Serverless are not available in Azure China. Databricks SQL is not available in Azure Government regions.

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.

Configure data access

Depending on your workspace setup, you might need to configure specific data access settings for your Databricks SQL users. For more information, see Enable data access configuration.

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. See Workspace colors.