Queries

Daily Data Usage

This query returns total data usage across a workspace per day. It does not include query runs that were unsuccessful.

SELECT
  DATE(qr.started_at_utc) AS day,
  COALESCE(SUM(qr.bytes) / (1000 * 1000 * 1000), 0) AS data_usage_gb,
  COUNT(qr.id) AS successful_query_runs
FROM organization_usage.query_runs qr
WHERE qr.state = 'succeeded'
GROUP BY 1
ORDER BY 1 DESC
LIMIT 100