LookML Generation Agent
LookML Generation Agent: AI-powered reporting and dashboard creation for compliance.
Publisher
Capgemini Technologies
Industry Type
Financial Services
Product Details
This agent generates Look ML so users can build Looker compliance dashboards from natural language. A user submits a question through a chatbot, Dialog Flow CX handles the interaction and intent recognition, and a Webhook triggers a Cloud Function that forwards the query. Agent 1, using Gemini 2.5 Flash, converts it into SQL with the Big Query schema as context, and the SQL runs in Big Query.
Using A2A communication through Cloud Run, Agent 2, using Gemini 2.5 Pro, generates the matching Look ML, and Agent 3 invokes Looker to generate the dashboard. The user receives an interactive Looker dashboard and can download reports in PDF or CSV. This replaces manual creation of LookML models and dashboards for data analysts, business intelligence teams, and compliance officers, reducing the time and effort needed for compliance reporting.
Key Use Cases
Natural Language to LookML Dashboard Generation
Uses Gemini models to translate business compliance queries into SQL and compile production-ready LookML models.
Automated Regulatory Compliance Reporting
Generates interactive Looker dashboards and downloadable compliance exports directly from natural language prompts.
Explore detailed deployment path
Requires Gemini. Access integration prerequisites, specialized agent configuration guides, and implementation documentation.