👋 GM. I don’t suppose anyone’s around who could provide some insight into getting started with GrowthBook and Jitsu? I’ve connected the two, but when I attempt to create my first metric with the following query, I get a

relation "events" does not exist

error.

SELECT
  user_id,
  user_anonymous_id,
  utc_time as timestamp,
  1 as value
FROM
  events
WHERE
  event_type = 'pageview'

Hi Tim. Jitsu doesn't have one single format it uses when syncing data to a warehouse. It depends on how you have it configured. So the default SQL queries we generate might need some tweaking to work with your setup.

I actually provided the query above. When I run that query against the

events

table in the

jitsu

db, I do get the expected results.

Are you using Postgres or something else?

Postgres.

You might need to specify the schema and/or database name for your table. So instead of

events

, it would be

myschema.events

Good idea. I actually tried that already. 🙂

Hmm. Could it be a permissions error?

Let me try something… When I created the Jitsu connection, I did not specify the schema.

No worries. Glad you figured it out