https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
a

adventurous-librarian-73331

10/12/2023, 9:31 AM
Hello guys, i am facing with a DB error when trying to connect to results on my first experiment. Unknown experiment assignment table - anonymous_id can you suggest please how to fix it?
f

fresh-football-47124

10/12/2023, 9:32 AM
Hi - sure - you need to go to Metrics & Data and then Data sources
Click on your data source. There, you’ll see a section called “assignment queries”
you can edit those to match your data
a

adventurous-librarian-73331

10/12/2023, 9:39 AM
i have a simple query like this
Copy code
SELECT
2  user_id as user_id,
3  timestamp as timestamp,
4  experiment_id as experiment_id,
5  variation_id as variation_id
6FROM
7  DBT_DEV.DBT_GROWTHBOOK.viewed_experiment
should i also add anonymous_id as user_id ?
this table topically about registered users in my end
maybe i need to connect my snowflake db as data source from the custom data sources. it was mixpanel in the first palace
f

fresh-football-47124

10/12/2023, 2:20 PM
mixpanel should work
do you have multiple randomization units? (on that same page)
a

adventurous-librarian-73331

10/16/2023, 10:40 AM
i think it was one of the reason when i had the connection with mixpanel and snowflake together. it is now working by using only snowflake
3 Views