Snowflake, Sql, Performance, Data Science, Data Engineering.
compilation_time, execution_time , queued_provisioning_time, query_tag , regexp_substr(query_text, '--Query(..)', 1,1,'',1)::int qid , iff(qid < lag(qid) over(order by start_time) ,1,0) is_session_start from table(information_schema.query_history(result_limit=>1000)) where bytes_scanned > 1000 and