In the release notes of May 2022 it says that we are now able to investigate our SQL results in python in a python notebook. (See also documentation here: Use notebooks - Azure Databricks | Microsoft Docs ) So I created a simple query (select * from mytable Limit 10) where I query on a table on our ADLS in a sql cell. However, when I try to call the results in the next (python) cell, it errors that _sqldf is not defined.
Ideally I would like to create a bunch of SQL scripts and call the results of these scripts in other notebooks, so that our SQL analists can create regular SQL queries, while developers can call these scripts and write their results to the blob storage.
