Skip to content

Extracted the top 100 repo with highest star and keeps them in BigQuery, visualized through Looker.

Notifications You must be signed in to change notification settings

rohan472000/Github-repo-extraction-GCP

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

40 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Github-repo-extraction-GCP

Extracted the top 100 repo with highest stars and keeps into BigQuery, extracted different attributes like number of stars,name of repo, language used, date of creation and visualized through Looker.

Visualization: Language used in repo, JS is used in most repos.

Screenshot (93)

2nd color has no name because in many repos the data fetched for language used is empty/null. We can update that null by any name using below command :-

  UPDATE `project.dataset.table`
  SET language = 'xyz'
  WHERE language IS NULL

-- in above code, language is a column name.

You can follow below link for the Blog which will give more explanation of this project.

https://rohan-anand.hashnode.dev/github-the-place-where-we-fork

Contributing

Contributions to this repository are welcome. If you find a bug or have a suggestion for improvement, please open an issue or submit a pull request.