Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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, sin...
General Comment
General Question
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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?