Use this pipeline step to pull back a file's or table's content, or whatever a query or stored procedure produces, so that subsequent steps can work with it. Results are limited to 5,000 rows or 4 MB.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Lookup activity in context, with comparison tables and the common traps.
Terms in this definition
- Pipeline step
The smallest building block of a job in Azure Pipelines, either a task or a script. A job's steps run one after another on a single agent.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- Stored procedure
SQL code saved under a name inside the database and executed when called, frequently taking parameters so the same logic serves many rows. It keeps that logic in the data tier.