Looker

This documentation for the Looker integration describes the technical capabilities of this integration, including authorization, scopes/permissions, and utilized endpoints. For more information on how to integrate Looker, visit our connection instructions.

Version

This integration utilizes the Looker API v4.0.

Base URL

The base URL used for all Looker API endpoints contains the Instance name and Port:

https://instance_name.looker.com:port/api/4.0

---

Authentication & Authorization

The DataGrail Looker integration connects using OAuth 2.0.

Limits

Limits in Looker are calculated using the leaky bucket algorithm. All requests that are made after rate limits have been exceeded are throttled and an HTTP 429 Too Many Requests error is returned. Requests succeed again after enough requests have emptied out of the bucket.

• DataGrail supports requests throttling to stay within 70-80% of specified service rate limits.
• DataGrail processes API responses with HTTP 429 status to interrupt requests, waiting and retrying (using an exponential backoff strategy).

---

Capabilities

System Detection

DataGrail provides continuous system detection, delivering a real-time inventory of your data assets.

Data Interactions

DataGrail's System Detection process runs once daily and performs the following actions:

1. Get information about the current user.
2. Use the current user email as an owner value for all collected objects.
3. Get information about integration hubs to collect looker_integration objects.
4. Get information about all Integrations to collect looker_connection objects.
5. Merge looker_integration and looker_connection objects to the common collection.

Endpoints Utilized

Method	Endpoint	Purpose	Docs
GET	/integration_hubs	Get information about an integration hubs
GET	/integrations	Get information about all Integrations
GET	/user	Get information about the current user

---