fields_hidden_by_default

Usage

 view: view_name {   fields_hidden_by_default: yes  } 

Definition

By default, all fields in a view are displayed in the view's Explores. If you want a field to be available for modeling but not shown to users, you can hide the field from the Explore field picker by adding the hidden: yes parameter to the field.

If you want to hide most of the fields in a view, you can instead add the fields_hidden_by_default: yes parameter to the view. This sets the default for all the view's fields to hidden:yes. Then, if you want to display a field in the view, you can add the hidden:no parameter to the field.

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.

Examples

This example airports view has the fields_hidden_by_default: yes parameter, so all fields are hidden in the view's Explores by default. The country dimension is defined with hidden:no, so it will be displayed in the view's Explores. The id dimension has no hidden parameter, so it will take the default value and will be hidden in the view's Explores.

view: airports { sql_table_name: flightstats.airports ;; fields_hidden_by_default: yes dimension: id { primary_key: yes type: number sql: ${TABLE}.id ;; } dimension: county { type: string sql: ${TABLE}.county ;; hidden: no }