Is there any terraform provider to manage apache pinot (e.g. Setting up tables and streams etc)?

No. there is a helm chart to deploy on k8s. is this for on-prem?

No, it's the startree service... But also to configure this one it would be nice to not build something own