Lookup Activity in ADF and Synapse | Read Content of File, query Tables in DB | #cloudknowledge

Lookup Activity in ADF and Synapse | Read Content of File, query Tables in DB | #cloudknowledge Lookup activity can retrieve a dataset from any of the data sources supported by data factory and Synapse pipelines. You can use it to dynamically determine which objects to operate on in a subsequent activity, instead of hard coding the object name. Some object examples are files and tables. Lookup activity reads and returns the content of a configuration file or table. It also returns the result of executing a query or stored procedure. The output can be a singleton value or an array of attributes, which can be consumed in a subsequent copy, transformation, or control flow activities like ForEach activity. Supported capabilities Note the following: The Lookup activity can return up to 5000 rows; if the result set contains more records, the first 5000 rows will be returned. The Lookup activity output supports up to 4 MB in size, activity will fail if the size exceeds the limit. The longest duration for Lookup activity before timeout is 24 hours. #education #azuredatafactory #azuresynapse #learning #azuretutorials #synapseanalytics #datafactory