Forum Discussion

vasalari's avatar
vasalari
Icon for Helper I rankHelper I
1 year ago

Lakehouse case sesitive

I have two data warehouses in two different workspaces. Using a shortcut I use DW2 in  DW1. The shortcut is created in a lakehouse. Things are working and I can access tables from DW2 in  DW1. Both D...
data warehouse
spaceman127's avatar
spaceman127
Icon for Super User rankSuper User
1 year ago

Hello vasalari,

Fabric Lakehouse not support case Insensitive.

Maybe you can adjust your logic a little and use a Fabric Warehouse. Fabric supports case Insensitive.

 

This is not possible in the standard Gui, but you can use the Fabric API to create the warehouse in Case Insensitive.

Maybe this will help you.

Here an Example:

 

URL : https://api.fabric.microsoft.com/v1/workspaces/#WORKSPACEID#/items

 

{ 
   "type": "Warehouse", 
   "displayName": "ciwarehouse", 
   "description": "Thats a cool Warehouse with CI", 
   "creationPayload": { 
     "defaultCollation": "Latin1_General_100_CI_AS_KS_WS_SC_UTF8" 
   } 
 }

 

Best regards

spaceman127