What monitoring costs in your warehouse

SELECT
  DATE_TRUNC('day', start_time) AS day,
  warehouse_name,
  TRY_PARSE_JSON(query_tag):task::string AS task,
  COUNT(*) AS queries,
  ROUND(SUM(total_elapsed_time) / 1000 / 60, 1) AS elapsed_minutes
FROM snowflake.account_usage.query_history
WHERE start_time >= DATEADD('day', -7, CURRENT_TIMESTAMP())
  AND query_text ILIKE '%"app":"synq"%'
GROUP BY 1, 2, 3
ORDER BY 1, 2, 3;

SELECT
  DATE_TRUNC('day', start_time) AS day,
  SUM(credits_used) AS credits
FROM snowflake.account_usage.warehouse_metering_history
WHERE warehouse_name = 'SYNQ_WH'
  AND start_time >= DATEADD('day', -7, CURRENT_TIMESTAMP())
GROUP BY 1
ORDER BY 1;