# How do I create a Looker connection?

We use Looker as our BI Platform, how do I connect that data to Kraken?

##### Post Metadata
- Posted at: almost 7 years ago
- Net upvotes: 1


## Comments
### Comment 1

Looker Requirements:
Setting up Kraken to connect to your Looker environment requires the generation of an API key prior to creating a Data Provider in Kraken. Kraken will also require the password for the user that has write access to the Scratch Database you have set up in your Looker connection settings.

Once connected, Looker will list table visualizations from your Personal Space in Looker. Kraken automatically filters out any Looks that are not using the same connection that you set up in the Data Provider. If you have multiple connections set up in Looker, a separate Data Provider will need to be created in Kraken for each Scratch Database you have set up in Looker.

Kraken currently supports the following Scratch Databases for write back:
 - Redshift
 - MySQL

Instructions for generating a Looker API key that can be used with Kraken can be found at: https://docs.looker.com/admin-options/settings/users#api3_keys

Adding a new Looker Data Provider in Kraken:
 
Connecting to the Looker API:
 - Log in to Kraken
 - Click on the Menu in the top right corner
 - Select Manage Data
 - Click on the Looker Data Provider Card

Port: Default port for Looker instances is 19999 but can be changed in your Looker configuration. Check with your Looker Admin if you do not know the port your Looker instance is using.

Domain: The domain of your Looker instance. For example: If your Looker instance URL is https://mycompany.looker.com, your domain would be mycompany

Client ID: This can be generated on the Users page in the Admin section of your Looker instance.

Client Secret: This can be generated on the Users page in the Admin section of your Looker instance.

 - Click Connect

Connecting your Looker Scratch Database:
NOTE: In order to push predictions back to a place that can be integrated with your Looker dashboards, Kraken requires read/write access to the Looker Scratch Database that is configured in your Looker connection.

Database Password: This is the password that can be used to connect to the database that Looker is using to create Persistent Derived Tables.

 - Click Connect

##### Comment Metadata
- Posted at: almost 7 years ago
- Author title: Director of Product Marketing




## Related Product
[Qlik Predict](https://www.g2.com/products/qlik-predict/reviews)

## Related Category
[Data Science and Machine Learning Platforms](https://www.g2.com/categories/data-science-and-machine-learning-platforms)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: almost 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: almost 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: almost 13 years ago
  - Comments: 4