| title | Cached Lookup Functions in the Mapping Data Flow |
|---|---|
| titleSuffix | Azure Data Factory & Azure Synapse |
| description | Learn about cached lookup functions in mapping data flows. |
| author | kromerm |
| ms.author | makromer |
| ms.subservice | data-flows |
| ms.custom | synapse |
| ms.topic | concept-article |
| ms.date | 01/05/2024 |
[!INCLUDEappliesto-adf-asa-md]
[!INCLUDEdata-flow-preamble]
This article provides details about cached lookup functions supported by Azure Data Factory and Azure Synapse Analytics in mapping data flows.
The following functions are available only if you use a cached lookup when you include a cache sink.
| Cached lookup function | Task |
|---|---|
| lookup | Looks up the first row from the cache sink by using the specified keys that match the keys from the cached sink. |
| mlookup | Looks up all the matching rows from the cache sink by using the specified keys that match the keys from the cached sink. |
| output | Returns the first row of the results of the cache sink. |
| outputs | Returns the entire output row set of the results of the cache sink. |
- List of all aggregate functions.
- List of all array functions.
- List of all conversion functions.
- List of all date and time functions.
- List of all expression functions.
- List of all map functions.
- List of all metafunctions.
- List of all window functions.
- Usage details of all data transformation expressions.
- Learn how to use Expression Builder.