Admin credentials required

To complete this guide, you will need Looker admin credentials as well as admin privileges for the code repository that hosts your LookML code.

This guide explains how to create service accounts for Monte Carlo on Looker and on your LookML code repository.

To review all steps necessary to integrate a BI tool with Monte Carlo, please see here.

In this guide, you will:

  1. Create an API key on Looker, allowing Monte Carlo to access metadata about your Dashboards, Looks and other Looker objects.
  2. Connect Monte Carlo with your LookML code repository, allowing Monte Carlo to map dependencies between Looker objects and data warehouse tables.

Creating a Looker API key

To create a read-only Looker API key for Monte Carlo, please follow the steps below.

First, create a permission set:

  1. In the top navigation bar, go to Admin > Roles and click New Permission Set.
  2. Name your permission set "montecarlops".
  3. Check the necessary permissions (see list below), and click New Permission Set to save.

Then, create a role:

  1. In the top navigation bar, go to Admin > Roles and click New Role.
  2. Name your role "montecarlorole".
  3. Select the permission set you created ("montecarlops").
  4. Select the appropriate Model Set (typically, All).
  5. Click New Role to save.

Then, create a user:

  1. In the top navigation bar, go to Admin > Users and click Add Users.
  2. Choose an email address, for example [email protected] You are not required to use a valid email address.
  3. Uncheck the Send setup emails option.
  4. Select the role you created ("montecarlorole").
  5. Click Add Users to save.

Then, create an API key

  1. In the top navigation bar, go to Admin > Users and click Edit on the new user you created for Monte Carlo.
  2. Click Edit Keys and then New API3 Key.
  3. Copy Client ID, and paste into Monte Carlo's integration wizard.
  4. Unhide and copy Client Secret, and paste into Monte Carlo's integration wizard.

Finally, get your Looker host URL:

  1. In the top navigation bar, go to Admin > Settings.
  2. Copy Host URL, and paste into Monte Carlo's integration wizard.
  3. Add the suffix :19999 to the URL, e.g. if your host is https://mydomain.looker.com, then you should provide the value https://mydomain.looker.com:19999 on Monte Carlo's integration wizard.

Please note that if you use a self-signed certificate for Looker's SSL connection, you will need to uncheck the Verify SSL on Monte Carlo's integration wizard.

Connecting to your LookML code repository

To provide read-only access to your LookML code repository, please follow the steps below. You will need to complete setting up Looker's API key on Monte Carlo prior to performing this section.

To enable LookML access to Monte Carlo, you will Create an SSH key to access your LookML code repository.

Please contact us using the Intercom bot or at [email protected] if you need assistance with one of the following:

  • Connecting to multiple LookML code repositories.
  • Having a colleague who has the appropriate admin access complete this step.

Creating an SSH key

To enable Monte Carlo access to hosted Git repositories, you can provide a read-only SSH key.

First, create an SSH key on your local machine:

  1. In your terminal, please use the following command, using your own email address.
ssh-keygen -t rsa -b 4096 -C "[email protected]"
  1. Please follow the prompts and do not provide a passphrase (leave empty).

Then, use the public key (found within the .pub file you generated earlier) to configure read-only SSH access on your repo using the following instructions:

Finally, provide the following details on Monte Carlo's integration wizard to validate and complete the integration:

  • Your private key (found within the file that has no extension you generated earlier).
  • Your repository URL. Most hosting services will provide the SSH cloning URL on the repository's main page. It typically looks like so: [email protected]:USERNAME/REPOSITORY.git.

What’s Next

Adding another Looker connection or want to modify an existing one?

Did this page help you?