Lakehouse SQL Endpoint (db) Collation

[koltonist]

Is it possible to make the whole SQL db made from Lakehouse to be case-insensitive?
I know that it works on field basis when running the query - 

WHERE Company = 'myCompanY'COLLATE Latin1_General_100_CI_AS_KS_WS_SC_UTF8,

Though I'd like to turn such type of collaction for whole db.

[suparnababu8 · Accepted solution]

Hi @koltonist 

Unfortunately, it's not possible to make case insensitive collation for the whole sql db created from lakehosue. The SQL endpoint of Fabric lakehouse, the default is case-sensitive. as said by you collation works for  specific fields in quries. 

If you want to set case insensitive for entire databases, it could be done with Fabric warehouses. Can you please go thorugh this thread How To: Create Warehouses with Case-Insensitive (CI) Collation - Microsoft Fabric | Microsoft Learn it might helps you.

Thank you!!

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

Proud to be a Super User!