Looker LookML Development Accelerator
Generate LookML code and troubleshoot Looker dashboards faster
What You Can Do
You generate production-ready LookML code, debug model validation errors, and optimize explore performance. This skill accelerates your development cycle by handling syntax generation, relationship definition, and complex calculations—letting you focus on business logic rather than language mechanics.
Features
automatically write dimensions, measures, and derived tables with correct syntax
identify and fix LookML syntax errors, circular references, and data type mismatches
analyze join patterns, suggest indexing strategies, and refactor queries for faster execution
generate boilerplate views, common measure definitions, and dashboard LookML snippets
build PDT definitions, custom filters, and parametric measures with proper field type handling
check foreign key mappings, test many-to-many joins, and verify drill-path logic
create inline LookML comments and user-facing descriptions for fields and explores
Example Output
View Generation:
view: users {
sql_table_name: public.users ;;
dimension: id { primary_key: yes type: number sql: ${TABLE}.id ;; }
dimension: email { type: string sql: ${TABLE}.email ;; }
measure: count { type: count drill_fields: [id, email] }
}
Error Diagnosis:
Error: Circular join detected
→ users → orders → users (via customer_id)
Fix: Remove the circular join from orders.view or restructure the explore
Performance Recommendation:
Your explore has 5 joins and 3 derived tables.
Optimization: Pre-aggregate order facts into a PDT, add indexes on foreign keys
Estimated load time improvement: 40%
What's Included
- SKILL.md file (LookML development workflows and decision trees):
- LookML syntax reference and pattern templates:
- Common measure and dimension examples:
- Explore optimization checklist:
- Validation error troubleshooting guide:
- PDT and derived table templates:
Who It's For
- LookML Developers — speed up model creation and debugging
- BI Engineers — optimize explores and dashboards for performance
- Data Analysts — write production-ready LookML without deep syntax knowledge
- Analytics Platform Teams — standardize LookML patterns and reduce code review cycles
Best For
- Writing and generating LookML views, explores, and derived tables
- Debugging model validation errors and relationship issues
- Optimizing explore performance and query execution
- Creating reusable LookML templates and patterns
- Refactoring legacy LookML for maintainability and efficiency
You might also like
Create compelling positioning statements, analyze competitive landscapes, and generate strategic brand recommendations backed by structured frameworks. You'll synthesize market data to identify differentiation opportunities, develop go-to-market strategies, and articulate your unique value proposition with confidence and clarity.
by lurenyang418
This skill transforms raw competitive data—customer reviews, pricing structures, feature lists, and market reports—into structured, actionable intelligence reports. It creates competitive positioning matrices that reveal market gaps, pricing strategies, and feature differentiation at a glance. Get the strategic insights you need to inform product roadmaps, refine positioning, and make confident go-to-market decisions.
by lurenyang418
Transform raw qualitative data—interviews, surveys, focus groups, open-ended feedback—into structured themes and actionable insights. Claude systematically codes your data using established frameworks (Braun & Clarke, grounded theory, phenomenology), identifies patterns across respondents, and synthesizes findings into clear, evidence-based recommendations. You'll go from hundreds of transcript pages to organized themes with illustrative quotes in minutes.
by lurenyang418
Analyze your current brand perception, competitive position, and market gaps to develop a comprehensive repositioning strategy. You'll receive a differentiated positioning statement, messaging architecture, competitive analysis, and a tactical 90-day implementation roadmap that your team can execute immediately.
by lurenyang418
You can create comprehensive, data-driven go-to-market strategies that align your enterprise product with market realities, competitive landscapes, and internal capabilities. This skill guides you through market analysis, positioning, timeline creation, pricing strategy, and launch readiness assessments—delivering actionable roadmaps that reduce launch risk and accelerate time-to-market for complex B2B initiatives.
by lurenyang418
You develop comprehensive go-to-market strategies by analyzing your target market, creating detailed buyer personas, and mapping buying journeys. You then build multi-channel campaign blueprints with positioning frameworks, messaging matrices, and sales enablement assets tailored to your specific buyers and launch goals. This skill transforms product launches from guesswork into data-informed strategies with clear timelines, channel recommendations, and success metrics.
by lurenyang418
You can analyze Snowflake query execution plans to identify performance bottlenecks and recommend targeted optimizations. This skill provides data-driven recommendations for warehouse configuration, data clustering, and SQL rewrites that reduce both execution time and credit costs.
by lurenyang418
You upload interview transcripts, survey responses, or focus group data, and this skill systematically extracts themes, patterns, and relationships using proven thematic coding frameworks. It moves beyond raw data to deliver actionable strategic insights, complete with prioritization and visualization recommendations. The result is a structured, evidence-based foundation for decision-making.
by lurenyang418