Forum Discussion

mstoegerer's avatar
mstoegerer
Frequent Visitor
1 month ago
Solved

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:   ...
data engineering
Lakehouse
  • v-moharafi-msft's avatar
    v-moharafi-msft
    1 month ago

    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 Learn 

    Best Regards,
     Abdul Rafi

mstoegerer's avatar
mstoegerer
Frequent Visitor
1 month ago

Hi,

 

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,
Markus

v-moharafi-msft's avatar
v-moharafi-msft
Community Support
1 month ago

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 Learn 

Best Regards,
 Abdul Rafi

  • mstoegerer's avatar
    mstoegerer
    Frequent Visitor
    1 month ago

    Hello,

     

    I wasn't able to test it more in detail in the last days.
    I'll check it with a newly created Lakehouse in the next days and come back with the results.

     

    Best regards,

    Markus

    • v-kathullac's avatar
      v-kathullac
      Community Support
      1 month ago

      Hi mstoegerer ,

       

      Thaankyou for the confirmation. Could you please test the newly created Lakehouse and let us know if you encounter any further issues?

      As of now, we will proceed with closing this thread . if you experience any issues in the future, please don't hesitate to create a new thread, and we will be happy to assist you.

      Thank you for your cooperation.

       

      Thanks,

      Chaithanya.