Looker user attributes and `if dev` to auto-switch between dev & prod schemas

Show and Tell
,
11

I want to put an emphasis on something important that was not specifically mentioned here, and which caused me some headaches until I figured it out.

It is super important that the double semicolons are on their own line, otherwise the ON clause on joins will be commented out and will therefore return duplicated rows.

So, this is bad:

view: events {
  sql_table_name:
    -- if prod -- public.events
    -- if dev -- public.events2 ;;

And this is good:

view: events {
  sql_table_name:
    -- if prod -- public.events
    -- if dev -- public.events2
;;