SHOW TRANSACTIONS¶

List all running transactions. The command can be used to show transactions for the current user or all users in the account.

See also:

SHOW LOCKS

Syntax¶

SHOW TRANSACTIONS [ IN ACCOUNT ]
Copy

Parameters¶

IN ACCOUNT

Shows all transactions across all users in the account. It can only be used by users with the ACCOUNTADMIN role (i.e. account administrators).

Usage Notes¶

  • Columns that start with the prefix is_ return either Y (yes) or N (no).

  • The command does not require a running warehouse to execute.

  • The command returns a maximum of 10K records for the specified object type, as dictated by the access privileges for the role used to execute the command; any records above the 10K limit are not returned, even with a filter applied.

    To view results for which more than 10K records exist, query the corresponding view (if one exists) in the Snowflake Information Schema.

  • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

  • The command output includes the IDs for all running transactions. These IDs can be used as input for SYSTEM$ABORT_TRANSACTION to abort a specified transaction.

Language: English