Hello Guys, Could you please provide clarity on how to migrate data from the current Pinot table to a new table? We are moving to a new server, so we need to ensure that the migration happens in production without any data loss. Both tables will have upserts enabled, so I need guidance on the correct and safe way to migrate the data while handling upserts.

is it realtime table or offline table? offline table is simple, you just need to push segments from old table deep store(they are already in tar.gz format) to new table

it is a realtime time with upserts, i want to move data along with upserts and don't loss any data. i think as per doc offline table won't work upserts right? please clarify these queries

I see. In this case, I would suggest to create the new table and wait for the data loaded then continue?