topic Re: SQL View Duplicate in Lakehouse in Pipelines

SQL View Duplicate in Lakehouse

Anonymous — Tue, 21 Nov 2023 10:19:16 GMT

I'm currently trying to utilize the different SQL views that can be created in my lakehouse. However when i started to create my views i can now no longer access the SQL endpoint of my lakehouse, since im getting this error.
Duplicate object name, [VIEW_NAME] of type 'View'. Case-sensitive names are not supported.

Please try again later or contact support. If you contact support, please provide these details.

Since i can not access the SQL Endpoint,
"We couldn't load your SQL analytics endpoint metadata, but you can still query it"
Im having issues troubleshooting this. Thanks!

Re: SQL View Duplicate in Lakehouse

Anonymous — Tue, 21 Nov 2023 10:42:43 GMT

Hi Anonymous
Thanks for using Fabric Community.
When I tried to create views with names like view2 and View2 I got the same error as mentioned above. This error means that you are trying to create a view with the same name as an existing object, and the lakehouse does not allow case-sensitive names for objects. When you create a view, you need to make sure that the view name is unique and does not conflict with any existing table or view name in your lakehouse.

To fix this error just rerun the SQL code by changing the view name. Give a unique name and try running the code.

Hope this helps. Please let me know if you have any further issues.

Re: SQL View Duplicate in Lakehouse

Anonymous — Tue, 21 Nov 2023 10:50:38 GMT

No I totally understand that, but at this point it seems it has already created these two views, im getting this error once i open the SQL endpoint. So to reiterate im really not trying to create an additonal view with the same name im meerely trying to access the SQL endpoint.

To be even more clear I've even tried deleting the view with the name, but its not working. So I'm quite at a stand still since i cant access my SQL endpoint and i cant adjust the different views that I've created.

Re: SQL View Duplicate in Lakehouse

Anonymous — Tue, 21 Nov 2023 11:08:45 GMT

Hi Anonymous
Thanks for the explaination.
Try to drop all the views which have case-sensitive names.

Make sure you have views with unique names in the SQL endpoint.

Restart the SQL endpoint.This will resolve the issue.
Hope this helps. Please let me know if you have any further issues.

Re: SQL View Duplicate in Lakehouse

Anonymous — Tue, 21 Nov 2023 12:03:43 GMT

Ive already runned drop view [dbo].[view_name]

This is the frame i have when opening the LH

After i just have this

I.e. I cant access it, so i cant really perform the operation youre asking.
However how do i restrat the sql endpoint?

Re: SQL View Duplicate in Lakehouse

Anonymous — Tue, 21 Nov 2023 12:35:55 GMT

Hi Anonymous

Apologies for the issue you have been facing.

This might require a deeper investigation from our engineering team about your workspace, the Lakehouse details and the logic behind it to properly understand what might be happening.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support
Please provide the ticket number here as we can keep an eye on it.

Thank you.