Cached lookup functions in mapping data flow

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 both in Azure Data Factory and Azure Synapse Pipelines. This article applies to mapping data flows. If you are new to transformations, please refer to the introductory article Transform data using a mapping data flow.

The following articles provide 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 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

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.