In General Salesforce Big Objects (Below are
the features & limitations):
·
Using Big Objects we can store and manage
massive amounts of data on the Salesforce platform.
·
For
Big Objects the API Names have a suffix of two underscores immediately followed
by a lowercase “b” (__b).
·
We
can also define & mark Index fields for Big Objects.
·
We
can create a Big Object in salesforce.com using the Metadata API in
salesforce.com by using XML files that contains the Definition, fields &
index.
·
We
can use a CSV file to load data into a custom big object via SOAP API Bulk API.
·
We
can create and update custom big object records in Apex using the
insertImmediate method.
Re-inserting
a record with the same index but different data results in behavior similar to
an upsert operation.
·
Big Object cannot be related to another Big Object.
SOQL with Big Objects
·
We
can use =, <, >, <=, or >=, or IN on the last field in the SOQL
query. Any prior fields in the SOQL query we can only use the = operator.
·
The
! =, LIKE, NOT IN, EXCLUDES, and INCLUDES operators are not valid in any query
for Big Objects.
·
We
can only use the Index fields in the Where Clause for Big Objects.
·
We
can only Query on the basis of Index fields only in the where clause, we also
have order defined for indexes for Big Objects
& we can filter data on the basis Index fields only if we don’t have
gap in the Index Fields specified in the Where clause. Is there any workaround
for it?
For Example – If we
have three index fields then we can have Indexes in the Where Clause,
We can Query on Index
field with order 1.
We can Query on the
basis of Index Fields with order 1 and Order 2.
We can Query on the
basis of Index Fields with order 1 and Order 2 and Order 3.
We will not be able to
Query directly on the Basis of Index field with order 2 only.
We will not be able to
Query directly on the Basis of Index Fields with order 1 and 3 as we are not
including the 2 index field.
Data Types Support for
Custom Big objects Fields
Supports
DateTime, Lookup, Number, Text, and LongTextArea.
Big Objects Limitations:
·
We can create a big object or add a
field to a custom big object in Salesforce.com using the Metadata API only.
·
Big objects support custom
Lightning and Visual force components rather than standard UI elements home
pages, detail pages, list views, and so on).
· We can create up to 100 big object per org. The limits for big
object fields are similar to the limits on custom objects, and depend on the
org’s license type.
·
Features
like triggers, flows, processes are not available for Big Objects.
·
The
total length for all text fields in an index can't exceed 50 characters.
