Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

NiFi : SQL - access first column in "Maximum-value Columns" field

NiFi : SQL - access first column in "Maximum-value Columns" field

New Contributor



In my SQL database, the ID is always the first column in every table. However, the name depends of the table and is never the same. As I would like to automate the process (1000+ tables), I would like to be able to define the first column in the "Maximum-value Columns" field of GenerateTableFetch.


The desired flow is:

ListDatabasesTables --> GenerateTableFetch where "Maximum-value Columns" is the first column of the table.




Don't have an account?
Coming from Hortonworks? Activate your account here