DML

  • Show warehouse with filters
1
SHOW WAREHOUSES like '%testing%';
  • Show most recent query id
1
SELECT last_query_id()

If you want to retrieve the second most recent query id, you can also provide -2 argument and do something like

1
SELECT last_query_id(-2)

Reference