Vajiha, I believe that you might be confusing stuff ? Permanent View in PSQL is a standard view.
Temp view or Global View is the Spark View that is internal for Spark. Can we get a snippet of the code please. On Wed, 4 Jan 2023 at 15:10, Vajiha Begum S A <vajihabegu...@maestrowiz.com> wrote: > > I have tried to Create a permanent view in Postgresql DB through Pyspark > code, but I have received the below error message. Kindly help me to create > a permanent view table in the database.How shall create permanent view > using Pyspark code. Please do reply. > > *Error Message::* > *Exception has occurred: Analysis Exception* > Not allowed to create a permanent view `default`.`TEMP1` by referencing a > temporary view TEMP_VIEW. Please create a temp view instead by CREATE TEMP > VIEW > > > Regards, > Vajiha > Research Analyst > MW Solutions >