Forum Discussion
Brackets in tablenames
Hi everyone,
We have since a few days the problem, that tables are not created correctly at the Lakehouse if the name includes brackets or spaces.
It has always worked until recently:
But now the tables are not visible in the table list of the Lakehouse. The table is only listed as "Unidentified"
Is this a temporary bug or were some changes at the Lakehouse metadata operations?
Hi mstoegerer ,
Thank you for the additional details.
Based on your testing, the tables are being created successfully as Delta tables because they remain accessible through both Spark notebooks and the SQL analytics endpoint. However, when brackets or spaces are included in the table name, Lakehouse Explorer classifies them under Unidentified instead of displaying them in the Tables section.
According to the Lakehouse Explorer documentation, the Unidentified area is used for items that Fabric cannot properly recognize as valid tables. I could not find anything in the Lakehouse Explorer documentation that specifically states brackets or spaces should cause Delta tables to appear under Unidentified
Since this previously worked and the issue appears reproducible only for tables containing brackets or spaces, this may indicate a recent metadata recognition or UI regression in Lakehouse Explorer.Could you also confirm whether the issue occurs in a newly created Lakehouse and whether both existing and newly created bracketed table names are affected?
For Reference: Navigate the Fabric Lakehouse explorer - Microsoft Fabric | Microsoft LearnBest Regards,
Abdul Rafi
8 Replies
Hi mstoegerer - Avoiding special characters (especially brackets () and spaces) in new table names until Microsoft confirms whether this is a known issue.
recommend opening a Microsoft Fabric Support ticket or reporting it through the Fabric Community so the product team can investigate whether a recent deployment introduced a metadata/UI regression.
Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn
Hope this helps.
Hi mstoegerer ,
Thank you for reaching out to Microsoft Fabric Community and thanks to rajendraongole1 for sharing meaningful insights.
According to the Microsoft documentation, the Unidentified section in Lakehouse Explorer is used for items that Fabric cannot recognize as valid Delta tables, such as broken shortcuts, non-Delta content written to the Tables area, or folders that do not follow the expected Delta table structure
Could you please confirm:- Whether these tables were created through the Lakehouse UI, Notebook, Data Pipeline, or another method?
- If newly created tables with simple names (without spaces or brackets) appear correctly?
- Whether the issue affects all tables or only specific ones?
- If you can access the tables through Spark notebooks or the SQL analytics endpoint?
The documentation does not indicate that spaces or brackets in table names should cause tables to appear under Unidentified, so gathering the above details will help narrow down whether this is related to table metadata, table creation method, or another issue.
For Reference:
Navigate the Fabric Lakehouse explorer - Microsoft Fabric | Microsoft Learn
Best Regards,
Abdul RafiHi,
Thanks for you reply.
The tables were created in a notebook with following code:
df_fixed .write .format("delta") .mode("overwrite") .option("mergeSchema", "true") .saveAsTable(table_name)That worked until recently quite well.
If I create a table with this code, without brackets, the table appears correctly under tables.
I can access the "unidentified" tables with spark and the SQL endpoint.
Best regards,
MarkusHi mstoegerer ,
Thank you for the additional details.
Based on your testing, the tables are being created successfully as Delta tables because they remain accessible through both Spark notebooks and the SQL analytics endpoint. However, when brackets or spaces are included in the table name, Lakehouse Explorer classifies them under Unidentified instead of displaying them in the Tables section.
According to the Lakehouse Explorer documentation, the Unidentified area is used for items that Fabric cannot properly recognize as valid tables. I could not find anything in the Lakehouse Explorer documentation that specifically states brackets or spaces should cause Delta tables to appear under Unidentified
Since this previously worked and the issue appears reproducible only for tables containing brackets or spaces, this may indicate a recent metadata recognition or UI regression in Lakehouse Explorer.Could you also confirm whether the issue occurs in a newly created Lakehouse and whether both existing and newly created bracketed table names are affected?
For Reference: Navigate the Fabric Lakehouse explorer - Microsoft Fabric | Microsoft LearnBest Regards,
Abdul Rafi
Hi mstoegerer ,
Thank you for reaching out to Microsoft Fabric Community and thanks to rajendraongole1 for providing meaningful insights
Just wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.Best Regards,
Hi @mstoegerer ,
Thank you for reaching out to Microsoft Fabric Community and thanks to @rajendraongole1 for providing meaningful insights
Just wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.Best Regards,
