SQLLookupService provides a lookup service based on given lookup table key and incoming flow files. Each record from the flow file compares with the lookup key and returns the lookup column value for the matched record.


sql, lookup, key, value, table, record



Default Values

Allowable Values


Database connection service The Controller Service that is used to obtain a connection to the database in which the lookup table is available.
Table Name The name of the table to be used for lookup

Supports Expression Language: true

Lookup Value Column Column to be returned from lookup table for which the key and record matches.

Supports Expression Language: true

Lookup Key Column Column to be used as lookup key.

Supports Expression Language: true