lookml-view
Instructions
1. File Organization
- Standard Views:
views/[datasource_name]/[view_name].view.lkml - Extended Views:
views/[datasource_name]/[view_name]_ext.view.lkml - Refinements:
views/[datasource_name]/[view_name]_rfn.view.lkml - NDTs:
views/[datasource_name]/[view_name]_ndt.view.lkml - SDTs:
views/[datasource_name]/[view_name]_sdt.view.lkml
2. Core Standards
- sql_table_name: Required for standard views. Defaults are fragile; be explicit.
- Primary Key:
- Must be the first dimension defined in the file.
- Must have
primary_key: yes.
- Refinements: Use
+before the view name (e.g.,view: +users) to refine existing views without modifying the original file. - Extensions: Use
extendsto reuse logic from other views.
More from lkrdev/lookml_skills
lookml-model
Use this skill when you need to create or modify a LookML Model file (.model.lkml). This includes defining connections, includes, and configuring model-level settings.
24lookml-explore
Use this skill when you need to create or modify a LookML Explore. This includes defining the Explore, joins, access grants, and basic configuration.
23lookml-refinements
Deep dive into LookML includes, refinements (layering), and project structure best practices. Essential for mastering Looker's object-oriented capabilities.
23lookml-fields
Overview of LookML field types (Dimension, Measure, Filter, Parameter) and the role of the `sql` parameter in each. Use this skill to choose the right field type for your data modeling needs.
22lookml-sets
Guide to using LookML sets for grouping fields, controlling visibility, and managing drill paths.
21lookml-liquid
Use this skill to use Liquid variables in LookML for dynamic SQL, HTML, and Links, including advanced patterns for query optimization.
21