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.

Async SOQL use case.

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 :

Big ObjectssObjects
Horizontally scalable distributed databaseRelational database
Non-transactional databaseTransactional database
Hundreds of millions or even billions of recordsMillions 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.
<strong>Prashant Uniyal</strong>
Prashant Uniyal

☁Salesforce Consultant ®6x Certified ✐Trainer 💻Blogger ✌Trailhead Ranger

Leave a Reply