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

Don-Bot — Fri, 14 Mar 2025 19:18:28 GMT

I am now getting a "Duplicate Table names with different case sensitivity" error in my data warehouse. However, I only see 1 table with the same name, no duplicates. And I can't rename or do anything to fix this issue. The links I've found regarding this are not helpful at all.

https://community.fabric.microsoft.com/t5/Data-Warehouse/Duplicate-table-names-with-different-case-sensitivity-in-data/m-p/3543058#M520

https://learn.microsoft.com/en-us/fabric/known-issues/known-issue-454-data-warehouse-object-explorer-unsupport-case-sensitive-names

This is telling me "PM_PRODUCTS" is a duplicate

So where is this so called duplicate? I've hidden the table names except for the first letter so you can see that there is only one products table...

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

nilendraFabric — Sat, 15 Mar 2025 20:51:57 GMT

hello Don-Bot

this is a known issue. It occurs when tables with identical names but different cases (e.g., `PM_PRODUCTS` and `pm_products`) are created. While the Object Explorer does not display both tables, the system backend recognizes them as distinct, leading to conflicts during schema refreshes or other operations.

try this query

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%products%';

https://community.fabric.microsoft.com/t5/Data-Warehouse/Duplicate-table-names-with-different-case-sensitivity-in-data/td-p/3538413

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

Don-Bot — Tue, 18 Mar 2025 21:08:04 GMT

Thanks nilendraFabric , that is an annoying issue