Databricks serverless SQL cost-effective.. when?

[jar]

Hey.

I read at one-point that there would be a cheaper, less-performant version of the Databricks serverless SQL DW but can't find any information on this. Was I dreaming or will it soon be possible with a more cost-effective option for less-intensive workloads?

[szymon_dybczak · Accepted solution]

Hi @jar ,

It’s possible you’re referring to the performance mode for serverless compute. However, at the moment it doesn’t apply to DB SQL Warehouse:

1. The first mode, which is in General Availability, is called performance-optimized mode. This mode is designed for when you need compute to spin up quickly and to auto-scale aggressively. This compute costs more, especially if your job is under 10 minutes.

2. Just recently, last week, we have introduced a new mode called standard mode. This mode is designed for scheduled jobs where you are willing to trade off launch latency and auto-scaling aggressiveness for lower cost.

Serverless compute release notes | Databricks Documentation

[jar]

Hello @szymon_dybczak.

Thank you for clarifying. The most cost-effective serverless SQL option for PBI Direct Query is then the 2x-small serverless DW - the different performance modes only applies to notebooks and jobs?

[szymon_dybczak]

Hi @jar ,

That's correct. For now it only applies to notebooks and jobs 🙂