Forum Discussion
Helper IIFabric Warehouse - Case Sensitivity with Table and Column Names
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.
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 comparisonshttps://datasturdy.com/implementing-a-microsoft-fabric-data-warehouse-with-ci-collation
if this is helpful please accept the solution and give kudos
2 Replies
- nilendraFabric
Super User
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 comparisonshttps://datasturdy.com/implementing-a-microsoft-fabric-data-warehouse-with-ci-collation
if this is helpful please accept the solution and give kudos
southgrad10Thank 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!