I am trying to set up Growthbook on my site to run a basic A/B experiment where a feature flag renders as true for half of anonymous users, and renders as false for the others. My javascript code is handling what to render based on whether that flag is true or false. However, I'm having an issue getting the experiment started. I set up a Metric and the SQL wrote itself, however there seems to be some kind of error screenshot attached. I dont understand what the error means.

hi George

Yes. Big Query

Hi @refined-rose-14039, it seems like BigQuery is connected successfully as a data source. Is that right? I think the first move I'd make to debug this would be to confirm that the data exists in BigQuery.

Hi @strong-mouse-55694 I am also experiencing this issue. The SQL created by Growthbook seems to have an issue. Omitting the "WHERE" clause does however return data. I am not sure how to debug this.

@strong-mouse-55694 the experiment data? It's not gonna be there. I'm trying to set up an experiment for the first time. The specific error is lapg-abtesting:growthbook_experiments.events_* does not match any table. I don't know what this means, what table its looking for, or what "data" should already be in Big Query if the experiment isn't tracking anything.

@quick-postman-31768 Glad you resolved it. Was the SQL generated via Fact Table metric?

@strong-mouse-55694 yes the query was generated

The experiment requires a metric

@refined-rose-14039 As Graham mentioned above, that error says there isn't the event table in the db. Are you able to confirm that data exists in BigQuery or GA?

@strong-mouse-55694 I don't have access to the BigQ / GA account, so i don't know what "data" you're referencing. Or what you mean by "the data." The experiment hasn't started recording anything yet, so there couldn't be experiment data there.

We're just trying to help you figure out what's happening, but that error is going to be expected if that table doesn't exist in the database (BigQuery), as there won't be anything to query. GrowthBook doesn't write any data to the database—it relies on what's already there. In your case, it sound like you're doing a GA4 → BigQuery. So, before we troubleshoot anything on the GrowthBook, you should confirm that data is being written properly to BigQuery.

i dont know how to confirm that