This message was deleted.

Hey Pedro! Thanks for sharing. I'm not sure exactly what's happening, but the experiment exposure query is defined in your data source configuration. What do you see if you go to Metrics and Data → Data Sources → Reshift, under Experiment Assignment Queries? This is where you tell GrowthBook where to find your experiment variation assignment events.

Thanks a lot Ryan! It seems I had mapped the wrong table, now added

growthbook.experiment_viewed

instead of just

experiment_viewed

. But now it's saying

experiment_id

is missing. Do we need to add

experiment_id

and

variation id

as well to the fact tables?

What are you trying to accomplish? Generally, you wouldn't be accessing the experiment viewed data as/in a fact table. Rather, the experiment exposure table is handled separately and fact tables are used for the metrics you want to optimize for. Then, in the experiment analysis, GrowthBook will look at the exposure data and join it to the chosen metrics to see how different variations perform.

Ok, I'm trying to see experiment results, if I click on the warning next to the Update button, it tells me experiment_viewed doesn't exit.

It sounds like you need to check your experiment assignment queries under Metrics and Data -> Data Sources. https://docs.growthbook.io/app/datasources#experiment-assignment-queries