Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Lakehouse tables not accessing using sql endpoint through pyspark

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...
notebook
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
Anonymous
Not applicable
2 years ago

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