Snowflake Common Command Reference

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

• Snowflake: General Reference