Forum Discussion
Helper IIISpark Data Warehouse Connector and Pyspark
Community ChampionI think pyodbc is an alternative if you want to work with Warehouse or SQL Analytics Endpoint from a Notebook.
I have zero experience with it but you could try to Google "fabric data warehouse pyodbc"
Perhaps this post can help: https://debruyn.dev/2023/connect-to-fabric-lakehouses-warehouses-from-python-code/
and
https://stackoverflow.com/questions/78285603/load-data-to-ms-fabric-warehouse-from-notebook
yongshaoWe have been trying to automate some views into lakehouse SQL endpoint, but so far the only way is using Script pipeline. With the script pipeline we have to manually establish the connection of lakehouse SQL endpoint, which cannot be automated
I tried pyodbc approach - it could query the lakehouse data, but it cannot create any view to lakehouse SQL endpoint