Hi,

To understand about the Databricks SQL Serverless cost, you can see here - https://www.databricks.com/product/pricing/databricks-sql

In terms of comparison, Databricks is said to be the most cost efficient & high performant in the market amongst its competitors who provides Serverless offerings.

There is also new feature introduced to manage the cost associated with Serverless usage - Serverless budget policy

However, as you had asked the cons, here are some limitations with Serverless compute - https://docs.databricks.com/en/compute/serverless/limitations.html

In addition to this - Serverless compute plane networking products might incur data transfer costs

I hope this helps!!