Connect GitHub to Looker: An Easy to Follow Guide

Introduction

Integrating GitHub with Looker enables organizations to gain powerful insights into their development workflows, project management, and code repositories. By connecting GitHub data to Looker, teams can create customized dashboards and reports that provide a clear view of code changes, pull requests, issue tracking, and team performance. This integration empowers engineering and management teams to track key metrics, analyze trends, and make data-driven decisions, all from within Looker’s analytics platform. With real-time data visualization, organizations can improve transparency and collaboration across development projects.

Connecting GitHub to Looker

1. From Looker Dashboard, click on Develop and go to your project. 
2. Click Configure GIT and select GitHub.
3. Create a new repo on GitHub, and save its address URL. 
4. Inside Looker , put this URL of your repository, in the “repository URL” text box. 
5. Once Looker knows where to fetch from, you will have to specify your Looker “deploy key string” into GitHub, allow “Write access” and then add the key. 
6. Looker can then read and write into the GitHub repo. 
7. You can validate your LookML and commit it to the repo in production. 

Some of your Github commands will also be available in the Looker dashboard.

The above procedure suffices when you make a new Git repo for your Looker project. More often than not, you would need to connect your existing repos to your Looker projects OR allow multiple developers to commit LookML in your repos.
Next, we discuss how to use existing repos and allow multiple/single developer access. 

Single or Multiple Accounts

You can either have a single teamwide account, and all your developers can use that to commit to the repo. Looker will use this account to log into Git and make changes on behalf of the developers. Of course, this single user account must have read+write privileges on GitHub. Here, each individual developer’s Looker username is used to identify the committer on GitHub.

The other option is to let each developer use his individual account to commit changes on Git, and use one generic team-wide account to enable Looker to monitor changes as well as to pull the production version of files. Each individual developer account thus has both read+write access to the Git repo, whereas the single generic team-wide account should at least have read access. Here, the Looker admin has to set up each individual developer account, making sure to hide the password or access token attribute. 

Improve your project management by exploring GitHub and Asana integration. Learn how syncing these tools can streamline your development and task tracking.

HTTPS or SSH Access

Looker provides two methods to access your related Git repo, you can either use HTTPS or SSH. 

For HTTPS access:

1. Go to your project settings and click “configure GIT” ( for creating a new Git project) or “Reset GIT connection”( edit existing projects).
2. Then go to your GIT repo, and copy the HTTPS (not SSH) URL for your Git repo.
3. If you want to connect an existing repo, this URL can also be copied from the “Clone or Download” link, on the “Code” page of your Git repo. 
4. Paste this URL into the “configure GIT” dialogue in your Looker settings. 
5. Next, depending on whether you are using the “Single account” option or “Multiple accounts”, specify the credentials Looker will use for accessing the repo. 
6. If you are using a single team-wide account, choose the “Use a single, constant username and password combination”  radio. 
7. Then specify the single account you want all your developers to share for all your commits. Else choose the “Use user attributes for username and password” radio button. 
8. . First specify that single generic team-wide account with at least read access, that Looker will use to pull the production version. 
9. Next, click the “Use user attributes for username and password” and specify the credentials for each individual developer account. 

10. Once setup is done, Looker allows you to use GIT commands from inside Looker, via the Git menu, on the top left. 

For SSH access:

1. To use SSH instead, copy the SSH ( not HTTPS) URL of your GitHub repo. 
2. Paste this URL into the “configure GIT” or “Reset GIT connection” dialogue in your Looker settings. 
3. Next, Looker will automatically detect your GIT provider and generate an SSH-RSA deploy key, copy this key. 
4. Go to your repo’s settings, click the “Add Deploy Key” button, and Paste it in your repo. 
5. Give it a suitable name, in future, you might be working on multiple Looker projects committing on different Git repos; thus, giving a meaningful name here will help in isolating the correct repo later. 
6. Finally, select the “Allow write access” option, this will give write access to Looker, on your repo. 
7. After clicking “Test and Finalize setup”, you must be ready for committing your LookerML code in your designated Git repo. 

Happy coding!

Conclusion

To conclude, this article tries to discuss how to connect your GIT repo to your Looker instance, to commit your LookML code. These methods, however, can be challenging especially for a beginner & this is where Hevo saves the day.

Find out how to connect Power BI to GitHub effectively. Our resource provides clear instructions for setting up the connector and optimizing your data analysis.

Frequently Asked Questions