Is there a tool to load data and schema from postgres? I would like to get some data into pinot and see how it works for our data, but creating the schema/index manually is a bit of a pain as the tables have large number of columns.

Hi Dash, We dont have a tool to create Pinot Schema from Postgres table. One workaround is to export postgres to Avro and we have the ability t o create pinot schema from Avro file

Thanks, will try this out.

@User You might have already solved this, but I've built a little schema transformer for DDLs that will automatically generate the schema JSON. Let me know if you're interested and I'll put it up on GitHub somewhere.

I haven’t done it. The tool sounds interesting, will try it out if you made it avaliable.