Snowflake, Sql, Performance, Data Science, Data Engineering.
following query to gather all the basic stats: create or replace table query_sessions2 as select *, sum(is_session_start) over(order by start_time) session_id from ( select query_id, query_text, query_type, warehouse_size, start_time, total_elapsed_time , bytes_scanned, rows_produced,