Looker
Connect Looker to ajan to query your BI dashboards and run data analyses from your conversations
Overview
Looker is Google Cloud's business intelligence platform. Once connected, you can use ajan to search dashboards, run Looks, execute ad-hoc queries against your LookML models, and retrieve results directly from your conversations.
Prerequisites
- A Looker instance (cloud or self-hosted)
- Permission to generate API credentials in Looker
Setup
Generate API credentials in Looker
Follow Looker's API authentication guide to generate a Client ID and Client Secret. Copy the secret immediately — it's only shown once.
Get your Looker base URL
Your base URL is the address of your Looker instance, e.g. https://your-company.cloud.looker.com.
Navigate to Integrations in ajan
Go to Integrations and find Looker in the list.
Enter your credentials
Enter your base URL, Client ID, and Client Secret, then save.
Start using Looker in ajan
Tag the integration with @ in any agent to start querying your Looker data.
Common Use Cases
- Dashboard Access — Search and retrieve dashboards, get dashboard elements and their underlying queries
- Run Looks — Execute saved Looks and get results in JSON or CSV format
- Ad-hoc Queries — Run inline queries against LookML models by specifying model, explore, fields, and filters
- Data Discovery — Browse LookML models, explores, and available fields to understand your data structure
Troubleshooting
| Issue | Solution |
|---|---|
| Authentication failed | Verify the Client ID and Secret are correct — regenerate if the secret was lost |
| Instance not found | Check the base URL format: https://[instance].cloud.looker.com (no trailing slash) |
| Permission denied | Ensure the API user has access to the dashboards or models you're querying |
| Look not found | Use the search or list actions to find the correct Look ID |