topic Re: Lakehouse tables not accessing using sql endpoint through pyspark in Data Engineering

Lakehouse tables not accessing using sql endpoint through pyspark

Anonymous — Fri, 12 Jul 2024 14:19:56 GMT

Hi Team,

i am connecting the tbales and views in lakehouse using sql endpoint connection string from pyspark note book. but i am not able to access the views and gettingbelow error.

"[TABLE_OR_VIEW_NOT_FOUND] The table or view".

can't we access lakehouse views from pyspark note book? please suggest.

Re: Lakehouse tables not accessing using sql endpoint through pyspark

Anonymous — Mon, 15 Jul 2024 02:06:32 GMT

HI @Anonymous,

Have you setting the default Lakehouse on the left side? AFAIK, these operations will check on the default Lakehouse contents at first. So if you haven't configured it, then it will return the error of table view not found.

Explore the lakehouse data with a notebook - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng

Re: Lakehouse tables not accessing using sql endpoint through pyspark

Anonymous — Mon, 15 Jul 2024 04:21:43 GMT

Hi Xiaoxin ,

Thanks. I set default lake house already. i have only one lake house in my workspace and i am using JDBC connetion string so not able to access the views using pyspark notebook. can you help on this how to access the views from notebook using pyspark.

Re: Lakehouse tables not accessing using sql endpoint through pyspark

Anonymous — Thu, 25 Jul 2024 08:49:36 GMT

Hi @Anonymous,

So you mean you are using notebook to read data from external with jdbc connection string? If that is the case, have you tried to query data from tables based on this connection?
Any security or permissions settings applied to the data source or credentials that limit the operations?
Regards,

Xiaoxin Sheng

Re: Lakehouse tables not accessing using sql endpoint through pyspark

Anonymous — Fri, 16 Aug 2024 08:20:24 GMT

HI @Anonymous,

Any update on this? Can you please share some more detailed information about this issue?

Regards,

Xiaoxin Sheng