Exercise 11 (Optional): Access Data Cloud with SOQL

In this exercise, you’ll access Data Cloud data using SOQL.

1. Using the App Launcher, open the Code Builder application.

2. Click Launch (this will take a few minutes to open).

3. Right-click the scripts>soql folder and create a New File called individual.soql.

   

4. In the individual.soql editor window, create a query to return Individual Id, First Name, Last Name, Birth Date, and Data Source Id, where Last Name is equal to Rodriguez.

   SELECT ssot__Id__c,
          ssot__FirstName__c,
          ssot__LastName__c,
          ssot__BirthDate__c,
          ssot__DataSourceId__c
   FROM ssot__Individual__dlm
   WHERE ssot__LastName__c = 'Rodriguez'
   LIMIT 100

5. Highlight the query, then open the command palette (Cmd+Shift+P Mac or Ctrl+Shift+P Windows) and select SFDX: Execute SOQL Query with Currently Selected Text.

   You should now see a single record: the consolidated profile created by the identity resolution process.

6. Modify the query as follows:

   SELECT ssot__Id__c,
         ssot__FirstName__c,
         ssot__LastName__c,
         ssot__BirthDate__c
   FROM UnifiedssotIndividualCcid__dlm
   WHERE ssot__LastName__c = 'Rodriguez'
   LIMIT 100

7. Run the query again.

   You should now see a single record: the consolidated profile created by the identity resolution process.