Big Objects in Salesforce

Begin With Big Objects in Salesforce | The Developer Guide

You, the quintessential Salesforce genius, thoroughly understand standard articles, custom items, and outer items. You thoroughly understand how these articles assist you with overseeing and controlling information so you can do stunning exploring things with your organization or outside the framework.

In this strong new period of enormous information, you can frequently end up with all in all too much information, a casualty of your own prosperity. There are numbers to crunch, however, it's difficult to viably or effectively crunch them. Execution endures a shot, and you begin to wish that your norm, custom, or outside items could be… greater.

That is the place where large articles come in. Huge items permit you to store and deal with a huge measure of information on the Salesforce stage. How huge, you inquire?

1,000 records? No, think greater.

A hundred thousand? Greater!

1,000,000? Off by a long shot!

Enormous items give steady execution to a billion records or more and are available with a standard arrangement of APIs to your organization or outside the framework. Think about all that information! We essentially took a gigant-o-beam to the items you definitely know and love to make large articles. 

There are two kinds of enormous articles.

Standard enormous items are characterized by Salesforce and are remembered for Salesforce items. FieldHistoryArchive, some portion of our Field Audit Trail item, is an illustration of a standard enormous article. FieldHistoryArchive permits you to hide away to 10 years of documented field history information, assisting you with going along industry guidelines identified with evaluating and information maintenance.

Custom huge items are characterized and sent in Setup. You can make a custom large article in Setup, where you set its definition, fields, and record. The fields characterized in a major item's file decide the huge article's personality and its capacity to be questioned. We get into how this is totally assembled in the following unit.

dont miss out iconDon't forget to check out: Salesforce Apex Winter Release 21 - All You Need To Know

What Are the Different Ways to Use Custom Big Objects?

In spite of the fact that you can utilize huge items to store various types of information, large articles were made to handle a couple of explicit situations.

360° View of the Customer

You have a ton of client data you need to store. From reliability projects to exchanges, requests, and charging data, utilize a custom enormous item to monitor everything about.

Evaluating and Tracking

Keep a drawn-out perspective on your clients' Salesforce use for examination or consistency purposes.

Authentic Archive

Keep up admittance to verifiable information for investigation or consistency purposes while upgrading the presentation of your center CRM or Lightning Platform applications.

Questioning Big Objects

Obviously, keeping all that information won't benefit you in any way in the event that you can't run the legitimate examination on your records. You can inquiry about enormous items utilizing standard SOQL or with Async SOQL. 


You can question enormous articles utilizing a subset of standard SOQL orders. Use SOQL on the off chance that you realize that your inquiry will restore a limited quantity of information, don't have any desire to hang tight for the outcomes, or need the outcomes returned promptly for use in Apex. We go further into how standard SOQL functions diversely with huge articles in the following units.

Async SOQL

We've created Async SOQL to help deal with a great many possible records in your custom large items. Async SOQL is an approach to run SOQL inquiries in circumstances where you can hardly wait for the outcomes progressively because of the sheer size of the information being questioned. It is a profoundly adaptable arrangement that utilizes a subset of SOQL orders, making it simple to use for anybody effectively acquainted with SOQL. Async SOQL timetables and runs questions non concurrently out of sight, so it can run inquiries that typically break with standard SOQL. With Async SOQL, you can run numerous questions out of sight while checking their finishing status. Set up your inquiries and return a couple of hours after the fact to an amazing dataset to work with. Async SOQL is the most proficient approach to deal with the enormous measure of information in a major item.


While custom huge items are incorporated with each permit, Async SOQL is incorporated uniquely with the authorizing of extra-large article limit.

dont miss out iconCheck out another amazing blog by Mohit here: Get to Know About the B2B Commerce Data Model | Salesforce Help Guide

What's the Catch?

Due to the scale that large items work in, they don't work precisely like non-enormous articles. Here are a few things to remember when utilizing large items.

  • Big objects uphold just article and field authorizations.
  • Once you've conveyed a major article, you can't alter or erase the file. To change the record, begin once again with another huge item.
  • SOQL relationship questions depend on a query field from a major item to a norm or custom article in the select field list (not in channels or subqueries).
  • Big objects uphold custom Salesforce Lightning and Visualforce segments as opposed to standard UI components (home pages, detail pages, list sees, etc).
  • You can make up to 100 major items for every organization. The cutoff points for huge item fields are like the cutoff points on custom articles and rely upon your organization's permit type.
  • Big objects don't uphold exchanges that incorporate enormous items, standard articles, and custom items.
  • To uphold the size of information in a major item, you can't utilize triggers, streams, measures, and the Salesforce application.



Popular Salesforce Blogs