Knowledge Drop

Can I use `hidden` on a join?

  • 6 April 2021
  • 1 reply

Userlevel 2

Last Tested: Mar 5, 2021


No, you can use hidden only at the explore and field level (documentation).

BUT, there are workarounds.

Method 1: use fields: [] instead on the join (documentation). This will effectively do the same thing as hidden would because it tells Looker to not bring any fields into the explore. Caveat: If any current content uses fields from this join, the content will break because the fields are no longer in the explore.

For example:

join: foo {fields: []}


Method 2 (better way): use an empty view_label parameter in the join (documentation).

For example:

explore: orders {

join: users {

type: left_outer

sql_on: ${orders.user_id} = ${} ;;

relationship: many_to_one

view_label: ""




Will show up as this in the explore:



This content is subject to limited support.                




1 reply


I needed just this (second option) to enable drill-downs from a higher level view to a smaller level view but prevent users from inadvertently multiplying rows by adding fields from the smaller view level (which has another explore specifically for it).