Recently my colleague Felipe Hoffa told me about a new public dataset in BigQuery: ALL THE PUBLIC GITHUB CODE! Counting Go filesAs a gopher, my first reaction was to check how many Go files are in that dataset. My SQL is not amazing, but I’m able to do that! SELECT COUNT(*) FROM [bigquery-public-data:github_repos.files] WHERE RIGHT(path, 3) = ‘.go’Running that query I see that there are more than
![Analyzing Go code with BigQuery](https://cdn-ak-scissors.b.st-hatena.com/image/square/d3072a14c26972e4d7a7e4b5e69e138da278b9db/height=288;version=1;width=512/https%3A%2F%2Fmiro.medium.com%2Fv2%2Fresize%3Afit%3A912%2F1%2Ak2UnTLij6qBR6kYhPuD8fw.png)