Enable serverless SQL warehouses

This article explains how to enable serverless SQL warehouses for your workspace.

Note

Serverless SQL warehouses do not have public IP addresses. For more architectural information, see Databricks architecture overview.

Requirements

• Your Databricks account must not be on a free trial.

• Your Databricks workspace must be on the Premium plan.

• Your workspace must be in a region that supports Databricks SQL Serverless. See Databricks clouds and regions.

• Your workspace must have Unity Catalog enabled. See Set up and manage Unity Catalog.

• Your workspace must not use an external Hive legacy metastore. See Remove Hive metastore credentials to enable serverless.

Enable serverless compute in your account

Note

If your account was created after March 28, 2022, serverless compute is enabled by default for your workspaces.

1. Go to the feature enablement tab of the account console settings page.

2. A banner at the top of the page prompts you to accept the additional terms. Once you read the terms, click Accept. If you do not see the banner asking you to accept the terms, this step has already been completed.

3. Go to the settings page.

4. Select Compute.

5. Click Manage next to SQL warehouses.

6. Turn on Serverless SQL warehouses (On).

Remove Hive metastore credentials to enable serverless

You cannot deploy serverless SQL warehouses if Hive metastore credentials are defined at the workspace level. To remove legacy Hive metastore credentials:

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

2. Click the Compute tab.

3. Click Manage next to SQL warehouses.

4. In the Data Access Configuration field, locate and delete the Hive metastore credentials.

5. Click Save changes.

Monitor usage with tags

Like any other compute resource in Databricks, you can apply tags to serverless SQL warehouses to monitor usage and cost. You can view usage in the account console or access downloadable logs. See Monitor usage in the account console.

Limitations

Serverless warehouses have the following limitations:

• Cluster policies, including spot instance policies are unsupported. See Create and manage compute policies.

• External Hive legacy metastores are not supported. See External Apache Hive metastore (legacy).