Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
APPLIES TO: 
Azure Data Factory
Azure Synapse Analytics
Tip
Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!
Data flows are available in both Azure Data Factory pipelines and Azure Synapse Analytics pipelines. This article applies to mapping data flows. If you're new to transformations, refer to the introductory article Transform data using mapping data flows.
This article provides details about cached lookup functions supported by Azure Data Factory and Azure Synapse Analytics in mapping data flows.
Cached lookup function list
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. |
Related content
- 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.