lookml
Installation
SKILL.md
LookML Reference (lookml)
Index of LookML authoring sub-skills from looker-open-source/looker-skills located in sub-skills/*/SKILL.md:
| Sub-skill | Reference files | Description |
|---|---|---|
| lookml-model | None | 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. |
| lookml-view | derived_table.md | Use this skill to create or modify LookML Views. Covers basic view definitions, sql_table_name, file organization, and patterns. |
| lookml-explore | joins.md, advanced.md | Use this skill when you need to create or modify a LookML Explore. This includes defining the Explore, joins, access grants, and basic configuration. |
| lookml-fields | dimension.md, dimension_group.md, measure.md, filter_parameter.md, value_format.md | 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. |
| lookml-refinements | None | Deep dive into LookML includes, refinements (layering), and project structure best practices. Essential for mastering Looker's object-oriented capabilities. |
| lookml-liquid | None | Use this skill to use Liquid variables in LookML for dynamic SQL, HTML, and Links, including advanced patterns for query optimization. |
| lookml-advanced-liquid | None | Advanced LookML Liquid compiler patterns: {{ _table }}, {{ _view._name }}, {{ field._sql }}, {{ view.field._sql }}, (${EXTENDED}), aliased bare joins (_sdt_*), NDTs with cancel_grouping_fields: vs. {{ measure._sql }}, and Bronze/Silver/Gold DRY inheritance rules. |
| lookml-ojof | None | Design, build, refactor, and optimize multi-fact LookML Explores using the Outer Join On False (OJOF) pattern (from: none, type: full_outer with sql_on: FALSE ;;, Liquid _in_query COALESCE shared dimensions, and UNNEST([COALESCE(...)]) co-dimension views). |
| lookml-sets | None | Guide to using LookML sets for grouping fields, controlling visibility, and managing drill paths. |
| lookml-access-grants | None | Use this skill to create Access Grants for row-level or object-level security. |
| lookml-tests | None | Standards and best practices for writing LookML tests to ensure data integrity, accuracy, and logic validation. |