Forum Discussion

JDay98's avatar
JDay98
Frequent Visitor
7 months ago
Solved

Lakehouse Table Mapping Unidentified

I have a lakehouse that mirrors my production lakehouse. I have had no issue with the tables in the past but just this last week I received an error on my mirrored lakehouse: "Unable to identify thes...
  • deborshi_nag's avatar
    7 months ago

    Hello JDay98 

     

    The issue with schema shortcuts is typically caused by:

     

    • A corrupted or partially synchronised schema metadata file
    • Modifications to the underlying Delta transaction log at the source
    • Desynchronisation of shortcuts following schema evolution
    • Inconsistent metadata within the mirrored lakehouse

    Before addressing your mirrored lakehouse, please ensure the source is in good health.

    Within your production lakehouse, confirm that /Tables exists and contains the *_delta_log:

     

    Fabric shortcuts may have become outdated.

    To refresh:

    1. Select the relevant schema shortcut
    2. Click Refresh

    If the refresh is unsuccessful, it is likely due to metadata corruption in either the shortcut or the source.

     

    From the mirrored lakehouse:

    1. Go to SQL Endpoint → Refresh
    2. Navigate to Tables view → Refresh
    3. If the problematic table displays a warning, select “Remove from SQL endpoint”

    This action removes only the metadata and does not affect the actual data.