How to read files from s3 bucket using groovy?

@himanshu1234567 any reasons you can’t use the S3 origin?

@himanshu1234567 would you be able to share more details on the use-case to understand why custom code is needed? The reason I’m advocating for using the built-in origin is because if you go the custom code route then you’ll need to write the code for necessary processing / event generation / errors record handling / offset tracking etc. S3 origin handles all of this automatically. 

@himanshu1234567 

To access data stored in an S3 origin as SQL queries, you will need to set up Athena in your S3 environment.

@himanshu1234567 if the requirement is to query S3 data using SQL then you can use Athena as Bikram suggested. I’m not quite clear on why you want to use Groovy to do that from with-in StreamSets