Hi @amarnathpal,

You can create a View (permanent view) on top dataframe which you can leverage in any SQL Dashboard. The View created will hold the logic of dataframe used to perform transformation.

Also, you can create materialized view, which are preferred for Dashboard scenarios.

pyspark.sql.DataFrame.createOrReplaceGlobalTempView — PySpark 3.5.4 documentation

Regards,

Hari Prasad