Saw this LinkedIn post today. This sounds like a great idea on the surface and seems like what most cloud warehouses do. But it is very concerning the amount of risk, overhead, and even cost in step 6 and the blue box under it where we have to copy/duplicate/recreate all the security, procedures, functions, etc. Snowflake, Big Query, Databricks none of them make you run extra jobs to sync your scale out warehouses security and objects. They all operate on a single copy of data, objects, and permissions and allow you to spin up dynamic warehouses on that data, objects, and permissions. Store once, create once, secure once with as many warehouses on top as you like.
Is this really a pattern we should be adopting? When will Fabric SQL Endpoints “just work” with a single copy of data, objects, security, etc.?