Hi, you can create a temporary table and then retrieve it with every rogramming language:

ex create in sql:

%sql
CREATE OR REPLACE TEMPORARY VIEW Test1 AS
 SELECT *
 FROM TEST

And then retrieve in python

%python
spark.read.table('Test1')