SERVERLESS SQL WAREHOUSE

[Punit_Prajapati]

Hello All,

I have two questions regarding the serverless SQL warehouse which are following:

1.) If I create a small Serverless SQL Warehouse in Databricks that shows 12 DBUs/hour, will I be charged 12 DBUs even if I don’t run any queries in that hour? Or does billing happen only based on actual query execution time?

2.) If I run two queries on the same Serverless SQL Warehouse, and both take the same execution time, but one query is more complex and consumes more DBUs, will both be charged equally, or will the cost differ based on actual DBU usage?

help me getting my doubts cleared.

[Shua42 · Accepted solution]

Hey there,

Happy to shed some light here. DBU's are charged based on uptime of the compute.

So for example, in question 1, if you start a small Serverless SQL Warehouse, you will only be charged for the uptime. If you leave the cluster on for 30 minutes and it's 12 DBU's/hour, since it's .5 hours you will be charged 6 DBU's for that session. 

Related to question 2, since the DBU's are based on uptime, running more queries will not increase the amount of DBU's charged, unless you have scaling enabled. The queries may just take longer to run, but it will incur the same charge. If you do have scaling on and you're running a lot of complex queries, it may scale up, and that is determined based on how you configured the warehouse.

Hope this helps clarify things.

[Punit_Prajapati]

Thank you so much @Shua42  for clarifying.

[BigRoux · Accepted solution]

Shua42 hits the nail on the head.

If I can be so bold as to summarize:

You are only charged when the Warehouse is running regardless of how much or how little you use it.  We do have an auto stop feature you can configure. Essentially, you set a timeout and if nothing happens on the Warehouse in that time period (nobody runs queries) it will automatically shut down. It is a cost saving feature.  Cheers, Lou.