Lakehouse tables not accessing using sql endpoint through pyspark

[sriniwas_msbi]

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.

[Anonymous]

HI @sriniwas_msbi,

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

[sriniwas_msbi]

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.

[Anonymous]

Hi @sriniwas_msbi,

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

[Anonymous]

HI @sriniwas_msbi,

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

Regards,

Xiaoxin Sheng