Looker Integration
Connect Lucaro to Looker to audit dashboards, discover LookML models, and track content usage.
What You Get
Content Inventory
Complete catalog of dashboards, looks, and explores
LookML Discovery
Extract model, view, and field definitions
Usage Analytics
Dashboard views, query history, and user engagement
Content Quality
Identify stale, unused, or broken content
Prerequisites
- Looker instance with API access enabled
- API3 credentials (client ID and client secret)
- Admin or Developer role for full access
Setup Instructions
1. Create API3 Credentials
- Log in to Looker as an admin
- Go to Admin → Users
- Select the service account user (or create one)
- Click Edit Keys under API3 Keys
- Click New API3 Key
- Copy the Client ID and Client Secret
2. Connect in Lucaro
curl -X POST "https://api.lucaro.dev/v2/projects/{projectId}/integrations" \
-H "Authorization: Bearer YOUR_API_TOKEN" \
-H "Content-Type: application/json" \
-d '{
"type": "looker",
"name": "Production Looker",
"config": {
"base_url": "https://your-instance.looker.com",
"client_id": "your-client-id",
"client_secret": "your-client-secret"
}
}'What Gets Synced
| Asset Type | Metadata Captured |
|---|---|
| Dashboards | Title, elements, filters, folder, owner, view count |
| Looks | Title, query, folder, owner, view count |
| LookML Models | Model name, explores, connections |
| LookML Views | Fields, dimensions, measures, derived tables |
| Folders | Hierarchy, permissions, content |
LookML Integration
Lucaro parses your LookML to understand field definitions:
// Example extracted field
{
"model": "ecommerce",
"view": "orders",
"field": "total_revenue",
"type": "measure",
"sql": "${TABLE}.revenue",
"value_format": "$#,##0",
"description": "Sum of order revenue"
}These definitions are compared against your metrics registry to identify inconsistencies.
Content Quality Audit
Lucaro identifies content quality issues:
- Stale content - Dashboards not viewed in 90+ days
- Broken queries - Content with query errors
- Orphaned content - Content in personal folders with departed users
- Duplicate content - Similar dashboards across folders