The simpliest way would be propably using spark.sql

%py
tbl_name = 'table_v1'
df = spark.sql(f'select * from {tbl_name}')
display(df)

 From there, You can simply create temporary view:

%py
df.createOrReplaceTempView('table_act')

and query it using SQL statements:

%sql
select * from table_act order by 1 asc;