Thank you for your response, I just tried this line, it did not work:
spark.sql("CREATE OR REPLACE TEMP VIEW matched_view AS SELECT * FROM matched_spark")

it gives me an error on my notebook saids spark.sql can't be found, by the way, I'm writing this in R cell.

However, the following syntax works:

matched_spark %>% sparklyr::sdf_register("matched_view")
 
and then I can use SQL on the next cell to work with matched_view