Forum Discussion

KimTutein's avatar
KimTutein
Advocate III
1 year ago
Solved

Is Case-insensitivity in Lakehouse SQL endpoint possible?

Hi community

In the lakehouse sparksql per default use case-insenstitivity for sql which is fine for me (this property can be “set using spark.sql.caseSensitive = [true/false]”). However this behavior is not the same in sql-endpoint for the lakehouse - there table names are case sensitive and it seems we do not have the option to choose if we want case-insenstitivity.

 

Does anyone know a way around this – I want to have case insensitivity in sql-endpoint for object (like tables and views) as well?

Lakehouse
  • ipkus's avatar
    ipkus
    3 days ago

    This has been resolved with the new case insensitivity Workspace setting ( only applicable to new ones ). 

5 Replies

  • AndyDDC's avatar
    AndyDDC
    Most Valuable Professional
    1 year ago

    Hi KimTutein i reached out to the MS team on this.  It's currently being tested so hold on for now and there should be news coming (not sure when)

     

    MS need to get the metadata sync working between lakehouse and sql endpoint, that's the issue.

  • ipkus's avatar
    ipkus
    Frequent Visitor
    3 days ago

    This has been resolved with the new case insensitivity Workspace setting ( only applicable to new ones ). 

  • KimTutein's avatar
    KimTutein
    Advocate III
    1 year ago

    Hi AndyDDC 

    Thank you very much for you feedback - much appreciated. 

    I will hold for now and look forward to the feature 🙂

  • marcdv's avatar
    marcdv
    Frequent Visitor
    1 year ago

    AndyDDC have you heared anything new on this? The warehouse can be made case insensitive but the lakehouse not ?