@Apurva Tiwari - Thanks for the question and using MS Q&A platform.
Azure Databricks provides a feature called "Workspace ACLs" that can help you achieve departmental secrecy in a single existing Databricks resource. With Workspace ACLs, you can control access to workspaces and folders within a workspace. You can create access control lists (ACLs) for users, groups, and service principals, and assign them to workspaces and folders.
However, it is not possible to add multiple workspaces to a single Databricks resource. An Azure Databricks account can include multiple workspaces, but each workspace requires its own Databricks resource.
Unity Catalog provides centralized access control, auditing, lineage, and data discovery capabilities across Azure Databricks workspaces.
Regarding the cost, the pricing for Azure Databricks is based on the type of instance you choose and the amount of time you use it. You can find more information about pricing on the Azure Databricks pricing page.
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.