thoughts?

Hi Jack. I've seen that before, and we had to cast the timestamp correctly in the query

ok cool

I believe you need to cast timestamp columns to datetime in your experiment and metric queries. We use datetime elsewhere in the query and BigQuery is really strict about comparisons between different types.

Yep, i just had this same issue yesterday had to cast. We’re using Snowplow with BigQuery Our Experiments Query

SELECT
  user_id,
  domain_userid as anonymous_id,
  cast(derived_tstamp as DATETIME) as timestamp,
  se_label as experiment_id,
  se_property as variation_id
FROM
  `snowplow_prod.snowplow-events`
WHERE  se_category = 'Growthbook' and
  se_action = 'Experiment Viewed'

and Our Metric Query

SELECT
  domain_userid as anonymous_id,
  cast(derived_tstamp as datetime) as timestamp
FROM
  `snowplow_prod.snowplow-events`
WHERE se_action = 'Sign Up Completed'