Discrepancy in Table Visibility Between SQL Database and SQL Analytics Endpoint

Hi jyotip ,
Thanks for posting in Microsoft Fabric Community,

1.The issue could be due to a synchronization lag between the SQL Database and the SQL Analytics Endpoint. Newly created or updated tables may take some time to appear in the analytics endpoint.
2. A schema mismatch might also be the cause. You may need to update the schema of your tables or address any inconsistencies to ensure all tables are correctly reflected in the INFORMATION_SCHEMA.TABLES.
3. If the initial table loads were delayed due to resource limitations, some tables might not have been successfully created. This could result in the tables existing in the SQL Database but not being fully formed or accessible.
Please refer this link for limitations in sql analytics endpoint:
limitations-of-the-sql-analytics-endpoint 

If none of the above reasons apply or resolve the issue, please raise a support ticket with Microsoft  for further investigation.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards.