Azure Data Factory Lookup: First Row Only & Empty Result Sets
When using the lookup activity in Azure Data Factory V2 (ADFv2), we have the option to retrieve either a multiple rows into an array, or just the first row of the result set by ticking a box in the UI.
The 'First Row Only' Checkbox at the bottom This allows us to either use the lookup as a source when using the foreach activity, or to lookup some static or configuration data.
Posted by Niall's Data Blog on Saturday, March 23, 2019
