Forum Discussion

Jher12's avatar
Jher12
Frequent Visitor
10 months ago
Solved

Mismatch Between Table Name Case in Lakehouse Explorer and SQL Analytics Endpoint

Why does the Lakehouse Explorer display table names in all lowercase, while the SQL Analytics Endpoint Explorer shows them in the intended letter case? Whenever I create notebooks that use the spark.catalog function, the table names are returned in lowercase instead of their original mixed-case format. How can I fix this? Any assistance would be greatly appreciated. Thank you in advance.

workspaces
  • suparnababu8's avatar
    suparnababu8
    10 months ago

    Hello Jher12 

     

    I replicated your scenario, I'm also gettign the same.  It's due to Spark internally normalizes the tables names to lower case unless you used it in quotes explcitly. Bcz spark handles the table identifers internally. I would recommend you to create the tables with quotes and later  you can use Spark SQL to run the table. 

     

    I believe this behaviour  not only in Microsoft Fabric, it's across all the spark enviuronments.

     

    Please let me know if it helps you.

     

    Thank you!!

     

    Did I answer your question? Mark my post as a solution!

    Proud to be a Super User!

7 Replies

  • suparnababu8's avatar
    suparnababu8
    Icon for Super User rankSuper User
    10 months ago

    Hello Jher12 

     

    I replicated your scenario, I'm also gettign the same.  It's due to Spark internally normalizes the tables names to lower case unless you used it in quotes explcitly. Bcz spark handles the table identifers internally. I would recommend you to create the tables with quotes and later  you can use Spark SQL to run the table. 

     

    I believe this behaviour  not only in Microsoft Fabric, it's across all the spark enviuronments.

     

    Please let me know if it helps you.

     

    Thank you!!

     

    Did I answer your question? Mark my post as a solution!

    Proud to be a Super User!

    • Jher12's avatar
      Jher12
      Frequent Visitor
      10 months ago

      Hi, 
      Thank you for the response. Is there any way to rename the tables without dropping and recreating them with quotes?

      • suparnababu8's avatar
        suparnababu8
        Icon for Super User rankSuper User
        10 months ago

        I don't think there is chance!! But, don;t drop your existing table create dummy table and try it once. 

         

        Thank you!!

         

        Did I answer your question? Mark my post as a solution!

        Proud to be a Super User!

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Icon for Community Support rankCommunity Support
    9 months ago

    Hi Jher12,

    Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to suparnababu8, for his inputs on this thread.

    Has your issue been resolved? If the response provided by the community member suparnababu8, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

    Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

    Thank you for using the Microsoft Community Forum.