Big Objects Implementation Guide

Big Objects
Big Objects Best Practices
Define and Deploy Custom Big Objects
Populate a Custom Big Object
Delete Data in a Custom Big Object
Big Objects Queueable Example
SOQL with Big Objects
Async SOQL
API End-of-Life
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Delete Data in a Custom Big Object

Use Apex or SOAP to delete data in a custom big object.

The Apex method deleteImmediate() deletes data in a custom big object. Declare an sObject that contains all the fields in the custom big object’s index. The sObject acts like a template. All rows that match the sObject’s fields and values are deleted. You can specify only fields that are part of the big object’s index. You must specify all fields in the index. You can’t include a partially specified index or non-indexed field, and wildcards aren’t supported.

If you’re deleting all records because of capacity optimization, insert one or two blank records after deletion and wait 24 hours for the new capacity to be recognized.

The batch limit for big objects using deleteImmediate() is 50,000 records at a time.

Important

These examples assume that when you initially inserted big object values you used the Apex String.trim() method to remove leading and trailing white space in the index fields. See Populate a Custom Big Object with Apex.

Note

In this example, Account__c, Game_Platform__c, and Play_Date__c are part of the custom big object’s index. When specifying specific values after the WHERE clause, fields must be listed in the order they appear in the index, without any gaps.

To use the SOAP call deleteByExample(), declare an sObject that contains the fields and values to delete. The sObject acts like a template. All rows that match the sObject’s fields and values are deleted. You can specify only fields that are part of the big object’s index. All fields in the index must be specified. You can’t include a partially specified index or non-indexed field, and wildcards aren’t supported. This example deletes all rows in which Account__c is 001d000000Ky3xIAB, Game_Platform__c is iOS, and Play_Date__c is 2017-11-28T19:13:36.000z.

Java example code:

Repeating a successful deleteByExample() operation produces a success result, even if the rows were already deleted.

Note