Use the Looker connector to explore and visualize business intelligence data.
Integrating your application with Looker lets you use these operations in an automation. It exposes 15 actions, listed below. Add the connector from the Connections area, authenticate, then select its operations in the automation builder. Capabilities: actions.
Authentication
Before you begin, make sure you have the following information:
Connection Name: Choose a meaningful name for your connection. This name helps you identify the connection within your application or integration settings.
Authentication Type: Looker supports API token authentication.
Authentication & setup
Creating API Credentials
For Looker (Google Cloud)
In your Looker instance, go to the Admin section
Navigate to Users
Click on the user for which you want to create API credentials
Create new API credentials
You'll receive a Client ID and Client Secret
For Looker (Original)
Request credentials creation from your Looker admin if you're not an admin
The admin will create credentials via the Admin section > Users
Authentication Methods
Using an SDK (Recommended)
Provide your Client ID and Client Secret to the Looker SDK, which handles token acquisition and insertion automatically.
Without an SDK
Call the login endpoint with your Client ID and Secret to obtain an OAuth 2.0 access token
Include the token in the HTTP Authorization header for subsequent requests:
Authorization: Bearer {access_token}Tokens can be invalidated via the logout endpoint
OAuth with CORS
Looker can use the Cross-Origin Resource Sharing (CORS) protocol to let web applications make calls to the Looker API from outside a Looker instance's domain.
Credential Security
Create multiple credential sets per user account if needed
API credentials are independent of user login settings (2FA/SAML don't apply to API)
Best practice: use service accounts with minimal privileges rather than admin accounts
Keep secrets private; never store them in source code
Use environment variables or a secure key management service
Actions
Action Name | Description |
|---|---|
Create board | Create a new board in Looker |
Create dashboard | Create a new dashboard in Looker |
Create look | Create a new look in Looker |
Delete board | Delete a board by ID in Looker |
Delete dashboard | Delete a dashboard by ID in Looker |
Delete look | Delete a look by ID in Looker |
Get All LookML models | Fetch all LookML Models with full metadata |
Get board | Get a board by ID in Looker |
Get dashboard | Get a dashboard by ID in Looker |
Get look | Get a look by ID in Looker |
Get lookML model explore | Retrieve full metadata for a specific explore in a LookML model |
Get single LookML model | Retrieve detailed metadata for a specific LookML model |
Update board | Update a board in Looker |
Update dashboard | Update a dashboard in Looker |
Update look | Update a look in Looker |