How can I read views in notebook?

[Cortana]

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 lakehouse. Kindly help. Thank you.

[Anonymous · Accepted solution]

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!