Overview

A big object is created as a backup store for Cases. A scheduled #Batch Executable inserts Case records into the big object on a recurring basis using Incremental Retrieve, so each run only processes Cases changed since the last execution and keeps the backup up to date.

General Use Case

Salesforce Big Object provides a cost-effective way to store large volume data with strong performance without moving data off-platform. Use #Batch to load data into Big Objects for structured backup/archive, record-based change history, long-term compliance retention, high-volume transactional storage, and more.

Video Demo

Prerequisites

Required Big Object
Case__b
RecordID__cText(100)Index
CaseNumber__cText(255)
ClosedDate__cDateTime
CreatedDate__cDateTime
ContactEmail__cEmail(80)
Priority__cText(100)
Status__cText(100)
Subject__cText(100)
Description__cLong Text Area(32768)
AccountID__cText(100)
ContactID__cText(100)
OwnerID__cText(100)

Downloadable Executables

DownloadCases.Backup

Walkthrough

1

Pipeline - Data.Backup.Batches

pipeline-data-backup-batches
2

New Executable - Cases.Backup

new-executable-cases-backup
3

Batch Settings

batch-settings
4

Retrieve

retrieve
5

Mapping

mapping
6

Action

action
7

Create Schedule for Executable

create-schedule-for-executable