GitHubArchive | GitHub Archive Newsletters | Awesome List library

I'm looking at the public GitHub events dataset githubarchive.day.YYYYMMDD to pull public events that belong to me.

For this I use a simple query like:

I need to get the size statistics for the files in the github open source repository. For example, the number of files less than 1M is XXX or 70% of the total files.

I found that the files in [bigquery-public-data.github_repos.contents] are all less than 1M(though I don't know why). So I decided to choose [githubarchive:month.202005] or other month.

But I didn't find the "file size" field in [githubarchive:month.202005].So I would like to ask how to query the size of the file in [githubarchive:month.202005]? Then I can use the method in this to get the results by size??

I am new to bigquery, and the question may be silly. But I really need a solution. Or have statistics or literature that I can cite, which has the size statistics for files on github. [bigquery-public-data.github_repos.contents] does not mention why only files less than 1M were selected.

i'm trying to download gz file locally from githubarchive with httpclient in php. When i execute a wget in terminal, the gz is extracted and each folders are downloaded on my computer. When i do the same in php code, i encounter a 404 each time.

Bellow, my code :

I want to get the list of the repo with the most amount stars using BigQuery. I wrote a query but I am not sure about the result :

Have this BigQuery

Trying out the example below:

https://cloud.google.com/blog/big-data/2017/07/how-to-aggregate-data-for-bigquery-using-apache-airflow

While running one of the commands:

I am trying to get various Github repo metrics in Github Archive through Big Query(doc here). However, when I try to count the number of forks, the number I am getting is very different from the number of forks specified in the Github UI. For instance when I run this sql script:

I pretty new to Google BigQuery and only mildly comfortable with SQL and I was wonder if you guys could help me reformat my SQL statement maybe to reduce my usage? Because with my current set-up I encounter this error:

Error: Quota exceeded: Your project exceeded quota for free query bytes scanned. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors

My query is as follows:

My goal is to query across multiple tables of a dataset using BigQuery standard SQL syntax.

I can successfully make it work when all tables of a dataset follow the same number pattern. However, for datasets that contain additional tables like .yesterday, I get an error: Views cannot be queried through prefix. Matched views are: githubarchive:day.yesterday

Here is the query I used: