Forum Discussion
Solved
Unable to save SQL query as VIEW
When creating a SQL query in the Data Warehouse and using the option "Save as View" it fails without a proper error description: Error Details The view could not be created because of the follo...
Hi erkuiper - Thanks for using Fabric Community,
We have an update from internal team -
"Apologies for the inconvenience that you are experiencing. This error is due to an issue that the team is working on and we don't allow users to write when schema is set to INFORMATION_SCHEMA."
While doing repro we were able to create/save the view when schema is dbo.
We tested this and it works fine without any error for me and my team.
In your case If you still facing the issue - "Unable to save the view when schema is dbo", I would recommend to raise a support ticket so that an engineer can take a closer look at it.
Sure. See attached.Select Query and then Save as viewError thrown