Mirror (or Clone) your Fabric Lakehouse and SQL Analytics Endpoint

Have you ever been in this scenario?

• Your Lakehouse is under load?
• Your SQL Endpoint is underload?
• You want to give a user access to the data, but dont want them in your workspace?
• Want to have a completely different set of permissions for the user?
• You just want to Clone a Lakehouse + SQL analytics endpoint.

[embed]

You can do this today using shortcuts and a bit of SQL — but I’ve put a demo together of doing it via a nice GUI.

So this isnt rocket science or anything new, but there are a couple of interesting things I had to put in.

• I had to use table shortcuts for things in the DBO schema
• Schema shortcuts work on the rest of the schemas.
• I call MD Sync after the shortcuts are created to make sure the SQL Analytics Endpoint is updated.
• Then there is some simple code to copy the SQL views and Procs from the source SQL analytics endpoint to the destination SQL analytics endpoint. (I have not moved the security, but that would not be too hard)

TODO: I’ve not build any scheduling !! Thats for you!! TODO: I’ve not fully tested what happens if you run 2 or 3 tables on the same lakehouse. (I will fix that)