Forum Discussion

DKIDV's avatar
DKIDV
Frequent Visitor
9 months ago
Solved

Fabric SQL Database SQL endpoint is not refreshing (metadata sync lag)

I dont see all my tables created in Fabric SQL Databases in the underlying SQL Analytics Endpoints (automatically created with fabric sqldb). I have several schema's with the same tables. E.g. In ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 months ago

    Hi DKIDV,

     

    Table count exceeds limit is the cause. It is not just a UI message. May be The issue is not caused by permissions or refresh problems the main reason your tables are missing in the SQL Analytics Endpoint is because your database has hit the internal table count limit. Once this limit is reached, the SQL Analytics Endpoint simply stops registering new tables, even though replication still shows as “Running” and the tables exist in the SQL Database. This is why older schemas appear while newer ones don’t, even when the tables are identical. The refreshMetadata API and small table changes won’t fix it because the endpoint is no longer accepting new metadata. The only real solutions are to reduce the number of tables in the database (drop unused or duplicate tables) or split your data across multiple databases using Fabric Pipelines to move data between them. This avoids the limit and ensures all tables become visible and sharable again.

     

    Thanks & Regards,

    Prasanna Kumar

Anonymous's avatar
Anonymous
Not applicable
9 months ago

HI DKIDV,

 

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to MFelix and Nasif_Azam  for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar