What is left_outer_each

  • 13 August 2019
  • 2 replies

in the documentation for the sql_where parameter under join there is an example:

    explore: orders_users_under_50 {
view_name: orders

join: users {
sql_on: ${} = ${orders.user_id} ;;
sql_where: ${users.age} < 50 ;;
type: left_outer_each

type is set to left_outer_each, but there is no reference to that choice in the documentation for type. What is left_outer_each?

2 replies

Userlevel 7
Badge +1

You seem to have found an occult Looker secret, or at least a reference to one. I’d start looking over your shoulder, if I were you… The truth is out there.

But really, it does look like we have not documented that— The feature was borne from this discussion, which has some explanation:

AFAIK, in earlier days of BigQuery, join each was a somewhat sad fact of life due to performance restrictions, but now is generally pretty unnecessary, so perhaps we don’t want to encourage its use by including it in the docs.

I’ll connect with our docs team on whether or not we’ll document this or remove the reference to it entirely.

Awesome thanks for the response. I was surprised to see the unlisted type, and was so curios to know what it was. Thanks izzy, keep up the great work!