Query Data in Data Cloud

Salesforce Data Cloud enables you to collect, store, and process data from various sources, including Salesforce clouds and external systems. After harmonizing and unifying your data, you can create metrics that span all data sources, providing comprehensive insights. To extract valuable insights from your Data Cloud data, you can query it using various methods, including integrated apps, object-specific APIs, client libraries, and Data Cloud query APIs. This guide focuses on how to retrieve data from Data Cloud.

This diagram shows a decision flow for the recommended data retrieval methods to use based on your needs.

Decision flow for querying data cloud data

To help you choose the most suitable data retrieval method based on your specific needs, consider the following:

  • If you want to explore and query data using a visual interface, consider using integrated apps. For more information, see Integrated Apps that Connect to Data Cloud.
  • For efficient object-oriented queries, leverage the object-specific APIs, such as the Data Cloud Connect REST API or the Data Cloud API. See Data Cloud Object-Specific APIs for details.
  • To seamlessly integrate your applications with Data Cloud data, consider using a language-specific client library. The available libraries include JDBC, Python, and the Connect API for Apex. For more information, see Language-Specific Client Libraries.
  • To query Data Cloud data using custom SQL queries, you can use the Data Cloud Connect API (REST API and Apex) or the Data Cloud API. See Data Cloud SQL Query APIs for more information.

This guide does not cover retrieving or configuring metadata. For information about managing Data Cloud metadata, refer to the Data Cloud Developer Guide.

Calculated insight and data transformation creation use a different SQL dialect than described in this guide. See Calculated Insights and Streaming Data Transforms in Salesforce Help for more information about the different SQL dialect.

See Also