select warehouse_event_id

from bi_analytics.compass_prod.usage_events

where user_id = 'cm0waem2n4s0lof0iwpdmzvwe'

and created_at::date between '2024-10-01' and '2024-10-31'

),

sf_queries as (

select query_text,

total_elapsed_time/1000 as query_seconds,

warehouse_name,

from snowflake.account_usage.query_history q

join user_queries p on p.warehouse_event_id = q.query_id

where start_time::date between '2024-10-01' and '2024-10-31'

)

select query_text,

warehouse_name,

count(1) as total_runs,

sum(query_seconds) as total_seconds,

sum(query_seconds)/count(1) as avg_seconds_per_run

from sf_queries

group by 1,2

order by 4 desc