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

[sarnendude]

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

[v-cboorla-msft]

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]

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]

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.