https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-custom-property-file-or-registry-variable/m-p/238220#M85361 <P>Hi </P><P>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? </P><P>Thanks in advance.</P> Wed, 05 Dec 2018 15:49:20 GMT pallavbvb 2018-12-05T15:49:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-custom-property-file-or-registry-variable/m-p/238220#M85361 <P>Hi </P><P>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? </P><P>Thanks in advance.</P> Wed, 05 Dec 2018 15:49:20 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-custom-property-file-or-registry-variable/m-p/238220#M85361 pallavbvb 2018-12-05T15:49:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-custom-property-file-or-registry-variable/m-p/238221#M85362 <A rel="user" href="https://community.cloudera.com/users/80163/pallavbvb.html" nodeid="80163">@Pallavkumar</A><P>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. </P> Wed, 05 Dec 2018 18:22:27 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-custom-property-file-or-registry-variable/m-p/238221#M85362 sohil2027 2018-12-05T18:22:27Z