--- cuppy_hub: salesforce cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/result-scan.md cuppy_section: docs cuppy_doc: H390-EW5X cuppy_doc_uuid: c8b38ec9-2dae-48ee-a898-1839162aba21 cuppy_permalink: https://cuppy.io/salesforce/d/H390-EW5X 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/references/dc-sql-reference/result-scan cuppy_mcp: https://cuppy.io/mcp cuppy_body_sha256: 3fcc47e1b50fc9a71d51cd5bcc866efd52efba717e0d65479d3d119979191477 # cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks. --- > Mirror of (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. ## `result_scan` **Applies to:** ✅ Data 360 SQL Returns the result set of a completed query as a table. Use `result_scan` in the `FROM` clause to query cached results without rerunning the original query. * ``: The query identifier returned by the Data 360 Query API when the source query was submitted. Pass it as a string literal. You can’t use a column reference or a computed expression. Returns a set of rows whose column names and data types match the result set of the referenced query. Use it anywhere a table reference is valid in a `FROM` clause. `result_scan` is a set-returning function that must appear in the `FROM` clause, not in a `SELECT` list or `WHERE` clause. * The referenced query must complete successfully and produce a result set before you can call `result_scan` against it. Queries that are still running, have failed, don’t exist, or return no rows result in an error. * When you submit a query using the [Data 360 Query API](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/data-cloud-query-api-reference/c360a-api-queryservices-overview.html), store the returned `queryId` and pass it to subsequent `result_scan` calls. A single query can contain multiple calls referencing the same or different IDs. * Rows returned by `result_scan` might not match the order of the original query. Use an explicit `ORDER BY` clause if sorting matters. * Data 360 retains query results for up to 24 hours, though they may become unavailable sooner due to cache eviction. If results expire or are evicted, resubmit the original query to regenerate the result set. * You can only scan results from queries that you submitted within your current data space. Referencing a query issued by another user or running in a different data space returns an error. | SQLSTATE | Condition | Message | | --- | --- | --- | | 42704 | Query ID not found, not yours, not finished, or expired | `The result of the query '' cannot be scanned. Either the query id does not exist, the query was issued by another user, the query execution has not finished yet or the result expired.` | | 42704 | Query still running | `The result of the query '' cannot be scanned. The query execution has not finished yet.` | | 22023 | Source query produced no result set | `The query '' did not produce a result.` | Because `result_scan` returns the schema of the source query, expected output depends on your data. The examples below show query structure only. Submit an initial query and store the returned `queryId`. Use `result_scan` to aggregate the cached results without rerunning the source query. Pass the `queryId` value (for example, `'3442db1a-ecef-42b3-b0d8-971ee459efa4'`) returned by the Data 360 Query API. Filter results from a completed query without rescanning the source table. Reference two different cached result sets in a single query. * [Query Data Using the Data 360 Query API](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/data-cloud-query-api-reference/c360a-api-queryservices-overview.html) * [Set Returning Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/set-returning-functions.html) * [`FROM` Clause](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/select-from.html) --- 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.