Query Data in Data Cloud
Data Cloud enables the collection, storage, and processing of data from Salesforce clouds and external data sources. After the data is harmonized and unified, aggregate metrics across all data sources can be created to provide comprehensive insights. To get value out of the rich data in Data Cloud, query the data using integrated apps, Data Cloud object-specific APIs, client libraries, and Data Cloud query APIs. This guide covers retrieving data out of Data Cloud. It doesn’t cover retrieving or configuring metadata.
Additional information about managing Data Cloud metadata is available in the Data Cloud Developer Guide.
This guide focuses on querying data in Data Cloud, including:
- Calculated insights
- Data graphs
- Unified individuals and accounts (Universal ID Lookup)
- Profiles
- Data Lake Objects (DLOs) and Data Model Objects (DMOs)
- Unstructured DLOs and DMOs that are available through vector search
The SQL dialect used for creating calculated insights and data transforms is different from the SQL dialect used for querying the data, including calculated insight data, in Data Cloud. See and Streaming Data Transforms in Salesforce Help. For more information about calculated insights and the SQL dialect they support, see Calculated Insights and Use ANSI SQL Statements in Data Cloud in Salesforce Help. For more information about data transforms and how they use SQL, see Streaming Data Transforms and Streaming Data Transform Functions and Operators in Salesforce Help.
See Also