topic Re: Unable to save SQL query as VIEW in Data Warehouse

Unable to save SQL query as VIEW

erkuiper — Fri, 06 Oct 2023 10:05:43 GMT

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 following error.

Error Code

InternalError

Message

An internal error occurred.

Re: Unable to save SQL query as VIEW

Anonymous — Fri, 06 Oct 2023 13:34:02 GMT

Hi erkuiper - Thanks for using Fabric Community.

Can you please share some screenshots of your issue, so I can help you better.

Re: Unable to save SQL query as VIEW

erkuiper — Mon, 09 Oct 2023 08:12:13 GMT

Sure. See attached.

Re: Unable to save SQL query as VIEW

Anonymous — Mon, 09 Oct 2023 12:05:45 GMT

Hi erkuiper

Thanks for using Fabric Community and reporting this .

I have reached the internal team for help on this. I will update you once I hear from them.

Appreciate your patience.

In mean while you can create your view by following below steps -

While creating View please ensure you select dbo.

View will be created successfully.

Please do a refresh View, inorder to list our your newly created view.

Hope this is helpful. Please feel free incase of any queries.

Re: Unable to save SQL query as VIEW

erkuiper — Mon, 09 Oct 2023 13:02:30 GMT

Thank you for your reply.

I can confirm that saving the view to dbo does give me the same error.

Moreover, it doesn't matter what schema I select, it just won't save the query as view.

When creating the same view in a SQL Query using T-SQL, it does work.

Re: Unable to save SQL query as VIEW

Anonymous — Mon, 09 Oct 2023 14:04:45 GMT

erkuiper - Thanks for your response.

I will also address this issue with internal team.

I will update you once I hear from them.

Appreciate your patience.

Re: Unable to save SQL query as VIEW

Anonymous — Tue, 17 Oct 2023 10:49:27 GMT

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.

https://support.fabric.microsoft.com/support