Forum Discussion

sainig's avatar
sainig
New Contributor
2 years ago

ELT Execute query execution flow

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

  • nkanala's avatar
    nkanala
    Employee
    2 years ago

    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