Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/guide/dc-soql.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

Using the Salesforce Object Query Language (SOQL) to Query Data in Data 360

Similar to how you use SOQL to query Salesforce objects, you can also use SOQL to query Data 360 objects, such as DLOs and DMOs, with some limitations. SOQL is Salesforce’s proprietary query language to query Salesforce objects. You can run SOQL in Apex or by using tools such as the Query Editor and SOQL Builder.

To learn about querying DMOs in Apex with SOQL, see Data 360 in Apex in the _Apex Developer Guide_. Also see Mock SOQL Tests for Data 360 Data Model Objects in the _Apex Developer Guide_.

SOQL is similar to SQL, but here are a few differences between the two.

SOQL statements can execute in Apex on the Salesforce Platform, and not only using an API.
SOQL doesn’t support the asterisk (*) character to retrieve all fields in the SELECT statement. To retrieve all fields, use the FIELDS(ALL) keyword or retrieve specific fields.
SOQL provides parent and child relationships instead of JOIN statements. These relationships aren’t supported in the current implementation of SOQL in Data 360.

For the SOQL language reference, see _Salesforce Object Query Language (SOQL)_. To learn about the use of SOQL in general with Salesforce objects, see the _SOQL for Admins_ Trailhead module.

See Also