NiFi custom property file or registry variable

[#1]

Hi

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.

[#2 · Accepted solution]

@Pallavkumar

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.