A big object stores and manages massive amounts of data on the Salesforce platform. You can archive data from other objects or bring massive data sets from outside systems into a big object to get a full view of your customers. Clients and external systems use a standard set of APIs to access big object data. A big object provides consistent performance, whether you have 1 million records, 100 million, or even 1 billion. This scale gives a big object its power and defines its features.
There are two types of big objects.
Standard Big Objects : Objects defined by Salesforce and included in Salesforce products. Standard big objects are available out of the box and cannot be customized.
Custom Big Objects : New objects that you create to store information unique to your org. Custom big objects extend the functionality that Lightning Platform provides.
Custom Big Object Use Cases :
- 360° view of the customer—Extend your Salesforce data model to include detailed information from loyalty programs, feeds, clicks, billing and provisioning information, and more.
- Auditing and tracking—Track and maintain a long-term view of Salesforce or product usage for analysis or compliance purposes.
- Historical archive—Maintain access to historical data for analysis or compliance purposes while optimizing the performance of your core CRM or Lightning Platform applications.
Differences Between Big Objects and Other Objects :
|Horizontally scalable distributed database||Relational database|
|Non-transactional database||Transactional database|
|Hundreds of millions or even billions of records||Millions of records|
Big Object Limitations :
- You can create a unique index but can not modify it later.
- Only Lookups, Text (long), Integer and DateTime are allowed as fields.
- Triggers, Workflows, Process Builders and Salesforce App, Only with future methods/queueables
- Sharing Rule, Encryption of data
- Salesforce connect external objects
- Standard UI Elements like list views, detail pages.
Considerations When Using Big Objects :
- We can create up to 100 big objects per org. The limits for big object fields are similar to the limits on custom objects and depend on your org’s license type.
- You can’t use Salesforce Connect external objects to access big objects in another org.
- Suffixed with “_b” eg : PhoneBook__b.