hidden (for Fields)
This page refers to the
hiddenparameter that is part of a field.
hiddencan also be used as part of an Explore, described on this documentation page.
Usage
view: view_name {
dimension: field_name {
hidden: yes
}
}
dimension: field_name {
hidden: yes
}
}
Hierarchyhidden |
Possible Field TypesDimension, Dimension Group, Measure, Filter, ParameterAcceptsA 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.
The default value of hidden is false. Hidden fields can still be accessed in the UI if they are manually added to the URL and will show up in some Looker windows. Therefore, think of hidden as a way to keep the field picker clean, and not a security feature.
Examples
Prevent the raw_event_stream dimension from appearing in the field picker:
dimension: raw_event_stream {
sql: ${TABLE}.event_stream ;;
hidden: yes
}