cancel
Showing results for 
Search instead for 
Did you mean: 

ELT Execute query execution flow

sainig
New Contributor

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 ?

2 REPLIES 2

psathyanarayan
Employee

@sainig , your assumption is correct. They run serially.

nkanala
Employee

Yes, correct. They run sequentially. In case of a rollback, only the failed sql gets rollback and the snap doesn't do a multi-statement rollback.
Also refer to examples here