Hello guys, i am facing with a DB error when tryin...
# ask-questionsa
adventurous-librarian-73331
10/12/2023, 9:31 AMHello 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
fresh-football-47124
10/12/2023, 9:32 AM
Click on your data source. There, you’ll see a section called “assignment queries”
fresh-football-47124
10/12/2023, 9:32 AM
you can edit those to match your data
a
adventurous-librarian-73331
10/12/2023, 9:39 AMi 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_experimentadventurous-librarian-73331
10/12/2023, 9:40 AMthis table topically about registered users in my end
adventurous-librarian-73331
10/12/2023, 9:53 AMmaybe 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
fresh-football-47124
10/12/2023, 2:20 PM
do you have multiple randomization units? (on that same page)
a
adventurous-librarian-73331
10/16/2023, 10:40 AMi 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
68 Views