Forum Discussion
Unable to read SQL Endpoint view into a Notebook dataframe
Hi Anonymous no I don't believe this will work as the View has been created using the SQL Analytics endpoint, there is no metadata sync from the SQL Endpoint to the Lakehouse (it's the other way round).
You could use JDBC connector in the Notebook to query the View in the SQL Endpoint, or create the View in the Lakehouse using Spark.
edit: I believe pyodbc would work here
having the same issue here. a lot of people out there use sql statements stored in views to create there ETL logic. would be very nice if microsoft is going to support the possibility to read from views in a notebook. I came across the following example using the spark connector which works for me perfect as a workaround. https://fabric.guru/querying-sql-endpoint-of-fabric-lakehousewarehouse-in-a-notebook-with-t-sql