We are a big Airline org and we have unified solutions for call centers into Service Cloud wherein we have a custom Account objects (~47 million records), cases and Lounge Accesses, etc.

How do you think we can make use of Big objects? Only for Archival of data? Can Agents use big objects data in Real time? How do I best utilise those first million big object records in our org?

1 Answer 1


Big Objects in Salesforce are definitely not thought to be useful for real-time transactions. As seen on Trailhead, it was created to tackle a few specific scenarios, like 360° View of the Customer, Auditing and Historical Archive.

If you have 47 million records to load into Salesforce, you have to conduct an analysis and check if you really need all of them on the platform, or if you can export most of them to an external database. The reason for dealing with records outside of the platform is mostly because of the cost. Salesforce storage is really expensive.

With this in mind, I'm not saying that Big Objects cannot be used in real-time situations, but they are handled in a different way and have their own considerations (they don't support triggers, for example). In your situation they might not be useful at all, since you can archive your data in an external database.

  • Thanks Renato for your response but can't we archive the past data say old cases? Also isn't it beneficial to have the data natively on the platform rather than bear the cost of integrations with external platform. Can't I propose this to my business users that we can use real time transactional data in the standard/custom objects and use Big Objects for archiving the old records (cases,Accounts etc ) so that we stay natively on the platform. Sep 16, 2018 at 9:04
  • Sure you can. Just take in consideration that big objects are not easily accessible like standard or custom objects. I’m not sure how the pricing works for big objects, but you start with one million rows, and then you’ll have to pay for more rows. Sep 16, 2018 at 12:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .