Lakehouse case sesitive

[vasalari]

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 DWs are case INsinsetives but the lakehouse is case sinsetive so I lose case sinsetivity of DW2.  Shortcut in Lakehouse changes the sinsetivity of source DW2.  How Can I use DW2 in DW1 withoutout losing the case insensivity?

Appreciare any response

[v-prasare]

Hi @vasalari,
We are following up once again regarding your query. Could you please confirm whether you have raised feedback/ideas related to above ask?
If you have any update, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.
Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-prasare]

@vasalari, we checking with whether you have raised feedback/ideas related to above ask? please share here if there any update on this ask.

Thanks,

Prashanth Are

MS Fabric community support

[v-prasare]

Hi @vasalari, 

I’d encourage you to submit your detailed feedback and ideas via Microsoft's official feedback channels, such as the Microsoft Fabric Ideas.

Feedback submitted here is often reviewed by the product teams and can lead to meaningful improvemen...

thanks,

Prashanth Are

MS Fabric community support

[vasalari]

I understand lakehouse is case Sensitive and we only can create Shortcut in Lakehouse.  My question is anybody found a solution for it or MS is working to create shoetcut from Warehouse.  Fixing tens of thousand of codes and 100s of SSIS packages and taking care of all string comparison is not an easy task.

[v-prasare]

Hi @vasalari,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

Thanks,

Prashanth Are

MS Fabric community support

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

[spaceman127]

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

[vasalari]

Does anybodu know that MS is working to resolve the issue lakehousebeing upper case so it can be either case sensitive or insensitive 

[vasalari]

Thanks you Patel, 

It seems I did not explain the issue properly.  ILakehouse is case Sesitive and shortcut created in lakehouse makes the source DW case sesitive.   I do not want that.  My Source in WS2 is case Insensitive and I want to use in a DW in WS1 case INSENSITIVE 

[BhaveshPatel]

Lakehouse only supports camel case ( case insensitive )  because it uses python/scala behind the scene. This is the reason you would see such behavior. Leave it as it is. Cheers..