Hello, Is there any way/plugin to save a pinot table as a csv file in s3 bucket?

If you configure S3 as deepstore for Pinot, the table data is already backed up in S3. However, there isn’t a way to bulk export all data in csv format out of Pinot, and is not a good way to use Pinot. What’s the purpose of of saving csv in S3 in your case?

Another way is to Integrate Trino with Pinot in case you need to run ETL queries running on your data . You can do Select * Insert Into a table backed up by Trino . You can also Bulk export you data per Pinot table .If the data is too big you can run insert using a time series in a incremental fashion .