Ask Your Question

Error while running pipeline with run time parameters

asked 2018-09-23 22:52:28 -0500

jay1988 gravatar image

I have a run time parameter defined in pipeline as $query.I want to pass runtime parameter to this query using a cmd command.The run time query is like select * from table a where date > ‘2018-01-01’ and date <=‘2018-01-31’.But when we pass this query as run time parameters And run using the functionality of run the pipeline with parameters the quotes infront of date is not getting recognized and query is changing as select * from table a where date > 2018-01-01 and date <=2018-01-31.Our source is oracle and it is causing to fail.

edit retag flag offensive close merge delete


Any help on this problem is appreciated

jay1988 gravatar imagejay1988 ( 2018-09-24 14:19:14 -0500 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-09-24 15:49:00 -0500

iamontheinet gravatar image


This works for me:

image description

Where QUERY is defined as pipeline parameter.

image description

image description

Also note that starting the pipeline using curl with the same param works as well:

curl -u admin:admin -X POST -H "X-Requested-By:sdc" -H "Content-Type: application/json" -d "{\"QUERY\": \"select * from orders where order_date between '2013-07-25' and '2013-07-26' order by order_date\"}"

Cheers, Dash

edit flag offensive delete link more



Thanks.The solution worked for us.

jay1988 gravatar imagejay1988 ( 2018-09-24 19:31:13 -0500 )edit

Great and you're welcome!

iamontheinet gravatar imageiamontheinet ( 2018-09-25 13:03:09 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-23 22:52:28 -0500

Seen: 358 times

Last updated: Sep 24 '18