Data Cloud SQL Query APIs

Use Data Cloud Query APIs with custom SQL for complex queries that don't have an object-specific API or a supported language library. Query APIs provide the most flexible way to access your Data Cloud data using Data Cloud SQL syntax.

Query APIs are ideal when you need to:

  • Execute complex SQL queries across multiple data model objects (DMOs) and data lake objects (DLOs)
  • Perform advanced joins, aggregations, and data transformations
  • Extract large volumes of data for analytics or reporting
  • Build custom applications that require flexible data access
  • Query data that doesn't have a dedicated object-specific API
  • Build custom applications in a language without supported libraries
  • Data Cloud SQL: Enhanced SQL features specific to Data Cloud objects
  • Complex Operations: Joins, subqueries, window functions, and aggregations
  • Asynchronous Execution: Handle long-running queries without blocking
  • Pagination: Process large result sets efficiently
  • Query Optimization: Automatic optimization for Data Cloud architecture
  • REST Endpoints: Connect REST API calls
  • Apex Integration: Native support in Salesforce Apex code
  • Multiple Data Sources: Query across unified, engagement, and profile data

Before using Query APIs, ensure you have:

  1. Data Cloud License: Active Data Cloud licenses provisioned for your org
  2. User Permissions: Appropriate roles and permissions assigned
  3. Authentication Setup: Valid access tokens and connected app configuration
  4. Data Model Knowledge: Understanding of your Data Cloud object schema
  1. Set Up Authentication: Configure OAuth or Data Cloud authentication
  2. Explore Your Data: Use the Metadata API to understand available objects
  3. Write Your First Query: Start with simple SELECT statements
  4. Handle Results: Implement pagination and error handling

See Also