Big Object

Salesforce Apex Hours:-Big Object

In this session you will learn about Big Object, Need for Big Objects and Big Object Use Cases.

What is a Big Object?

Object that stores & manages massive data volumes within Salesforce without affecting performance. Does NOT count against org data storage limits. Processing scale of 1 billion records.

Agenda :-

  1. Need for Big Objects
  2. Consideration for Big Objects Usage
  3.  Demo
  4. Limitations with using Big Objects
  5. Q&A
  6. Additional References

Need for Big Objects?

  • Nature of Storage
    • Master Data
    • Business Data
    • Operational Data
  • Performance
    • Performance diminishes with large data sets
    • Data retrieval limits
  • Cost
    • Limited data storage

Big Object Use Cases

  • Capture User Activity Code reviews, time entries, page views, field audits etc.
  • Retain Historical Data Historical data stored for compliance
  • 360 Customer View Ancillary customer data e.g. Purchase Details, Transactions

Considerations for Big Objects Usage

  • General
    • Metadata API
    • Max. 100 Big Objects per org
    • Supports DateTime, Lookup, Number, Text, Long Text Area field types only
    • Triggers, Flows, Processes, Salesforce App are unavailable
    • Async SOQL is restricted to specific licenses
  • UI / UX
    • Standard UI unavailable (Tabs, Detail Pages, List Views)
    • Works with Visualforce Pages or Lightning Components
  • Data Security & Access
    • Supports Object & Field Permissions only
  • Analytics
    • No support for Report Builder
    • Einstein Analytics supported
  • Packaging
    • Included in Managed Packages

Deploying your Schema

Big Object Data Manipulation


▶Create / Update (Idempotent Behavior)

▶ insertImmediate(sobject) OR insertImmediate(sobjects)


▶ SOQL Queries

▶ Async SOQL

CSV Files


Using Standard SOQL with Big Objects

  • Executes synchronously
  • All Indexes are mandatory
  • Comparison Operators (=, <, >, <=, >=, IN)
  • Not Supported Operators

SOQL Vs Async SOQL Usage Considerations

Feature Standard SOQL Async SOQL
Mode of Execution Synchronous Asynchronous
Immediate Response Required? Yes No
Expected Result Set Size Smaller Data Sets (Thousands of records) Large Data Sets (Millions of records)
Best Suited For •Displaying Data on UI

•Manipulations within Apex


•Summarizing for Analytics

Filter using Non Index fields Yes No
Sample Format SELECT Game_Platform__c, Play_Date__c

FROM Customer_Interaction__b


Game_Platform__c=’PC’ AND Play_Date__c=’2017-09-06′


“query”: “SELECT Account_c, In_Game_Purchase__c FROM Customer_Interaction__b WHERE Play_Date__c=’2017-09-06′”,

“operation”: “insert”,

“targetObject”: “Customer_Interaction_Analysis__c”,

“targetFieldMap”: {





“$JOB_ID“ : “BackgroundOperationLookup__c”,

“Copy fields from source to target“ : “BackgroundOperationDescription__c”}


Here is PPT for Session


Here is recording for Session


Please Subscribe to the channel to get notification for upcoming recording.

If you are new in Salesforce. Please check our free Salesforce Admin and Salesforce Developer training.

Salesforce Apex Hours


659 total views, 3 views today

Leave a Comment