Duplicate table names with different case sensitivity in data warehouse

[Don-Bot]

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

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

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

[nilendraFabric · Accepted solution]

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

[Don-Bot]

Thanks @nilendraFabric , that is an annoying issue