Well, if you are using 9.4, then you need another application to create the parquet files for you.
You can use Hive as you seem to be doing now, or use a Python package such as Panda that you can call from SAS, for example.
Then you transfer the files to S3.
There might be other methods (such as AWS Glue), but I'm not familiar with them.
Note that option BULKLOAD allows loading multiple rows of data as one unit, to insert or append them to a DBMS table.
A S3 bucket is not a DBMS. You are not shifting rows, you are shifting files, so this option has nothing to do with S3.
Caveat: I never used S3, so my understanding of its capabilities might be limited.
... View more