SQL Smarts

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

Design Patterns

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, 4 yearsMarch 23, 2019 ago
Recent Posts
  • Associative Grouping using Spark (Part 3)
  • Introducing AzureDataPipelineTools
  • Azure Data Factory: Dev Mode vs Published Code
  • Azure DevOps: SqlPackage Deployment Timeouts
  • Azure Data Factory: Making Non-Dynamic Linked Services Dynamic
Tags
ADFv2 (4) ADLSv2 (1) Associative Grouping (3) Azure (4) Azure Data Lake (1) AzureDataPipelineTools (1) Azure Devops (2) Azure Functions (1) Certificates (1) CTE (1) Databricks (1) Data Cleansing (3) Data Factory (4) Design Patterns (1) Graph DB (1) Security (1) Signing (1) Spark (1) tSQL (4) vNext (1)
  • Blog
  • About Niall
  • Talks & Events
  • LinkedIn
  • Twitter
Hestia | Developed by ThemeIsle