Are you trying to treat an OLAP database with columnar storage like an OLTP database? If you are, you would probably have the same issue with Snowflake.
As far as S3, are you trying to ingest a lot of small files or one large file? Again Redshift is optimized for bulk imports.
As far as S3, are you trying to ingest a lot of small files or one large file? Again Redshift is optimized for bulk imports.