| title | titleSuffix | description | author | ms.author | ms.service | ms.subservice | ms.custom | ms.topic | ms.date |
|---|---|---|---|---|---|---|---|---|---|
Cached lookup functions in the mapping data flow |
Azure Data Factory & Azure Synapse |
Learn about cached lookup functions in mapping data flow. |
kromerm |
makromer |
data-factory |
data-flows |
synapse |
conceptual |
02/02/2022 |
[!INCLUDEappliesto-adf-asa-md]
[!INCLUDEdata-flow-preamble]
The following articles provide details about cached lookup functions supported by Azure Data Factory and Azure Synapse Analytics in mapping data flows.
The following functions are only available when using a cached lookup when you've included a cached sink.
| Cached lookup function | Task |
|---|---|
| lookup | Looks up the first row from the cached sink using the specified keys that match the keys from the cached sink. |
| mlookup | Looks up the all matching rows from the cached sink 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.