Skip to content

Instantly share code, notes, and snippets.

@yaph

yaph/search-gh-user-commits.bq

Created May 22, 2013 15:24
Show Gist options
  • Save yaph/d8d051b0b421649dae97 to your computer and use it in GitHub Desktop.
Save yaph/d8d051b0b421649dae97 to your computer and use it in GitHub Desktop.
Download ZIP
Sample query to search for SEARCH in the public commit timeline of GITHUB_LOGIN using the GitHub Archive dataset on Google's Big Query service.
Raw
search-gh-user-commits.bq
SELECT actor, payload_commit_msg, repository_language FROM [publicdata:samples.github_timeline]
WHERE actor == 'GITHUB_LOGIN' AND payload_commit_msg != ''
AND REGEXP_MATCH(payload_commit_msg, r'(?i)SEARCH')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment