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

breezy-summer-94671

11/23/2023, 2:08 AM
Hello, does the Segment Data Source support Postgres as a warehouse? I'm having some issues 1. When I try "Discover Metrics" it shows an error that says
relation "tracks" does not exist
which is not true, it does exist 2. I am able to set up a metric manually with SQL but when I go to analyse the results of an experiment, the query fails and says
relation "experiment_viewed" does not exist
It seems that the generated SQL does not include the schema/prefix that it should be including in order to access my warehouse, like it is for the actual metric
r

rhythmic-agent-34208

11/23/2023, 2:08 AM
Our official support hours are 6:30am - 5pm Pacific Time, Monday through Friday. You may occasionally hear from us outside of these hours. Your support request has been logged in our system. Our support team will get back to you very soon!
f

fresh-football-47124

11/23/2023, 4:50 AM
for 2, you can edit that query from the data source page to add the prefix
not sure about 1 - could it be permissions? you can edit the connection info to set any prefixes required for the default Segment queries
(it wont automatically change any existing queries)
b

breezy-summer-94671

11/23/2023, 5:29 AM
> for 2, you can edit that query from the data source page to add the prefix Ah yes, it's this Experiment Assignment Queries under the datasource 🙏 It's not permissions, I have logged on with the same user details and able to query the tracks table
f

fresh-football-47124

11/23/2023, 5:30 AM
did you add the details to the connection info modal?
there is an ‘edit connection info’ on the top of the data source page
should open a modal
on the bottom of that
b

breezy-summer-94671

11/23/2023, 5:31 AM
The connection itself works. I can query metrics fine. It's just the discover metrics feature that doesn't seem to work
f

fresh-football-47124

11/30/2023, 5:15 AM
@billions-xylophone-11752 may be able to help you when he’s up
b

billions-xylophone-11752

11/30/2023, 1:20 PM
Hey, Chris - Sorry to hear you're having trouble with the Discover Metrics feature. Can you send me a private DM of the metric & query for one of the manual metrics you've created?
This should help give me some insight into the structure of your Postgres data source to provide some insight.
4 Views