u/Tomfoster1

Our warehouse is now failing to deploy where previously it ran with no issues, it seems something has changed in how the deployment process works. Trying to work backwards from the error message (incorrect syntax near identity insert) it seems like fabric is creating a temp table then trying to do identity insert which is not supported in fabric.

So the deployment pipeline doesn't know the limitations of warehouse?

Is anyone else having this issue

reddit.com
u/Tomfoster1 — 15 days ago