https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
s

some-lizard-62413

11/11/2022, 3:51 PM
👋 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.
Copy code
SELECT
  user_id,
  user_anonymous_id,
  utc_time as timestamp,
  1 as value
FROM
  events
WHERE
  event_type = 'pageview'
f

future-teacher-7046

11/11/2022, 3:53 PM
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.
s

some-lizard-62413

11/11/2022, 3:54 PM
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.
f

future-teacher-7046

11/11/2022, 3:54 PM
Are you using Postgres or something else?
s

some-lizard-62413

11/11/2022, 3:54 PM
Postgres.
f

future-teacher-7046

11/11/2022, 3:55 PM
You might need to specify the schema and/or database name for your table. So instead of
events
, it would be
myschema.events
s

some-lizard-62413

11/11/2022, 3:55 PM
Good idea. I actually tried that already. 🙂
Copy code
SELECT
  user_id,
  user_anonymous_id AS anonymous_id,
  utc_time as timestamp,
  1 as value
FROM
  public.events
WHERE
  event_type = 'pageview'
f

future-teacher-7046

11/11/2022, 3:56 PM
Hmm. Could it be a permissions error?
s

some-lizard-62413

11/11/2022, 3:56 PM
Let me try something… When I created the Jitsu connection, I did not specify the schema.
Jeremy - this was actually a boneheaded mistake on my part. Apologies.
Thank you for being so responsive.
f

future-teacher-7046

11/11/2022, 3:58 PM
No worries. Glad you figured it out
9 Views