Forum Discussion

Cortana's avatar
Cortana
Icon for Helper IV rankHelper IV
2 years ago
Solved

How can I read views in notebook?

Hello everyone, How can I read my views from the lakehouse sql endpoint in notebook? I want to store those views in a notebook data frame after that I want to write those as a delta table in my lakeh...
data engineering
lakehouse
notebook
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Cortana ,

     

    Views are created using the SQL Analytics endpoint and there is no metadata synchronization from the SQL endpoint to lakehouse.

     

    You can use the pyodbc package to read data from the endpoint or use Spark to create views in lakehouse.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Cortana ,

 

Views are created using the SQL Analytics endpoint and there is no metadata synchronization from the SQL endpoint to lakehouse.

 

You can use the pyodbc package to read data from the endpoint or use Spark to create views in lakehouse.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!