I’m looking to make a pipeline fragment where the query to be run will be passed in as a pipeline fragment parameter.
It looks like it is not possible specify the SQL Query section as something like ${query} since these values get sanitized. You can only do something like SELECT * FROM TABLE WHERE ID=${id_param}.
Is it possible to set a value in an expression evaluator like
/query=”SELECT * FROM DUAL”
and have it run by referencing the /query variable on the record?
In data collector we can’t pass the sql query as parameter but you can create a metadata table and keep your select queries in it and use it where ever you need it. I hope it helps.
Thanks for the help! When you say create a metadata table, can you give an example of what you mean? Would this be a table in my database or a streamsets object?
The metadata table should be in DB where we can put our select query in it and use the same in staremsets .
Thanks & Regards
Bikram_
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.