Data Factory Lookup activity supports a rich set of connectors

The Azure Data Factory Lookup activity now supports retrieving a dataset from any of 70+ ADF-supported data sources. You can use it in the scenario of dynamically determining which objects (files, tables, etc.) to operate on in a subsequent activity, instead of hard-coding the object name.

The Lookup activity can read and return the content of a configuration file, a configuration table, or the result of executing a query or stored procedure. The output from the Lookup activity can be used in a subsequent copy or transformation activity if it's a singleton value. Or it can be used in a ForEach activity if it's an array of attributes.

For more information, see the Lookup activity documentation.