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

⭐ 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!

for 2, you can edit that query from the data source page to add the prefix

> 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

did you add the details to the connection info modal?

The connection itself works. I can query metrics fine. It's just the discover metrics feature that doesn't seem to work

@billions-xylophone-11752 may be able to help you when he’s up

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?