This page walks through how to connect Secoda and Looker
There are three steps to connect Looker with Secoda:
- 1.Retrieve your Looker Client ID and Client Secret
- 2.Retrieve your Looker host
- 3.Connect Looker to Secoda
- 4.Looker Lineage (Optional)
Create API3 credentials on the Users page in the Admin section of your Looker instance. If you’re not a Looker admin, ask your Looker admin to create the API3 credentials for you.
To create an API3 credential, click Edit on a user and then under API3 Keys click Edit Keys.
Create a key, and then save the Client ID and Client Secret
Your host is the url of your Looker instance including the port. For example if your site is:
https://company.cloud.looker.comthe host is
Sometimes an admin will have specified a custom API url. If that's the case, reach out to your admin and ask them to provide that url.
After retrieving your Looker Client ID, Client Secret, and host , the next step is to connect to Secoda:
- 1.In the Secoda App, select Add Integration on the Integrations tab
- 2.Search for and select Looker
- 3.Enter your Looker Client ID, Client Secret, and host you retrieved above
- 4.Click 'Connect'
To get lineage between Looker and your data warehouse, Secoda will need access your GitHub repo where Looker records changes and manages file versions. Secoda will then automatically detect LookML projects connected to your Looker instance.
Navigate to the Git tab on the Looker Integration Page and you will see your LookML projects. For each project you want to connect, click the toggle beside the project name.
Once the key is generate, you can select your LookML project and click Copy public key and head to your LookML repo in GitHub.
Once in your GitHub repo, click on Settings > Deploy keys on the sidebar.
A new key can be added by clicking on Add deploy key button in the top right corner.
Set a title for your new key and then paste the key copied from Secoda into the Key text field.
Click Add key.
Note: You DO NOT need to provide write access
Once the key has been added, go back into the Secoda App and click on Run Extraction in the top right corner to begin start the extraction process.
Note: You DO NOT need to start the extraction process if you would rather wait until the next scheduled extraction.