Hi,

I would like to deploy Databricks workspaces to build a delta lakehouse to server both scheduled jobs/processing and ad-hoc/analytical querying workloads. Databricks users comprise of both data engineers and data analysts.

In terms of requirements in addition to optimising costs, I would like to take advantage of the Premium tier's role-based access and credential passthrough, primarily to ensure our data analyst access adhere to the "principle of least privilege" aka not admins. I don't want the analysts tinkering with workspace, table and cluster objects & configurations.

On this basis, rather than a single Premium tier, is it a viable approach to setup 2x Databricks workspaces? A Standard workspace to run scheduled jobs/workflows and a Premium, more secure, workspace for the analysts to run their ad-hoc queries.

Pros

1. Scheduled jobs/workflows exclusively on the Standard SKU which is cheaper than on a Premium SKU.
2. Separate workloads delineates billing, if we want to distinguish between data engineering and data analytical workloads

Cons

1. Slightly more operational and admin overhead in setting up and managing two workspaces as opposed to a single workspace.

Thanks

Tim