I have roughly 10 million records in Big Object and now I need to move the data/clone the records in another big Object.
The reason why I am doing this is that I need to modify/add more fields to the unique Key in Big Object. So, I have created a new big Object with a new unique key and now need to migrate the data into a new big Object.
I have tried with the data loader Bulk API checkbox, its gets error after some time (Failed to write query result- Internal Server Error).
What would be the best way to do that.