Hi I created my first experiment. When I trigger

update

, I get this error: "Unknown experiment assignment table - anonymous_id" I never used this value, so I don't really know where to look. Thanks in advance

hi David - that anonymous_id will be defined in the assignment queries - which is in the metrics and sources -> data sources -> [your data source]

Thank you, @fresh-football-47124. I don't understand what I need to edit/add in the assignments . This is the current setup:

Hi David, thank you for your response and assisted information. For context, the "Unknown experiment assignment table error" typically indicates an issue with the database setup or configuration in GrowthBook. Here are a few things you can check: ​*Database Connection*​: Ensure that your database is correctly set up and that GrowthBook is able to connect to it. If you're using a MongoDB instance, for example, make sure that the connection string is correct and that the database is accessible from your GrowthBook instance. ​*Database Schema*​: Check if the database schema is correctly set up. GrowthBook requires certain tables (or collections, in the case of MongoDB) to be present in the database. If the "experiment assignment" table (or collection) is missing, you might encounter this error. ​*Database Permissions*​: Make sure that the database user used by GrowthBook has the necessary permissions to read from and write to the "experiment assignment" table. Please, can you review the above debugging steps to debug this error and keep us posted on how you get on?

Hi Thanks for the quick response. The connection to BigQuery works as expected and the queries I've defined return data. I can see the various metrics pulled and displayed, it's just the experiment that won't show data, with the error I quoted.

Thank you for your speedy response. In the affected experiment please can you double check that the experiment assignment query in question is linked to the correct experiment? I think if you go to your Experiment, go to the Results Tab, and click "Analysis Settings" at the top of the results tab, you'll be able to set your "Experiment Assignment Table". Once you pick the right table, I think this problem might be resolved.

Thanks, your advice was spot on.

Ah perfect, super glad all is now working and thank you for the update🙏