Forum Discussion

erkonline's avatar
erkonline
New Contributor
5 years ago

Is there any way to set variables to before executing snowflake statement

I would like to execute the 2 set variable statements before executing the select * from viewname. This view internally uses VAR1 and VAR2 variables. set VAR1 = ‘ABC’; set VAR2 = ‘XYZ’; Select...
RogerSramkoski's avatar
RogerSramkoski
Employee
2 years ago

Hello mkadange! Can you tell us a little more about the pipeline you have so far? And when you say force success, do you mean returning an HTTP200 to an external API call to the pipeline or showing success in the SnapLogic Dashboard? 

mkadange's avatar
mkadange
New Contributor
2 years ago

Hello Roger,

Thanks for responding to my question. I have a pipeline that reads an input file and does some sort data massaging and produces an output file. The issue that I am facing is, when there is no file to process, the pipeline should not error out and instead should simply run to success and do nothing, as the pipeline will be scheduled to run on a daily basis and there will not be files on all days.

Thanks so much for your help.