Рет қаралды 4,461
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