Editing LookML to change what a model exposes

LookML defines Looker's semantic data model using dimensions, measures, views, and explores written in a version-controlled project. Associate Data Practitioners are expected to read and make simple, guided edits to existing LookML parameters (such as label, description, sql, hidden, or type) without building models from scratch.

1 · Learn the must-know

  • LookML files use .view.lkml, .model.lkml, and .explore.lkml extensions and are organized in a Looker project connected to a Git repository.
  • Dimensions represent groupable/filterable fields (columns or derived SQL expressions), while measures represent aggregations (sum, count, average) computed via LookML measure types.
  • Common editable parameters include label and description (change display text), hidden: yes/no (show or hide a field in Explore), and sql (modify the underlying SQL expression for a field).
  • Changes made in the LookML IDE must be saved and validated (LookML validator checks syntax) before committing and deploying to production via Git.
  • The Explore interface reflects LookML changes only after validation passes and the model is deployed; syntax errors block saving.
  • Renaming or hiding a field in LookML does not alter the underlying BigQuery table or data. It only changes how the field is presented in Looker's semantic layer.

2 · Check your understanding

Check this objectiveFree · always available

A data practitioner is building an Explore in LookML. The view includes a dimension named user_id that is needed internally for joins and primary key definitions, but the team wants it removed from the field picker so business users cannot select it directly. Which change to the dimension accomplishes this without breaking existing joins?

Previous objectiveNext objective
Your objective map0 tried · 0 answered correctly · 41 untouched

What you have tried across GCP ADP's objectives, not a readiness score.

Data Preparation and Ingestion~30% of the exam0 of 8 tried
Data Analysis and Presentation~27% of the exam0 of 12 tried
Data Pipeline Orchestration~18% of the exam0 of 9 tried
Data Management~25% of the exam0 of 12 tried

3 · Keep going

Ready for more? Take a weighted mock or try free practice questions.

These are independent practice questions, written against this certification's published exam guide. They are not the certification vendor's own questions, and not the real exam.