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
SHOW TRANSACTIONS [ 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).
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 Information Schema.