Hi Team - I am new to Pinot. We like to create the real time dashboard from the raw data stored in s3 & Kinesis. The transformed data will be stored in Pinot. What is the best optimised way to transform the data? Which tool / components/ languages can be used for data compute or transform? Or shall we use a Pinot SQL query for transformation?

What are the transformations? If row level, you can transform during ingestion in Pinot