First thing that came to my mind was writing a Batch Apex to do this but I get this error.

 System.UnexpectedException: The requested operation is not supported by this SObject

Deleting via Bulk API using Dataloader is not allowed too for some reason.

I only found documentation on this here : https://developer.salesforce.com/docs/atlas.en-us.bigobjects.meta/bigobjects/big_object_delete.htm

but even then I am only able to delete 50000 rows a time otherwise will get the error :

System.LimitException: Too many query rows: 50001

I'm currently running this code in Anonymous Apex :

List<bigobject__b> BO = new List<bigobject__b>(); 

BO.addAll([SELECT Company_Name__c FROM bigobject__b LIMIT 50000]);


Any suggestions how else I can perform this delete quicker and more efficiently?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.