https://www.growthbook.io/ logo
#give-feedback
Title
# give-feedback
b

better-parrot-43048

04/01/2022, 8:50 PM
In Data Source settings, there's a "User Id Join Table (optional)" field. We don't link anon ids to user ids (as a policy). Sooo I left it blank, but it looks like that breaks any experiment that includes both anons and users. Is that field meant to be optional? If so, under what conditions?
snippets of experiment query when it's left blank:
Copy code
WITH __identities as (
  -- ERROR: Missing User Id Join Table!
  SELECT
    '' as anonymous_id,
    '' as user_id
),
...
(then, in the __metric CTE):
    JOIN __identities i ON (i.user_id = m.user_id)
f

future-teacher-7046

04/01/2022, 8:52 PM
That join table is used when an experiment is based on
anonymous_id
and you have a metric that only has a
user_id
column.
b

better-parrot-43048

04/01/2022, 8:54 PM
Oooh I get it. Thank u!
15 Views