Skip to content

Instantly share code, notes, and snippets.

@ferryzhou

ferryzhou/github_repos_bigquery.sql

Last active August 29, 2015 14:08
Show Gist options
  • Save ferryzhou/aba576ee1af0e8b13ad6 to your computer and use it in GitHub Desktop.
Save ferryzhou/aba576ee1af0e8b13ad6 to your computer and use it in GitHub Desktop.
Download ZIP
get github repo details from bigquery
Raw
github_repos_bigquery.sql
select repository_url, repository_language, repository_created_at, repository_description, MAX(repository_watchers) as watches
from [githubarchive:github.timeline]
where repository_watchers > 20
group each by repository_url, repository_language, repository_created_at, repository_description
order by watches desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment