I have a SQL query being used in multiple ExecuteSQL processor. Currently using both custom property file as well as registry variable to store SQL query. Which option is better to proceed with? Is there any other approach than these two?
Thanks in advance.
Registry would be a better option if your query keeps changing because changes in property files need NiFi to be restarted in order to reflect.
View solution in original post