topic Re: Tables created in lakehouse are NOT visible to SQL endpoint in Data Engineering

Tables created in lakehouse are NOT visible to SQL endpoint

sdfabric — Mon, 15 Apr 2024 10:30:44 GMT

Tables created in lakehouse (in my case via Spark Notebook) are NOT visible to SQL endpoint. Please suggest how to get them.

Re: Tables created in lakehouse are NOT visible to SQL endpoint

Anonymous — Mon, 15 Apr 2024 10:43:51 GMT

Hi @sdfabric ,

Thanks for using Fabric Community.
Did you tried refreshing the tables in SQL End point?

Re: Tables created in lakehouse are NOT visible to SQL endpoint

sdfabric — Mon, 15 Apr 2024 10:47:12 GMT

Hi @Anonymous ,

Yes, I have refreshed them several times in SQL endpoint but no luck.

Re: Tables created in lakehouse are NOT visible to SQL endpoint

Anonymous — Mon, 15 Apr 2024 10:52:07 GMT

Hi @sdfabric ,

apologize for the issue you are facing.
Are you able to see the table in lakehouse view?

Can you please share the screenshot? Have you tried creating a new table in lakehouse again via Notebooks?

Re: Tables created in lakehouse are NOT visible to SQL endpoint

sdfabric — Mon, 15 Apr 2024 11:09:01 GMT

Hi @Anonymous ,

Please find below the screenshot from lakehouse where we are seeing the two tables created by Spark Notebook but not in the following screenshot from SQL endpoint of the same lakehouse:

Lakeouse Table VisibleSQLEndpoint Not visible

Re: Tables created in lakehouse are NOT visible to SQL endpoint

Anonymous — Mon, 15 Apr 2024 11:15:13 GMT

Hi @sdfabric ,

Apologize for the issue you are facing. The best course of action is to open a support ticket and have our support team take a closer look at it.

Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link

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

Hope this helps. Please let us know if you have any other queries.

Re: Tables created in lakehouse are NOT visible to SQL endpoint

Anonymous — Tue, 16 Apr 2024 10:38:11 GMT

Hi @sdfabric ,

We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket.
After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thanks

Re: Tables created in lakehouse are NOT visible to SQL endpoint

sdfabric — Tue, 16 Apr 2024 11:30:42 GMT

I have created a support case# 2404160040004106. Please help asap.

Re: Tables created in lakehouse are NOT visible to SQL endpoint

Anonymous — Tue, 16 Apr 2024 15:04:12 GMT

I am also having the same issue,

Re: Tables created in lakehouse are NOT visible to SQL endpoint

gljs — Fri, 20 Sep 2024 12:45:28 GMT

Any chance a solution was ever provided?