Lakehouse case sesitive

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..

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 

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

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

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.

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.

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 improvement.

thanks,

Prashanth Are

MS Fabric community support

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

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.