I have roughly 10 million records in a 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 the 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, but I get an error after some time:
Failed to write query result- Internal Server Error
What would be the best way to do that?