Questions tagged [big-object]

The tag has no usage guidance, but it has a tag wiki.

Filter by
Sorted by
Tagged with
1 vote
0 answers
24 views

What is the impact of a big object lookup to a Standard/Custom Object?

Say I have a data model where an Big Object where I want to store an Account Id. Is it better to store the 18 char Id as Text, or actually make the lookup relationship so the big object looks up to ...
0 votes
0 answers
31 views

Test Class for Big Objects [duplicate]

I have a visualforce page that generates a PDF. I am querying for big object data and build the PDF based off of the data from the big object. I am trying to create a test class that covers this but I ...
  • 101
1 vote
0 answers
40 views

Can we package custom Big Objects into a 2nd generation managed package?

When I try to create a package version via sfdx force:package:version:create, it gives an error: ERROR running force:package:version:create: Unexpected file found in package directory: /my-base-path/...
  • 31
1 vote
0 answers
95 views

Simple Salesforce how to create Custom Big Object?

Is there a way to create Custom Big Object with the simple salesforce metadata API? This is my approach: idx_field = mdapi.IndexField( name="MY_ACCOUNT_ID__c", sortDirection=&...
  • 11
1 vote
1 answer
158 views

Schedulable Class - Big Object

I've created a schedulable class that retrieves info from SetupAuditTrail everyday and creates a big object records on a daily basis. The schedulable class works fine. But when I run the test class, ...
0 votes
0 answers
62 views

Can we package a Big Object in base package and add new fields in an extension package?

I'm looking to collect stats from multiple objects and combine them into a singular Big Object for data processing. My architecture revolves around multiple Managed Packages with Big Object part of ...
  • 5,738
2 votes
1 answer
230 views

Can we show a Big Object with lightning-record-form in LWC?

I want to show my custom big object in LWC lightning-record-form ? Is it possible ? When i do this i get this error : Code for the form : <lightning-record-form record-id={selectedBigObject.Id}...
0 votes
2 answers
2k views

Does Database.QueryLocator and Iterable both have same limit?

I wrote a batch class to insert dummy data into big object and have used Iterable to insert data. I was under impression that Iterable should only be able to insert in normal limit of 50K records. But ...
1 vote
0 answers
148 views

Big Objects - How to Retry a Batch?

In exploring Big Objects the docs state the below: When working with big data and writing batches of records using APIs or Apex, you can experience a partial batch failure while some records are ...
  • 5,275
15 votes
1 answer
929 views

How to archive & restore Custom Objects in Big Objects

For my app I want to build a Archive and Restore functionality. For a given Custom Object MyObject__c and a Big Object ArchivedMyObject__b those requirements need to be fulfilled: MyObject__c records ...
9 votes
0 answers
275 views

Move Large Data Volume objects to Big Objects

I have built an Open-Source tool that collects App Errors in Managed Packages and creates Custom Object records for each of them in a Salesforce org. This app can produce thousands of records per day. ...
1 vote
1 answer
706 views

How can we make Async SOQL queries to big objects from Apex?

I'm looking at ways to execute an Async SOQL query for a Big Object using Apex. The documentation suggests this can only be done using the Connect REST API. https://developer.salesforce.com/docs/atlas....
  • 306
1 vote
0 answers
697 views

Insert Big Object in Batch Class

I am trying to create records in a Big Object using a Batch class. However, when executing the Database.InsertImmediate() command, the error below occurs: Just as a note, the Database.InsertAsync() ...
0 votes
1 answer
553 views

How to delete custom fields from Big Object?

How do I delete non-indexed custom fields on a Big Object ? I do not see a 'delete' option next to 'edit' option of a field.
  • 25
2 votes
1 answer
2k views

How to parse large size csv file content into custom object in Salesforce?

I have requirements to implement the LWC file upload wizard which should handle very large size csv file( about 1 GB).. is it doable to parse such large size csv through APEX batch method? I tried ...
3 votes
2 answers
539 views

Deleting Big Object Workaround Without Using Database.deleteImmediate

Known Issue for not being able to deletg Big Objects with database.deleteImmediate still open. This is the only method mentioned in docs to do this. Workaround to delete 1 X 1 is a joke. Any other ...
  • 1,476
1 vote
1 answer
426 views

Get data from Big Object in Marketing cloud

Due to storage limitation I need to think of a way to archive/reduce the storage for orders and order line items. I was thinking of Big Objects, but I need to be able to use the data from Orders and ...
1 vote
1 answer
302 views

Clone data of big object into another big object

I have roughly 10 million records in a big object and now I need to move the data/clone the records in another big object. The reason why I am doing this is that I need to modify/add more fields to ...
1 vote
0 answers
657 views

Testing Batch Apex with Big Objects

I have a batch apex class that uses Big Objects for processing. However, when running tests on this batch class, Salesforce throws an error not allowing Big Objects to be inserted for testing: https:/...
-2 votes
1 answer
563 views

Custom Object or Big Object for dataset of 3 million records [closed]

I am sort of confused in what approach to take in storing large amounts of data in Salesforce. I have some data that is between 2 - 3 million records and I want to access that data through apex code ...
  • 581
11 votes
4 answers
943 views

Run more than one async jobs from Future/Quable context

We have created a process which must work asynchronously (limits and architecture reasons) and it was working fine. Some time later we have started to work with BigObject. And as long as writing to ...
  • 113
0 votes
1 answer
265 views

Retrieve a pre-existing big object via metadata in order to add new fields

Goal Retrieve a pre-existing big object in salesforce. Add new Fields to the metadata and deploy it back to the same org Question Can this be done via the workbenches retrieve tool? Steps Taken so ...
0 votes
1 answer
180 views

What is the proper way to enable SeeAllData when working with Event Monitoring Big Objects?

I'm using Event Monitoring & would like to use @SeAllData = true in my unit tests, so that I can leverage pre-existing logs. However, when I enable it & query an Event Monitoring object, I ...
2 votes
2 answers
790 views

How to use order by in Big Object Query?

I am trying to query records from big object in a list, using the following query Select Edit_Date__c ,CreatedDate,Field__c ,Loan_ID__c ,New_Value__c ,Old_Value__c ,User__c, System_Updates__c, ...
2 votes
2 answers
2k views

How to retrieve total number / count of records stored in Big Object?

Even this seemingly easy task is impossible to do. For some reason, even when I loaded millions of data into Big Object, it somehow isn't reflected in Setup > Storage Usage Given sometimes it ...
  • 1,153
2 votes
0 answers
132 views

How to map static date field in Async SOQL query job?

I'm trying to use Aggregate Async SOQL to Query Big Objects to a custom Object like below (https://developer.salesforce.com/docs/atlas.en-us.chatterapi.meta/chatterapi/...
  • 1,153
1 vote
1 answer
188 views

Treatment of large data sets (>1M) in standard objects

Question: At what point Salesforce tags a standard object as big object? We are planning to load about 10+ million (one time) records in Asset and Order object and there would be incremental records ...
  • 390
4 votes
1 answer
1k views

Is there a way to delete >1 Million records from a custom Big Object?

First thing that came to my mind was writing a Batch Apex to do this but I get this error. System.UnexpectedException: The requested operation is not supported by this SObject Deleting via Bulk API ...
  • 1,153
1 vote
1 answer
117 views

How long does an Async SOQL query against big objects take?

Is there a ballpark for how long async SOQL queries on big objects take? I know i depends on the size of the data, but are we talking minutes vs hours vs days?
  • 2,643
1 vote
2 answers
721 views

Can you change set a Big Object?

I am trying to change set a big object from my developer sandbox to a full sandbox. I have seen here in the dev notes that it can be done via the metadata api. But nothing about changesets. So I ...
0 votes
1 answer
472 views

Archive master-detail relationship Custom Objects with Attachments into Big Objects

We are running into a problem when querying and reporting performance is degrading due to having huge number of records on org of some specific custom objects. Basically in our use case, we are not ...
  • 2,853
3 votes
0 answers
521 views

How to test big object creation in unit test

I have an apex trigger which fires a platform event. And in the platform event trigger, it creates a big object. My unit test code is pretty simple and looks like below: Account acc = ...
  • 12.8k
2 votes
0 answers
128 views

Intermittent, inconsistent issue deleting BigObjects

we have an intermittent issue when deleting big objects. We have a scheduled job that runs every 30 minutes, and if some conditions are met, it runs the following: try { if (!Test.isRunningTest())...
  • 3,976
1 vote
2 answers
1k views

Populating Big Objects from CSV

I need to create a client application where users can upload CSV files, which will then be used to populate Custom Big Objects. My problem is I'm not sure which API to use. The Salesforce ...
  • 11
2 votes
1 answer
941 views

How to query non-index field on Big Object?

I'm learning Big Object on trailhead and I have completed deploy the big object to my org. But I have a question is that: how can I query non-index field by SOQL? I know that only index fields can ...
  • 146
2 votes
1 answer
1k views

System.UnexpectedException: Error processing messages in Test Class for Batch Apex

Error Message System.UnexpectedException: Error processing messages Stack Trace Class.System.Test.stopTest: line 24, column 1 Class.payout.BIgObj_Test.MyMethod: line 31, column 1 Batch Class ...
0 votes
1 answer
707 views

Attach Files to a Big Object record

I would like to associate Files with Big Object records. Documentation inference implies this is not technically possible... if a Big Object could be a "LinkedEntityId" I imagine it would have been ...
  • 2,121
2 votes
2 answers
799 views

Field is not writable on custom Big Object in APEX

I'm trying to read a set of records from a custom Big Object, update a long text field (not part of the object index), and then upsert back. When trying to update the value of the field I get 'Field ...
  • 21
0 votes
1 answer
30 views

How to get access to the 'Setup -> Create -> BigObjects' page?

How to get access to the 'Setup -> Create -> BigObjects' page? It was working fine recently and now I'm receiving Insufficient Privileges
  • 113
5 votes
1 answer
2k views

Creating BigObject Record in Test Class Using Test.loadData(..)

Successfully used testLoadData for a number of test classes for "regular" Sobjects. Have seen references to Stub Api Mocking Framework for one method to create test records for Big Objects in Apex but ...
  • 1,476
2 votes
1 answer
227 views

How can I setup a scheduled sync from a SQL Server database to Salesforce Big Objects?

What is the best way to have a daily scheduled insert/update of a SQL Table into Salesforce Big Objects? We currently have a C# adapter to update Salesforce standard object records with SQL database ...
0 votes
1 answer
385 views

Create New Big Object Record in Marketing Cloud Journey

After sending an SMS or Email to a customer using a Marketing Cloud Journey, we would like to create a record in Service Cloud that details the content of the communication as well as the date/time ...
1 vote
0 answers
26 views

What causes exception 2015936646-114094 (-407009801) in deployments?

I am trying to do a deployment of a Big Object as part of this trailhead module using Workbench API 41. I have verified that I am in the correct org. https://trailhead.salesforce.com/content/learn/...
0 votes
2 answers
613 views

Big Objects visibility on page or reports

I would like to know any way where we can show data of Big objects in any page or in report format. I need archival strategy where all the previous unused data needs to be added in Big objects and ...
  • 1,428
1 vote
1 answer
248 views

Displaying related cases Email data on visualforce Page for Big Objects Data

First of all i am very new in salesforce and not have anything to do with programming however i have been trying to finish my first project by getting help online. I have created a BIG OBJECT "...
  • 41
0 votes
1 answer
590 views

Can not see data on VisualForce page for Big Objects data

I created a Visual force page for Big object data to be seen. However when i import data from workbench i am unable to see the full data in VF page. For some reason i can only 2 records out of 10 and ...
  • 41
1 vote
1 answer
306 views

Error inserting data into big object

Refer to pictures. I am trying to insert data into a big object and get the following error "variable does not exist" and it refers to the textbody Anyone have any suggestions?
4 votes
0 answers
177 views

"Reached maximum number of custom objects" while creating BigObject

I am trying to create a Big Object through workbench but I keep hitting the following error message: reached maximum number of custom objects. I have only used 6% of my custom object allocation ...
1 vote
0 answers
64 views

Salesforce - Restoring big objects

I'm trying to retrieve the data from certain big objects. The documentation seems to underline a different behavior on the data: Do not use the Id field in a query. Including Id in a query returns ...
  • 1,089
0 votes
2 answers
161 views

Big Object query error

I am using below query and getting the error "COMPILE ERROR: Variable does not exist: R1_ACC_TXT_Id_Golden_record__c LINE: 3 COLUMN: 47" Query: List<Account> Ac = [SELECT Id,FirstName,...