SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ11

Implement Data Protection and Recovery

A Data Engineer ran a stored procedure that contained various transactions. While it was executing, the session abruptly disconnected, preventing one transaction from committing or rolling back. The transaction remained in a detached state and placed a lock on resources.

What must the Engineer do to immediately run a new transaction?

Explanation

A detached explicit transaction that holds locks must be aborted with SYSTEM$ABORT_TRANSACTION. Snowflake specifies this function for aborting a running transaction after an abrupt session disconnect, which clears the transaction’s locks and allows the blocked work to proceed.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!