gmitter-ef commented on issue #5182: URL: https://github.com/apache/hop/issues/5182#issuecomment-2820186151
Hi! Some reasons why we used SQL files as outsourced files: * during development a proper source code editor / IDE can be used to do refactorings, renamings, alignments and the like * the SQL queries have to be adapted by consultants (WHERE conditions, hard-coded constants, additional conditions,...) at the customer's site as part of configuration tasks; we do not want them to edit the XMLs of the pipelines and we do not want them to need HOP to be able to adapt the queries * version control of the SQL files separately from the pipelines can prove handy > How do you solve the initialization of the variable during pipeline development? You will still have to copy and paste the query in the default variable during development, otherwise, you have no metadata from the table input. Do you mean the variable that contains the whole query or the variables that are used by the query? Yes, this issue is problematic. For the variable that contains the query, yes, copy-and-pasting is needed, or setting the content of the query as parameter (without newlines). But exactly this problem I think could be solved by allowing to read directly from file? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
