ELT Execute query execution flow

[sainig]

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 ?

[psathyanarayan]

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

[nkanala]

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