| Query ID ↕ | Database ↕ | User ↕ | Status ↕ | Duration ↕ | Query |
|---|
Snowflake does not expose a queryable "session A blocks session B" relationship the way
row-lock engines do, so this lists blocked/queued queries individually rather than as a blocking tree.
For a specific stuck table, SHOW LOCKS IN TABLE <name> can show its
current lock holder. Query: INFORMATION_SCHEMA.QUERY_HISTORY