Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

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.

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!

1 ACCEPTED SOLUTION

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.

View solution in original post

5 REPLIES 5
v-nikhilan-msft
Community Support
Community Support

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.

Anonymous
Not applicable

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.

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

vnikhilanmsft_0-1700564773135.png

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

vnikhilanmsft_1-1700564826988.png

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

Anonymous
Not applicable

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

This is the frame i have when opening the LH

RF_consultant_0-1700568165824.png


After i just have this 

RF_consultant_1-1700568175630.png


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

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.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

November Update

Fabric Monthly Update - November 2024

Check out the November 2024 Fabric update to learn about new features.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.