We have created few pipeline where we are using ELT execute to run multiple DML queries to Snowflake. Our initial assumption was that if we give multiple queries in the ELT execute snap , they will run one by one and will be queued until previous query execution is completed . is that assumption correct or do they run in parallel ?
@stewartbulloch yes it would be in the jcc.bat file but it’s a bit more complicated.
In that file you will see a line like:
%CYGRUNSRV% -I %SERVICE_NAME% -1 %SNAPLEX_LOG% -2 %SNAPLEX_ERR% -d %SERVICE_DISPLAY% -p %JAVA_EXE% -c %SNAP_HOME% -f "SnapLogic Snaplex (Java)" -a '%START_OPTIONS%' -o -V -e 'SL_ROOT=%SL_ROOT%' -e 'PATH=%PATH%' -e 'JAVA_HOME=%JAVA_HOME%'
I believe here you can add a new -e 'http_proxy=VALUE'/'https_proxy=VALUE' pair and, after the service is reinstalled with jcc.bat install_service; jcc.bat start, the environment variable should be available now in the Windows environment.
If indeed http_proxy (and its HTTPS equivalent) is the environment variable a certain Windows utility uses for proxy configuration, then it should work.
I’m less familiar with Windows OS though for this use case so I’d be interested to hear from anyone if this worked for them.
