home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
hidden (for fields)

This page refers to the hidden parameter that is part of a field.

hidden can also be used as part of an Explore, described on the hidden (for Explores) parameter documentation page.

Usage

view: view_name {
  dimension: field_name {
    hidden: yes
  }
}

Hierarchy

hidden

Possible Field Types

Dimension, Dimension Group, Measure, Filter, Parameter

Accepts

A Boolean (yes or no)

Definition

If you want a field to be available for modeling, but not shown to users, you can hide it from the field picker by using the hidden parameter.

Hidden fields can still be accessed in the UI if they are manually added to the URL. Therefore, the hidden value is a way to keep the field picker clean; it is not a security feature.

The default value of hidden is no, unless the field is defined in a view that has the fields_hidden_by_default: yes parameter.

You can use the fields_hidden_by_default: yes view parameter to set the default for all the view’s fields to hidden:yes. This is helpful if you want to hide the majority of fields in a view, since you won’t have to add hidden:yes to each of the view’s fields. If you want to display a field in a view that has the fields_hidden_by_default: yes parameter, add the hidden:no parameter to the field.

Examples

Prevent the raw_event_stream dimension from appearing in the field picker:

dimension: raw_event_stream { sql: ${TABLE}.event_stream ;; hidden: yes }

Top