1. Just to clarify, minimum is 1, not 0. See https://docs.databricks.com/api/workspace/warehouses/create#min_num_clusters
2. How it works is based on concurrency. Assuming your max clusters is 2, and based on the concurrency, we don't need the 2nd cl...
You can file an Azure ticket and request them to contact Databricks Support, who will contact Databricks Engineering, to change that 'workspace owner'.
If you have a Databricks Account Team, they can also file an internal ticket to Databricks Enginee...
USE is foundational. You need it at the catalog level and for any schema you want to access.
So let's say I need SELECT only on 1 table T1 in Catalog:C1, Schema:S1 (Though there may be 1K tables in that schema)
Then I would need
USE CATALOG on C1;USE...
Databricks SQL is the Product Name. https://www.databricks.com/product/databricks-sql
Spark SQL is the SQL interface (SQL commands) that run by utilizing the power of Spark as a computing engine.https://www.databricks.com/glossary/what-is-spark-sql
...
Unfortunately we do not support that.
We only support Global and Session level settings.
We have an internal feature request for this (DB-I-6556 ) but it has not been prioritized in the Roadmap.