---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/guide/dc-sql-query-apis.md
cuppy_section: docs
cuppy_doc: VCP5-7DMM
cuppy_doc_uuid: f1d418b0-60b5-46b8-8d71-3538c98459d8
cuppy_permalink: https://cuppy.io/salesforce/d/VCP5-7DMM
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/guide/dc-sql-query-apis
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: 43aa30ea1c30237f1f19951dccbf6037e4eb03be876a1e79d4ed567602c1f94c
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/guide/dc-sql-query-apis.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.

## Data 360 SQL Query APIs

Use Data 360 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 360 data using Data 360 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 360 SQL**: Enhanced SQL features specific to Data 360 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 external client 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**

*   [Query Guide Decision Tree](https://developer.salesforce.com/docs/data/data-cloud-query-guide/guide/query-guide-get-started.html): Choose the right data retrieval method
*   [Query Data with the Query API](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/data-cloud-query-api-reference/c360a-api-queryservices-overview.html) - Direct API v3 endpoints with ASYNC and ADAPTIVE modes
*   [Object-Specific APIs](https://developer.salesforce.com/docs/data/data-cloud-query-guide/guide/obj-specific-apis.html): Alternatives for targeted data access
*   [Language-Specific Libraries](https://developer.salesforce.com/docs/data/data-cloud-query-guide/guide/lang-specific-libraries.html): Client library options
*   _Salesforce Help_: [Data 360 Limits and Guidelines](https://help.salesforce.com/s/articleView?id=data.c360_a_limits_and_guidelines.htm&type=5)
*   [_Salesforce Developers Blog:_ Boost Data 360 Integrations with the New Query Connect API](https://developer.salesforce.com/blogs/2025/08/boost-data-cloud-integrations-with-the-new-query-connect-api)


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->