Open source feature flagging and experimentation platform for stress free deployments, measured impact, and smarter decisions.

GrowthBook Users

Hi Haris, I can try to offer some help.

The SQL query you pasted appears to be an Experiment Assignment Query (EAQ), which you *should* be able to edit here:

Left navbar --&gt; Metrics and data --&gt; Data sources --&gt; Select the BQ in question --&gt; "Experiment Assignment Queries" section.

When the SQL works fine for the Metrics themselves but not within the context of an Experiment, usually it's the Experiment Assignment Query at fault.

I agree with you; I have not seen the `:` syntax in a BQ-related EAQ before.

More docs on EAQs:
<https://docs.growthbook.io/app/datasources#experiment-assignment-queries>

Did you follow our BigQuery setup guide?

<https://docs.growthbook.io/guide/bigquery>

We should have automatically created the EAQ for you if you followed that guide.

You'll need to change the 2 lines that contain the colons. Maybe try this?

```experiment_id_param.value.string_value AS experiment_id,
      variation_id_param.value.int_value AS variation_id,```

I’ll try the change on the Experiment Assignment Query, thanks!