hi all. anyone want to share their pinot setups as far as external customers? Has anyone built web apps or http proxies on top of it to expose to customers? if so, what frameworks did you use, what pinot libraries/apis, etc

As per most user-facing dashboard systems, you wouldn’t want to directly expose the Pinot APIs (query or otherwise) to customers. So for one of our clients, they have a Python layer/API (custom, I think) that “fronts” Pinot and generates the actual queries. This helps protect you against things like customers running Groovy code on your Pinot servers :)