topic Re: Duplicate table names with different case sensitivity in data warehouse in Data Warehouse

Duplicate table names with different case sensitivity in data warehouse

Jotheesh — Fri, 17 Nov 2023 04:18:04 GMT

Hi
Data Warehouse let's me create two tabls with same name but with different case but then gives me error while refeshing teh schema.

I have created tables

[dbo].[Table_a] and

[dbo].[TABLE_A] and agen I try to refesh tables in side pane , it gives me below error

If we are not supposed to create two tables with same name, should't it be restrcited while attempting to create?

Re: Duplicate table names with different case sensitivity in data warehouse

Anonymous — Fri, 17 Nov 2023 06:36:22 GMT

Hi Jotheesh ,
Thanks for the ask and using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Appreciate your patience.
Thanks

Re: Duplicate table names with different case sensitivity in data warehouse

AndyDDC — Fri, 17 Nov 2023 11:30:20 GMT

Yes it's annoying at the moment that we can't choose a collation. I have an Idea here to upvote https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=8b35ca62-1117-ee11-a81c-000d3a01b048

Re: Duplicate table names with different case sensitivity in data warehouse

Anonymous — Mon, 20 Nov 2023 18:30:23 GMT

Hi Jotheesh AndyDDC
Apologies for the issue you have been facing. This is a known issue. The object explorer fails to display the Fabric Data Warehouse objects (ex. tables, views, etc.) when have same noncase sensitive names. The internal team is working to fix this. Appreciate your patience.
Please refer to this link for more information: Link1

Hope this helps. Please let us know if you have any further issues.

Re: Duplicate table names with different case sensitivity in data warehouse

Jotheesh — Mon, 20 Nov 2023 23:04:09 GMT

thanks for the update Anonymous

Re: Duplicate table names with different case sensitivity in data warehouse

Don-Bot — Fri, 14 Mar 2025 19:11:35 GMT

hi Anonymous a known issue I am running into almost 2 years later...

Re: Duplicate table names with different case sensitivity in data warehouse

Amirul0000 — Mon, 20 Apr 2026 11:00:35 GMT

Is this known issue still ongoing? i am facing the same issue. also i do not see this listed in the known issues.