In Data Source settings there s a User Id Join Table optiona

Question

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

better-parrot-43048 · Answer

snippets of experiment query when it s left blank ```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 ```

future-teacher-7046 · Answer

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

better-parrot-43048 · Answer

Oooh I get it Thank u