I am new and trying to see if pinot is suitable for my use case. I have a requirement where I need different indexes for different teams to support different query pattern on the same table. I am planning to use offline table. is there a way I can generate the segments once for the tables with different indexing pattern?

You can upload same segment to different tables and have different indexing config for each.

My knowledge on pinot is limited so validating. My problem is different teams have different query patterns, data retention and concurrency requirement. As a central data team, want to publish the data for them to consume, at the same time, we want to allow them to self serve by adding right indexes, define retention etc. that makes sense for their use case. We don’t want to build indexes or tune the tables for them. What is the best approach here?

Okay. Got it. What is the source of data Stream or batch

It’s batch. Every 6 hours.

Depending on the data size and read-load you might choose to have a single table with indexing on all superset of columns, or have your clients separate custom variations.