https://www.growthbook.io/ logo
w

wonderful-branch-2202

01/13/2023, 2:14 AM
Hey there, I am trying to integrate the growthbook platform with my codebase, I am encountering an error while trying to get the sample metrics, though the query work independently fine in the metric dashboard but the metric as such isn't showing up in dashboard and giving a bad request error, Any idea how to solve this?
f

fresh-football-47124

01/13/2023, 2:16 AM
Hi Shruti, can you check the exposure query from the data source? Make sure that works when run directly
It’s the query that pulls which user is on which experiment and what variation they got
w

wonderful-branch-2202

01/13/2023, 2:17 AM
It is working directly, I can see sample result as well.
f

fresh-football-47124

01/13/2023, 2:17 AM
Okay
But on the experiment page itself you get he error?
w

wonderful-branch-2202

01/13/2023, 2:18 AM
Yes I am getting a 400 HTTP response. I am trying to query stale data though
f

fresh-football-47124

01/13/2023, 2:18 AM
If you click on the right kebab menu, you should see the ‘view queries’
Ah, perhaps it’s a date range problem?
It shouldn’t give an error though, just no data
w

wonderful-branch-2202

01/13/2023, 2:20 AM
Got it
f

fresh-football-47124

01/13/2023, 2:21 AM
You can run that query directly and try just doing pieces of it to see where the problem is
We use common table expressions, so you can run each separately
w

wonderful-branch-2202

01/13/2023, 2:23 AM
Yes will try to figure out the problem by the looks of it, query isn't able to connect to the data lake as such. Thank you Graham for the help.
f

fresh-football-47124

01/13/2023, 2:23 AM
No problem
5 Views