Hi Team - My client is trying to setup Growthbook for their shopify store. We've setup GA4 & BigQuery (BQ) Note, we're not self-hosted GB, so can't use the discovery metrics method. Please can you help with these issues we've had, trying to setup Metrics... • How do we setup an events_ table in BQ? In our BQ, we only see the events_intraday (11) table (it's been setup for >7 days, but the events_ table hasn't appeared) • Can you share an example of SQL, for setting up a metric, I've tried using this add-to-cart SQL previously shown in this slack (link), but get the errors "No rows returned, could not verify result" and "No schema provided. Please edit the connection settings and try again." (GB shows GA4 as connected). Many thanks 🙂

Note, we're not self-hosted GB, so can't use the discovery metrics method.

I don't think this is a problem? If you selected GA4 when Adding a datasource the "Discover Metrics" button should exist on the Metrics section of your Data Source page.

Thanks Luke - we'll try to fix the BQ to get the events_ table appearing

> Growthbook documentation says - "Auto-discovery from environment variables or GCP metadata (only available when self-hosting)

This is in regards to providing credentials to GrowthBook, not the auto-metrics. I'd be happy to help you out with the auto-metrics error if you could share the error message you got. But yeah if the daily events table isn't there then I think our auto-metrics will fail.