---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/lambda-expressions.md
cuppy_section: docs
cuppy_doc: DA42-VJDG
cuppy_doc_uuid: 023cc845-c2e0-4594-924c-279c4a85811c
cuppy_permalink: https://cuppy.io/salesforce/d/DA42-VJDG
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/lambda-expressions
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: 8be65af6caee360c94b1314d56f69deccaefd23bd39ab905074cb0ea7ba5ad05
# 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/references/dc-sql-reference/lambda-expressions.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.

## Lambda Expressions

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Lambda expressions are anonymous functions you pass as arguments to higher-order functions such as `ARRAY_TRANSFORM` and `ARRAY_FILTER`. They enable element-wise operations on arrays without writing separate function definitions.

*   `<param1>, <param2>, ...`: One or more parameter names that represent the elements from the input arrays. The number of parameters must match the number of array arguments passed to the function.
*   `<expression>`: Any valid SQL expression that uses the parameters. The expression is evaluated once for each element (or tuple of elements) in the input arrays.

*   Lambda expressions can only be used as arguments to functions that accept them, such as `ARRAY_TRANSFORM` and `ARRAY_FILTER`.
*   The parameter names are local to the lambda and don’t conflict with column names in the outer query.
*   Lambda expressions can’t reference columns or variables from the outer query scope.
*   The return type of the lambda expression is inferred from the expression. If the expression returns only NULL, you must cast it to a specific type.
*   Data 360 uses the Python / DuckDB-style lambda syntax (`lambda x: expr`), not the Spark / Snowflake-style arrow syntax (`x -> expr`).

Use a single parameter when operating on one array.

Returns `[2, 4, 6]`.

Use multiple parameters when operating on multiple arrays in parallel.

Returns `[11, 22, 33]`.

Use CASE expressions within lambdas for conditional transformations.

Returns `[4, 5, 6]`.

Return a boolean expression to filter array elements.

Returns `[2, 4, 6]`.

Lambdas work with any data type.

Returns `["HELLO!", "WORLD?"]`.

*   [ARRAY_TRANSFORM](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-transform.html)
*   [ARRAY_FILTER](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-filter.html)
*   [Array Data Type](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array.html)


---
<!-- 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 -->