Fabric Warehouse - Case Sensitivity with Table and Column Names

[southgrad10]

Hello,

I have been working in Fabric on a Trial and I am very impressed with how far it has come along since this time last year.

I have found that everything is case-sensitive.  I can imagine that this is designed to make it faster, but I am wonder if some users are changing their database settings to get around dealing with the casing.  Sometimes it can be quite annoying.

I would appreciate any insight as to whether I should make my environment case-insensitive.

[nilendraFabric · Accepted solution]

Hello @southgrad10 

By default, Microsoft Fabric warehouses are created with the case-sensitive collation Latin1_General_100_BIN2_UTF8, which applies to all object names and string comparisons within the warehouse. If you prefer a case-insensitive collation to avoid issues such as duplicate object names or mismatched joins due to differing letter cases, you can create a new warehouse with the case-insensitive collation Latin1_General_100_CI_AS_KS_WS_SC_UTF8.
However, this change cannot be applied to an existing warehouse. Instead, you must create a new warehouse using the REST API. When creating the new warehouse, you include the parameter `"defaultCollation": "Latin1_General_100_CI_AS_KS_WS_SC_UTF8"` in the payload to specify the case-insensitive collation. This ensures that upper- and lower-case letters are treated as equivalent for both object names and data comparisons

https://datasturdy.com/implementing-a-microsoft-fabric-data-warehouse-with-ci-collation

if this is helpful please accept the solution and give kudos

[southgrad10]

Thank you for the quick reply, @nilendraFabric!  I am planning to build a new warehouse and I will apply this technique and give it a try.  I appreciate your help!