A common workflow for is to create a temporary table to break down your analysis into smaller pieces.
Before, PopSQL would only maintain PostgreSQL and Redshift sessions for 30 seconds. So if you ran one query to create a temporary table and didn’t run another query for 30 seconds, the session would be terminated and your temporary table would be dropped. Bummer!
Now, PopSQL will keep your PostgreSQL and Redshift sessions open for 8 hours. So if you run a query to create a temporary table, you can come back up to 8 hours later and it will still be there for you to continue your analysis.