Forum Discussion

sarnendude's avatar
sarnendude
Frequent Visitor
2 years ago

We couldn't get your SQL analytics endpoint's updated schema

Hi All,

 

I am not able to access tables using Lakehouse SQL endpoint & getting below messge while refreshing the SQL endpoint:

"We couldn't get your SQL analytics endpoint's updated schema."

When trying to access individual table, getting "Invalid object name" error.

Earlier all tables were acceesible via SQL endpoint, but today this is not working even no schema changes happend recently.

 

Can you please help? did anyone face similar issue and resolved?

 

Thanks,

Sarnendu De

data warehouse

3 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi sarnendude 

     

    Thanks for using Microsoft Fabric Community.
    Apologies for the issue you have been facing.

    This might be an intermittent issue, It can take some time for the schema to refresh. So wait for sometime and then try to refresh the SQL endpoint. This will solve the issue.

    Please refer to a simular thread in Fabric community, this might help you : Default dataset for Lakehouse not refreshing 
    If you are still facing the issue. Please reach out to our support team so they can do a more thorough investigation on why this it is happening. Our support engineers will definitely would understand the route cause and properly address it.

    Please go ahead and raise a support ticket to reach our support team:

    https://support.fabric.microsoft.com/support

    After creating a Support ticket please provide the ticket number as it would help us to track for more information.

     

    Thanks.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      2 years ago

      Hi sarnendude 

       

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
      In case if you have any resolution please do share that same with the community as it can be helpful to others.
      Otherwise, will respond back with the more details and we will try to help.


      Thanks.

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        2 years ago

        Hi sarnendude 

         

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
        If you have any question relating to the current thread, please do let us know and we will try out best to help you.
        In case if you have any other question on a different issue, we request you to open a new thread.


        Thanks.