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 be used in filter and returned, how can I get the value of those non-index fields? When I include non-index field in SOQL, it said:
"No such column 'Level_Achieved__c' on entity 'Customer_Interaction__b' ".

If I can't get the value of those fields, how can I reuse those records in big objects in the future?

Below is the SOQL I Use:

SELECT Account__c,CreatedById, Level_Achieved__c FROM Customer_Interaction__b

SOQL Error Message

My Big Object Data Model

  • 1
    Can you check FLS of those fields ? – Mohith Shrivastava Apr 11 '19 at 2:56
  • 1
    @MohithShrivastava Thanks, I found I forget edit the FLS for those fields, now I can query those fields in SOQL. – Zas Apr 11 '19 at 3:09
  • Added as an answer to help others – Mohith Shrivastava Apr 11 '19 at 3:16

The issue here is your system admin profiles do not have the field level security as read for those fields .

Check your system administrator profile and Mark these fields with read permission at least to use in soql .

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.