Forum Discussion

jyotip's avatar
jyotip
Frequent Visitor
1 year ago
Solved

Discrepancy in Table Visibility Between SQL Database and SQL Analytics Endpoint

Hello everyone, I've encountered an issue in SQL Database Fabric where some tables I created and loaded in the SQL database are missing when I try to view them in the SQL analytics endpoint. In the ...
Need Help
  • v-veshwara-msft's avatar
    v-veshwara-msft
    1 year ago

    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.

     

     

v-veshwara-msft's avatar
v-veshwara-msft
Community Support
1 year ago

Hi jyotip ,

We haven’t heard from you since our last response and just wanted to check whether the solutions provided addressed your needs. If they did, we’d appreciate it if you could mark the response as the solution to help others benefit from it.

If the issue persists or you need further assistance, please don’t hesitate to reach out. We’re here to help!

Thank you.

jyotip's avatar
jyotip
Frequent Visitor
1 year ago

Hi v-veshwara-msft,

Thank you for the inputs you have provided. The below two points doesnt apply to my case.But third might be the reason why the tables are not fully created. Still it doesnt solve my problem.I have raised ticket with microsft to get my issue addressed.

 

Thanks,

Jyotip

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support
    1 year ago

    Hi jyotip ,
    Thanks for getting back.

    Since the first two points don’t apply and the third could be a possible reason, raising a support ticket with Microsoft is the best course of action.

    Please do share any insights or solutions you receive from Microsoft, it could help others facing a similar issue.

    Thank you.