Using AWS Glue ETL Transform and storing the resulting data in Redshift Serverless Cluster causes error

I was trying to perform Glue ETL transformation and store it in AWS Serverless Redshift database and S3 (both) . However, even the Console generated PySpark sheet fails. Almost none of the methods seem to work. Also, most YouTube videos that I have seen , use Redshift Clusters, instead of Serverless Database. Is there any difference that Redshift serverless Cluster is not optimised properly to work with Glue ?