Forum Discussion
SQL View Duplicate in Lakehouse
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.
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!
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.
5 Replies
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.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.