Last active
August 29, 2015 14:08
-
-
Save ferryzhou/aba576ee1af0e8b13ad6 to your computer and use it in GitHub Desktop.
get github repo details from bigquery
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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