Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
Wow, what an interesting pattern. Essentially a wide UNION! Alright @fabio, Rex sparked something on Twitter where I was waffling between a FULL OUTER JOIN and a UNION ALL, but really what I wanted was, as @lloydtabb succinctly put it, “a wide UNION!”I guess OJOF it is!(It’s actually cleaner, because I was having to NULL fill all the table A-only fields in the table B select and vice versa. And BQ is very particular about its NULL types, so I had to do garbage like CAST(NULL as DATE).)
Whoever wrote this is dumb and bad. You need to fully scope the liquid references, like this:sql_always_where: {% if users.user_email._is_filtered %} ${user_email_hashed} = TO_BASE64(SHA256({% parameter users.user_email %})){% else %} 1 = 1{% endif %};;I hope the author doesn’t work at Looker anymore.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
