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_NOT_FOUND] The table or view".

 

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

Notebook

4 Replies

    • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI Anonymous,

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

    Regards,

    Xiaoxin Sheng