Atlan supports integration with Looker, which allows you to integrate your Looker assets 📊 with your Atlan workspace.
You can set up a Looker integration with your Atlan workspace in four easy steps:
Select the source, aka Looker 😉
Provide your credentials ✍️
Set up your configuration 🗄️
Schedule automatic updates 🕑
Before you get started, you'll need some information to help establish a connection between Atlan and your Looker account.
Client ID and Client Secret
Go to Looker instance and open the Admin tab.
Select Roles from the drop-down list
Click on New Permission Set and give a name to the permission set.
Tick the following permissions and save the permission set. Upon saving, you'll be redirected to the Roles page.
The following permissions are required to have looks, dashboards and explores crawled in Atlan -
explore (optional, needed if Looker Explores has to be crawled)
The following permissions are also required to create lineage between data source and looker assets -
Note: Read More regarding Permission Set.
How to choose permission in Looker
Click on New Role and give it a name.
Select the Permission Set created earlier.
Select all the Model Sets you want to gives access to.
Select a user to apply the role on and generate the API key.
Once you have the prerequisite information listed above, follow the steps below 👇 to establish a connection and integrate Atlan with Looker.
Log into your Atlan workspace.
Click the "+ New Integration" button on the top right corner of the home screen. You will see a dialogue box with the list of sources available on your workspace.
Select "Looker" from the list of options, and click "Next".
You will get an option to either select "Existing Credentials" (on the left) or "Create a New Credential".
To set up a new connection, click on the "Create Credential" and fill in your Looker credentials. Here are sample values:
Instance URL: https://example.cloud.looker.com/****
Instance Name: example.cloud.looker
Client ID: KJFSH**DSKDH
Client Secret: KHFSKH_**_SDSHJ
Advanced Config: [optional, needed to create lineage] Check
Incoming Data Sources Connection Info to add connection details of the data source (eg. Redshift, Snowflake) connected to LookMLs in Looker.
There can be multiple connections depend your Looker instance connections.
Connection Name: (Name should be same as given in Looker Connection Details) Ex - snowlooker,
Data Source: Snowflake, Redshift etc
Connection's Hostname : Host URL (Example: clusterName.ap-south-1.redshift.vendor.com)
[Optional] Source Schema
Once you have filled in all the details, click on "Next".
Select folders you want to crawl.
Choose whether to run the crawler once or schedule it for a daily, weekly, or monthly run. You will be asked to specify the time zone for the run.
Click on "Create". Your connection is now created.
Congratulations! Your integration with Looker is now successful 🎉
Once the integration setup is completed, you will be redirected to the "Monitor" tab for your Looker asset, where you can monitor the progress of your integration.
access\_data: The topmost permission, which is required to get other permissions like
see\_lookml\_dashboards: Allows Atlan to see and crawl the LookML Dashboard.
see\_looks: Allows Atlan to see and crawl Looks.
see\_user\_dashboards: Allows Atlan to see and crawl user-defined dashboards.
explore: Allows Atlan to see and fetch from the Explore page.
see\_lookml: Allows Atlan to see LookML to get model information.
develop: Allows Atlan to see
connection_name in the model information. This is required for the
connection_name mapping with model sets and is used in lineage generation.
see\_datagroups: Allows Atlan to see all
connection_name and is used in lineage generation.
see\_sql: Allows Atlan to fetch the SQL of a query or Look, which is primarily used in lineage generation.
connection_name is similar to Connections you have in the the Looker instance. This is the same terminology as in Looker.
Here are some troubleshooting steps to check:
Advanced Config is present in your credentials.
Make sure that
Automatically generate lineage for crawled looks and dashboards is checked in the Crawler Config.
Check that permission
see_sql is given to the role from which API3 credentials are generated.
Make sure the data sources' assets are in Atlan.
Two tiles are crawled from Looker:
Yes, the table lineage will still be formed with Widget.