Snowflake Task Status, To get those queries, a JOIN with QUERY_HISTORY view is required.