SQL Smarts

  • Blog
  •  About Niall
  • Talks & Events
  • LinkedIn
  • Twitter

ADFv2

Azure Data Factory

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. This allows us to either use the lookup as a Read more…

By Niall, 2 years2 years ago
Recent Posts
  • Associative Grouping using tSQL (Part 2)
  • Associative Grouping using tSQL (Part 1)
  • Azure Data Factory Lookup: First Row Only & Empty Result Sets
  • Signing Stored Procedures for Server Level Permissions
Tags
ADFv2 (1) Azure (1) Certificates (1) CTE (1) Data Cleansing (2) Data Factory (1) Design Patterns (1) Graph DB (1) Security (1) Signing (1) tSQL (3) vNext (1)
  • Blog
  • About Niall
  • Talks & Events
  • LinkedIn
  • Twitter
Hestia | Developed by ThemeIsle